Quiz
SAP HANA PROFESSIONAL 2014
Dieses Quiz hat ein Zeitlimit und öffnet sich deshalb im gewohnten Player.
Fragen in diesem Quiz (43)
1What 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?
- AA. Triggers and logging tables are deleted.
- BB. The table is dropped from the SAP HANA database.
- CC. Triggers and logging tables are kept.
- DD. The replication of the table is temporarily stopped.
- AA. Triggers and logging tables are deleted.
2You 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?- AA. Central Management Console
- BB. Information Design Tool
- CC. Web Intelligence
D. SAP HANA Studio - DD. SAP HANA Studio
- AA. Central Management Console
3Prior 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?- AA. Data preview
- BB. View contents
- CC. View log
- DD. SQL console
- AA. Data preview
4Which SAP HANA privileges are used for administration tasks such as creating schemas?
- AA. System privileges
- BB. Package privileges
- CC. Analytic privileges
- DD. Application privileges
- AA. System privileges
5Which delivered role is mandatory for a system administrator in SAP HANA?
- AA. SYS_ADMIN
- BB. CONTENT_ADMIN
- CC. SAP_ALL
- DD. IC MODELER
- AA. SYS_ADMIN
6Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)
- AA. Install SAP Business Warehouse Accelerator (BWA).
- BB. Perform a database migration from your current DB to SAP HANA DB.
- CC. Execute the report RS_BW_POST_MIGRATION.
- DD. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.
- EE. Recreate SAP BW indexes after SAP HANA database migration.
- AA. Install SAP Business Warehouse Accelerator (BWA).
7You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
(Choose three)- AA. Define a projection.
- BB. Write an SQL script.
- CC. Save and activate the view.
- DD. Define output fields.
- EE. Choose a data source.
- AA. Define a projection.
8Which 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 :-)- AA. RFC
- BB. ODBC/JDBC
- CC. BICS
- DD. ODBO
- AA. RFC
9What is an example of a selective data load using SAP Landscape Transformation?
- AA. Selected data field values are randomized and loaded into SAP HANA.
- BB. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
- CC. Selected data for transformation is split into portions.
- DD. Selected data for a range of years is loaded into SAP HANA.
- AA. Selected data field values are randomized and loaded into SAP HANA.
10What is the purpose of a template table in SAP BusinessObjects Data Services?
- AA. To create pre-designed information models
- BB. To fill an existing target table with new data
- CC. To read source data and perform data transformations
D. To create a target table and fill this table with data - DD. To create a target table and fill this table with data
- AA. To create pre-designed information models
11You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)- AA. In the Catalog node of SAP HANA studio
- BB. In the SAP BusinessObjects Data Services job monitor
- CC. In the Content node of SAP HANA studio
- DD. In the SAP BusinessObjects Data Services table preview
- AA. In the Catalog node of SAP HANA studio
12You modify an existing view. How can you determine which models are affected by this change?
- AA. Use the audit trail.
- BB. Use the History feature for the changed model.
- CC. Use the "Where-Used List" feature for the changed model.
- DD. Use the "Auto Documentation" to compare the object version of the changed model.
- AA. Use the audit trail.
13You need to find out which users logged on to the SAP HANA system over the course of the last week.
What would you check?- AA. The Audit log
- BB. Entries in M_CONNECTIONS
- CC. The nameserver_history.trc file
- DD. The indexserver_alert.trc file
- AA. The Audit log
14Which of the following criteria indicate that you should store data in row tables?
(Choose two)- AA. The tables have a large number of columns.
- BB. The tables require frequent write access.
- CC. The information models search the table based on the values of a few columns.
- DD. The information models frequently needs to access complete records.
- AA. The tables have a large number of columns.
15In which engines is an analytic view executed that contains a calculated column? (Choose two)
- AA. Calculation engine
- BB. Row store engine
- CC. OLAP engine
- DD. Join engine
- AA. Calculation engine
16Which of the following are recommended SAP HANA modeling principles?
(Choose two)- AA. Use complex expressions like IF or CASE
- BB. Always do the calculation after aggregation
- CC. Filter the data amount as early as possible in the lower layers
- DD. Join tables on key columns
- AA. Use complex expressions like IF or CASE
17Where can you reactivate a user after too many invalid logon attempts? (Choose two)
- AA. In the SQL console
- BB. In the user specific schema
- CC. In the INVALID_CONNECT_ATTEMPS view
- DD. In the user properties
- AA. In the SQL console
18You 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?- AA. The filter condition is not set within square brackets.
- BB. The projection list contains a field that is not specified in the filter condition.
- CC. The filter condition must be specified inside the projection list.
- DD. The filter condition contains a field that is not part of the projection list.
- AA. The filter condition is not set within square brackets.
19The 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?- AA. Disaster recovery
- BB. Scale up
- CC. Side-by-side scenario
- DD. Scale out high availability
- AA. Disaster recovery
20What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)
- AA. Fixed-scope implementation
- BB. No need for consultants
- CC. Lower risk
- DD. Pre-configured content
- EE. Customized content
- AA. Fixed-scope implementation
21Your data models use hierarchies.
In which front end tool can you access these hierarchies? (Choose two)- AA. SAP BusinessObjects Dashboards
- BB. SAP BusinessObjects Crystal Reports 2011
- CC. SAP BusinessObjects Analysis, edition for OLAP
- DD. SAP BusinessObjects Analysis, edition for Microsoft Office
- AA. SAP BusinessObjects Dashboards
22You 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?- AA. JOIN in a calculation view
- BB. JOIN in an analytic view
- CC. UNION in a calculation view
- DD. PROJECTION in a calculation view
- AA. JOIN in a calculation view
23Which of the following can be grouped when multiple schemas exist in an SAP HANA database?
- AA. Information models
- BB. Data tables
- CC. Packages
- DD. Users
- AA. Information models
24Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)
- AA. It is based on analytic denormalized data models
- BB. It uses real-time replication of time-critical data
- CC. It runs directly on top of the operational data
- DD. It persists transformed data
- AA. It is based on analytic denormalized data models
25Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?
- AA. Analytic view
- BB. Calculation view using SQL
- CC. Calculation view using SQL Script
- DD. Attribute view
- AA. Analytic view
26Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
- AA. Crystal Reports
- BB. Dashboards
- CC. Explorer
- DD. WebIntelligence
- AA. Crystal Reports
27You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?
- AA. Use the Activate with History function.
- BB. Use the Where-Used List function.
- CC. Use the Cascade Activate function.
- DD. Activate each view manually.
- AA. Use the Activate with History function.
28If you want to create or drop tables in a schema, which privilege type do you need?
- AA. SYSTEM
- BB. ANALYTIC
- CC. PACKAGE
- DD. SQL
- AA. SYSTEM
29Which security settings can you apply in analytic privileges? (Choose two)
- AA. Grant access to analytic views.
- BB. Restrict access within an analytic view using measure values.
- CC. Restrict access within an analytic view using attribute values.
- DD. Restrict access to hierarchies.
- AA. Grant access to analytic views.
30Which tool do you use for complex data transformation of SAP ERP data?
- AA. SAP Landscape Transformation (SLT)
- BB. Sybase Replication Server
- CC. SAP BusinessObjects Data Services
- DD. SAP BusinessObjects Explorer
- AA. SAP Landscape Transformation (SLT)
31Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)
- AA. Define an output structure for the attribute view.
- BB. Define the data foundation.
- CC. Choose the type of hierarchy.
- DD. Define calculated attributes for the nodes of the hierarchy.
- EE. Define an analytic view.
- AA. Define an output structure for the attribute view.
32Which of the following describes an SAP HANA analytic view?
- AA. It is a set of tables joined together in a star schema.
- BB. It is a copy of data after transformation.
- CC. It is a reusable object in attribute views.
- DD. It is a materialized set of data.
- AA. It is a set of tables joined together in a star schema.
33Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)
- AA. Generate and save an export file to a shared directory.
- BB. Assign the content repository to a transport request.
- CC. Mass copy the content repository into the other SAP HANA system.
- DD. Assign the package to a delivery unit.
- AA. Generate and save an export file to a shared directory.
34Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
- AA. Only the last active version
- BB. All active and inactive versions
- CC. All active versions
- DD. The last active and inactive version
35You 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?- AA. SAP NetWeaver BW master data tables
- BB. DataStore Objects (DSOs)
- CC. ABAP system tables
- DD. Persistent Staging Area (PSA) tables
- AA. SAP NetWeaver BW master data tables
36Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)
- AA. The sizing of your current SAP BW application servers remains valid.
- BB. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
- CC. It allows re-use of your available SAP BW application servers.
- DD. It eliminates the need to upgrade to the latest SAP BW application version.
- EE. The system usage is the same as an equivalent SAP BW on non-SAP databases.
- AA. The sizing of your current SAP BW application servers remains valid.
37When 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)- AA. History function
- BB. Auto Documentation function
- CC. Display XML function
- DD. Where-Used function
- AA. History function
38Which of the following tools use SQL to communicate with SAP HANA? (Choose three)
- AA. SAP BusinessObjects Web Intelligence
- BB. SAP BusinessObjects Analysis, edition for OLAP
- CC. SAP BusinessObjects Information Design Tool
- DD. SAP BusinessObjects Analysis, edition for Microsoft Office
- EE. SAP BusinessObjects Dashboards
- AA. SAP BusinessObjects Web Intelligence
39Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)
- AA. SQL plan cache
- BB. Timeline
- CC. Explain plan
- DD. Visualize plan
- AA. SQL plan cache
40You 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)- AA. Automate the ETL processes in SAP NetWeaver using process chains.
- BB. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.
- CC. Create new InfoObjects for the SAP HANA InfoProviders.
- DD. Schedule the real-time data loads into SAP HANA.
- AA. Automate the ETL processes in SAP NetWeaver using process chains.
41How can you define conditions and actions in a decision table? (Choose three)
- AA. Use ABAP routines
- BB. Use conditional expressions
- CC. Use CE functions
- DD. Use date operations
- EE. Use mathematical operations
- AA. Use ABAP routines
42Which of the following can you use to implement currency conversion in an information model? (Choose two)
- AA. A calculated column in a calculation view
- BB. A restricted column in an analytic view
- CC. A calculated column in an analytic view
- DD. A calculated column in an attribute view
- AA. A calculated column in a calculation view
43Your 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?- AA. SAP Bank Analyzer with SAP HANA
- BB. SAP Deposits Management with SAP HANA
- CC. SAP HANA CO-PA Accelerator
- DD. SAP HANA for Banking
- AA. SAP Bank Analyzer with SAP HANA
Informationen
- Beschreibung
- Quiz am SAP HANA PROFESSIONAL 2014, erstellt von kim b am 04/09/2015.
- Autor
- kim b
- Sprache
- English
- Aufrufe
- 155
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz