Copy and Edit

SAP HANA PROFESSIONAL 2014

Description

Quiz on SAP HANA PROFESSIONAL 2014, created by kim b on 04/09/2015.
kim b
Quiz by kim b, updated more than 1 year ago
kim b
Created by kim b about 9 years ago
144
1
0

Resource summary

Question 1

Question
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?
Answer
  • 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.

Question 2

Question
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?
Answer
  • A. Central Management Console
  • B. Information Design Tool
  • C. Web Intelligence D. SAP HANA Studio
  • D. SAP HANA Studio

Question 3

Question
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?
Answer
  • A. Data preview
  • B. View contents
  • C. View log
  • D. SQL console

Question 4

Question
Which SAP HANA privileges are used for administration tasks such as creating schemas?
Answer
  • A. System privileges
  • B. Package privileges
  • C. Analytic privileges
  • D. Application privileges

Question 5

Question
Which delivered role is mandatory for a system administrator in SAP HANA?
Answer
  • A. SYS_ADMIN
  • B. CONTENT_ADMIN
  • C. SAP_ALL
  • D. IC MODELER

Question 6

Question
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)
Answer
  • 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.

Question 7

Question
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three)
Answer
  • A. Define a projection.
  • B. Write an SQL script.
  • C. Save and activate the view.
  • D. Define output fields.
  • E. Choose a data source.

Question 8

Question
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 :-)
Answer
  • A. RFC
  • B. ODBC/JDBC
  • C. BICS
  • D. ODBO

Question 9

Question
What is an example of a selective data load using SAP Landscape Transformation?
Answer
  • 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.

Question 10

Question
What is the purpose of a template table in SAP BusinessObjects Data Services?
Answer
  • 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

Question 11

Question
You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? (Choose two)
Answer
  • 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

Question 12

Question
You modify an existing view. How can you determine which models are affected by this change?
Answer
  • 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.

Question 13

Question
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?
Answer
  • A. The Audit log
  • B. Entries in M_CONNECTIONS
  • C. The nameserver_history.trc file
  • D. The indexserver_alert.trc file

Question 14

Question
Which of the following criteria indicate that you should store data in row tables? (Choose two)
Answer
  • 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.

Question 15

Question
In which engines is an analytic view executed that contains a calculated column? (Choose two)
Answer
  • A. Calculation engine
  • B. Row store engine
  • C. OLAP engine
  • D. Join engine

Question 16

Question
Which of the following are recommended SAP HANA modeling principles? (Choose two)
Answer
  • 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

Question 17

Question
Where can you reactivate a user after too many invalid logon attempts? (Choose two)
Answer
  • A. In the SQL console
  • B. In the user specific schema
  • C. In the INVALID_CONNECT_ATTEMPS view
  • D. In the user properties

Question 18

Question
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?
Answer
  • 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.

Question 19

Question
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?
Answer
  • A. Disaster recovery
  • B. Scale up
  • C. Side-by-side scenario
  • D. Scale out high availability

Question 20

Question
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)
Answer
  • A. Fixed-scope implementation
  • B. No need for consultants
  • C. Lower risk
  • D. Pre-configured content
  • E. Customized content

Question 21

Question
Your data models use hierarchies. In which front end tool can you access these hierarchies? (Choose two)
Answer
  • 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

Question 22

Question
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?
Answer
  • A. JOIN in a calculation view
  • B. JOIN in an analytic view
  • C. UNION in a calculation view
  • D. PROJECTION in a calculation view

Question 23

Question
Which of the following can be grouped when multiple schemas exist in an SAP HANA database?
Answer
  • A. Information models
  • B. Data tables
  • C. Packages
  • D. Users

Question 24

Question
Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)
Answer
  • 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

Question 25

Question
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?
Answer
  • A. Analytic view
  • B. Calculation view using SQL
  • C. Calculation view using SQL Script
  • D. Attribute view

Question 26

Question
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
Answer
  • A. Crystal Reports
  • B. Dashboards
  • C. Explorer
  • D. WebIntelligence

Question 27

Question
You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?
Answer
  • 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.

Question 28

Question
If you want to create or drop tables in a schema, which privilege type do you need?
Answer
  • A. SYSTEM
  • B. ANALYTIC
  • C. PACKAGE
  • D. SQL

Question 29

Question
Which security settings can you apply in analytic privileges? (Choose two)
Answer
  • 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.

Question 30

Question
Which tool do you use for complex data transformation of SAP ERP data?
Answer
  • A. SAP Landscape Transformation (SLT)
  • B. Sybase Replication Server
  • C. SAP BusinessObjects Data Services
  • D. SAP BusinessObjects Explorer

Question 31

Question
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)
Answer
  • 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.

Question 32

Question
Which of the following describes an SAP HANA analytic view?
Answer
  • 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.

Question 33

Question
Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)
Answer
  • 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.

Question 34

Question
Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
Answer
  • A. Only the last active version
  • B. All active and inactive versions
  • C. All active versions
  • D. The last active and inactive version

Question 35

Question
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?
Answer
  • A. SAP NetWeaver BW master data tables
  • B. DataStore Objects (DSOs)
  • C. ABAP system tables
  • D. Persistent Staging Area (PSA) tables

Question 36

Question
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)
Answer
  • 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.

Question 37

Question
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)
Answer
  • A. History function
  • B. Auto Documentation function
  • C. Display XML function
  • D. Where-Used function

Question 38

Question
Which of the following tools use SQL to communicate with SAP HANA? (Choose three)
Answer
  • 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

Question 39

Question
Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)
Answer
  • A. SQL plan cache
  • B. Timeline
  • C. Explain plan
  • D. Visualize plan

Question 40

Question
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)
Answer
  • 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.

Question 41

Question
How can you define conditions and actions in a decision table? (Choose three)
Answer
  • A. Use ABAP routines
  • B. Use conditional expressions
  • C. Use CE functions
  • D. Use date operations
  • E. Use mathematical operations

Question 42

Question
Which of the following can you use to implement currency conversion in an information model? (Choose two)
Answer
  • 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

Question 43

Question
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?
Answer
  • 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
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Key Definitions for organic chemistry
katburr23
Cory & Manuel_1
Prudensiano Manu
Key Events, People and Terms of the French Revolution
poppwalton
Magnetism
joan.march
OCR Gateway Biology Flash Cards
Sam Newey
Physics P2
Phoebe Drew
B2, C2, P2
George Moores
Mind Maps with GoConqr
croconnor
The Functionalist perspective on education
Phoebe Fletcher
Forces and motion
Catarina Borges
Geometry
Idil Mogeh
Browse Library