3365126
Pregunta 1
Pregunta
What are the consequences of executing the stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?
Respuesta
-
A. Triggers and logging tables are deleted.
-
B. The table is dropped from the SAP HANA database.
-
C. Triggers and logging tables are kept.
-
D. The replication of the table is temporarily stopped.
Pregunta 2
Pregunta
You want to add a calculated column to an SAP BusinessObjects Web Intelligence report.
In which application do you create the calculation to achieve best report performance?
Respuesta
-
A. Central Management Console
-
B. Information Design Tool
-
C. Web Intelligence D. SAP HANA Studio
-
D. SAP HANA Studio
Pregunta 3
Pregunta
Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database.
Which SAP HANA tool would you use?
Respuesta
-
A. Data preview
-
B. View contents
-
C. View log
-
D. SQL console
Pregunta 4
Pregunta
Which SAP HANA privileges are used for administration tasks such as creating schemas?
Respuesta
-
A. System privileges
-
B. Package privileges
-
C. Analytic privileges
-
D. Application privileges
Pregunta 5
Pregunta
Which delivered role is mandatory for a system administrator in SAP HANA?
Respuesta
-
A. SYS_ADMIN
-
B. CONTENT_ADMIN
-
C. SAP_ALL
-
D. IC MODELER
Pregunta 6
Pregunta
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)
Respuesta
-
A. Install SAP Business Warehouse Accelerator (BWA).
-
B. Perform a database migration from your current DB to SAP HANA DB.
-
C. Execute the report RS_BW_POST_MIGRATION.
-
D. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.
-
E. Recreate SAP BW indexes after SAP HANA database migration.
Pregunta 7
Pregunta
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
(Choose three)
Respuesta
-
A. Define a projection.
-
B. Write an SQL script.
-
C. Save and activate the view.
-
D. Define output fields.
-
E. Choose a data source.
Pregunta 8
Pregunta
Which connection method that is listed on the left can you use with the tools that are available in the dropdown box on the right?
Guess that there should have been a photo here :-)
Respuesta
-
A. RFC
-
B. ODBC/JDBC
-
C. BICS
-
D. ODBO
Pregunta 9
Pregunta
What is an example of a selective data load using SAP Landscape Transformation?
Respuesta
-
A. Selected data field values are randomized and loaded into SAP HANA.
-
B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
-
C. Selected data for transformation is split into portions.
-
D. Selected data for a range of years is loaded into SAP HANA.
Pregunta 10
Pregunta
What is the purpose of a template table in SAP BusinessObjects Data Services?
Respuesta
-
A. To create pre-designed information models
-
B. To fill an existing target table with new data
-
C. To read source data and perform data transformations D. To create a target table and fill this table with data
-
D. To create a target table and fill this table with data
Pregunta 11
Pregunta
You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)
Respuesta
-
A. In the Catalog node of SAP HANA studio
-
B. In the SAP BusinessObjects Data Services job monitor
-
C. In the Content node of SAP HANA studio
-
D. In the SAP BusinessObjects Data Services table preview
Pregunta 12
Pregunta
You modify an existing view. How can you determine which models are affected by this change?
Respuesta
-
A. Use the audit trail.
-
B. Use the History feature for the changed model.
-
C. Use the "Where-Used List" feature for the changed model.
-
D. Use the "Auto Documentation" to compare the object version of the changed model.
Pregunta 13
Pregunta
You need to find out which users logged on to the SAP HANA system over the course of the last week.
What would you check?
Respuesta
-
A. The Audit log
-
B. Entries in M_CONNECTIONS
-
C. The nameserver_history.trc file
-
D. The indexserver_alert.trc file
Pregunta 14
Pregunta
Which of the following criteria indicate that you should store data in row tables?
(Choose two)
Respuesta
-
A. The tables have a large number of columns.
-
B. The tables require frequent write access.
-
C. The information models search the table based on the values of a few columns.
-
D. The information models frequently needs to access complete records.
Pregunta 15
Pregunta
In which engines is an analytic view executed that contains a calculated column? (Choose two)
Respuesta
-
A. Calculation engine
-
B. Row store engine
-
C. OLAP engine
-
D. Join engine
Pregunta 16
Pregunta
Which of the following are recommended SAP HANA modeling principles?
(Choose two)
Respuesta
-
A. Use complex expressions like IF or CASE
-
B. Always do the calculation after aggregation
-
C. Filter the data amount as early as possible in the lower layers
-
D. Join tables on key columns
Pregunta 17
Pregunta
Where can you reactivate a user after too many invalid logon attempts? (Choose two)
Respuesta
-
A. In the SQL console
-
B. In the user specific schema
-
C. In the INVALID_CONNECT_ATTEMPS view
-
D. In the user properties
Pregunta 18
Pregunta
You receive an activation error in a scripted calculation view that uses the following function:
CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')
What could be a reason for this error?
Respuesta
-
A. The filter condition is not set within square brackets.
-
B. The projection list contains a field that is not specified in the filter condition.
-
C. The filter condition must be specified inside the projection list.
-
D. The filter condition contains a field that is not part of the projection list.
Pregunta 19
Pregunta
The IT department has a service level agreement (SLA) that states "all production systems must be available to the end user within ½ hour of any type of system failure."
Which of the following helps meet the SLA for SAP HANA system failures?
Respuesta
-
A. Disaster recovery
-
B. Scale up
-
C. Side-by-side scenario
-
D. Scale out high availability
Pregunta 20
Pregunta
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)
Respuesta
-
A. Fixed-scope implementation
-
B. No need for consultants
-
C. Lower risk
-
D. Pre-configured content
-
E. Customized content
Pregunta 21
Pregunta
Your data models use hierarchies.
In which front end tool can you access these hierarchies? (Choose two)
Respuesta
-
A. SAP BusinessObjects Dashboards
-
B. SAP BusinessObjects Crystal Reports 2011
-
C. SAP BusinessObjects Analysis, edition for OLAP
-
D. SAP BusinessObjects Analysis, edition for Microsoft Office
Pregunta 22
Pregunta
You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?
Respuesta
-
A. JOIN in a calculation view
-
B. JOIN in an analytic view
-
C. UNION in a calculation view
-
D. PROJECTION in a calculation view
Pregunta 23
Pregunta
Which of the following can be grouped when multiple schemas exist in an SAP HANA database?
Respuesta
-
A. Information models
-
B. Data tables
-
C. Packages
-
D. Users
Pregunta 24
Pregunta
Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)
Respuesta
-
A. It is based on analytic denormalized data models
-
B. It uses real-time replication of time-critical data
-
C. It runs directly on top of the operational data
-
D. It persists transformed data
Pregunta 25
Pregunta
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?
Respuesta
-
A. Analytic view
-
B. Calculation view using SQL
-
C. Calculation view using SQL Script
-
D. Attribute view
Pregunta 26
Pregunta
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
Respuesta
-
A. Crystal Reports
-
B. Dashboards
-
C. Explorer
-
D. WebIntelligence
Pregunta 27
Pregunta
You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?
Respuesta
-
A. Use the Activate with History function.
-
B. Use the Where-Used List function.
-
C. Use the Cascade Activate function.
-
D. Activate each view manually.
Pregunta 28
Pregunta
If you want to create or drop tables in a schema, which privilege type do you need?
Respuesta
-
A. SYSTEM
-
B. ANALYTIC
-
C. PACKAGE
-
D. SQL
Pregunta 29
Pregunta
Which security settings can you apply in analytic privileges? (Choose two)
Respuesta
-
A. Grant access to analytic views.
-
B. Restrict access within an analytic view using measure values.
-
C. Restrict access within an analytic view using attribute values.
-
D. Restrict access to hierarchies.
Pregunta 30
Pregunta
Which tool do you use for complex data transformation of SAP ERP data?
Respuesta
-
A. SAP Landscape Transformation (SLT)
-
B. Sybase Replication Server
-
C. SAP BusinessObjects Data Services
-
D. SAP BusinessObjects Explorer
Pregunta 31
Pregunta
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)
Respuesta
-
A. Define an output structure for the attribute view.
-
B. Define the data foundation.
-
C. Choose the type of hierarchy.
-
D. Define calculated attributes for the nodes of the hierarchy.
-
E. Define an analytic view.
Pregunta 32
Pregunta
Which of the following describes an SAP HANA analytic view?
Respuesta
-
A. It is a set of tables joined together in a star schema.
-
B. It is a copy of data after transformation.
-
C. It is a reusable object in attribute views.
-
D. It is a materialized set of data.
Pregunta 33
Pregunta
Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)
Respuesta
-
A. Generate and save an export file to a shared directory.
-
B. Assign the content repository to a transport request.
-
C. Mass copy the content repository into the other SAP HANA system.
-
D. Assign the package to a delivery unit.
Pregunta 34
Pregunta
Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
Respuesta
-
A. Only the last active version
-
B. All active and inactive versions
-
C. All active versions
-
D. The last active and inactive version
Pregunta 35
Pregunta
You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes.
Which of the following information objects are stored on the master node?
Respuesta
-
A. SAP NetWeaver BW master data tables
-
B. DataStore Objects (DSOs)
-
C. ABAP system tables
-
D. Persistent Staging Area (PSA) tables
Pregunta 36
Pregunta
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)
Respuesta
-
A. The sizing of your current SAP BW application servers remains valid.
-
B. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
-
C. It allows re-use of your available SAP BW application servers.
-
D. It eliminates the need to upgrade to the latest SAP BW application version.
-
E. The system usage is the same as an equivalent SAP BW on non-SAP databases.
Pregunta 37
Pregunta
When you try to delete an attribute view you receive the error message "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view? (Choose two)
Respuesta
-
A. History function
-
B. Auto Documentation function
-
C. Display XML function
-
D. Where-Used function
Pregunta 38
Pregunta
Which of the following tools use SQL to communicate with SAP HANA? (Choose three)
Respuesta
-
A. SAP BusinessObjects Web Intelligence
-
B. SAP BusinessObjects Analysis, edition for OLAP
-
C. SAP BusinessObjects Information Design Tool
-
D. SAP BusinessObjects Analysis, edition for Microsoft Office
-
E. SAP BusinessObjects Dashboards
Pregunta 39
Pregunta
Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)
Respuesta
-
A. SQL plan cache
-
B. Timeline
-
C. Explain plan
-
D. Visualize plan
Pregunta 40
Pregunta
You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.
Which of the following are SAP recommended actions? (Choose two)
Respuesta
-
A. Automate the ETL processes in SAP NetWeaver using process chains.
-
B. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.
-
C. Create new InfoObjects for the SAP HANA InfoProviders.
-
D. Schedule the real-time data loads into SAP HANA.
Pregunta 41
Pregunta
How can you define conditions and actions in a decision table? (Choose three)
Respuesta
-
A. Use ABAP routines
-
B. Use conditional expressions
-
C. Use CE functions
-
D. Use date operations
-
E. Use mathematical operations
Pregunta 42
Pregunta
Which of the following can you use to implement currency conversion in an information model? (Choose two)
Respuesta
-
A. A calculated column in a calculation view
-
B. A restricted column in an analytic view
-
C. A calculated column in an analytic view
-
D. A calculated column in an attribute view
Pregunta 43
Pregunta
Your customer has the following reporting requirements:
-Real-time profitability reporting on large-scale data volumes -On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension -Cost allocation reports with significantly faster processing time
Which application do you recommend?
Respuesta
-
A. SAP Bank Analyzer with SAP HANA
-
B. SAP Deposits Management with SAP HANA
-
C. SAP HANA CO-PA Accelerator
-
D. SAP HANA for Banking
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.