SAP HANA: Certification Questions 301 through 310

QUESTION: 301
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? 
Note:  There are multiple correct answers to the question
A. Define output fields
B. Define a projection
C. Choose a data source
D. Write an SQL script
E. Save and activate the view

Answer: A, C, E

QUESTION: 302
How many result tables can a calculation view generate per session? 
A. Unlimited
B. One
C. Two
D. None

Answer: B

QUESTION: 303
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?
Note:  There are multiple correct answers to the question
A. You can use the same hardware
B. You can load unstructured data into SAP HANA
C. You can use BI Content Extractors or Function Modules
D. You can merge Data Streams
E. You can perform real-time data replication

Answer: B, C, D

QUESTION: 304
Which technologies use trigger-based replication?
Note:  There are multiple correct answers to the question
A. Near Zero Downtime
B. ABAP extractors 
C. Test Data Migration Server (TDMS)
D. Standard SQL database replication 

Answer: A, C

QUESTION: 305
Which reporting tool can you use to display native parent-child hierarchies from SAP HANA? 
A. Microsoft Excel
B. SAP BusinessObjects WebIntelligence
C. SAP BusinessObjects Analysis, edition for OLAP
D. SAP BusinessObjects Analysis, edition for Microsoft Office 

Answer: A

QUESTION: 306
What is one of the advantages of using SAP BusinessObjects Analysis edition for Microsoft Office? 
A. Direct access to attribute views in SAP HANA
B. Direct connection to SAP HANA via BICS 
C. Direct connection to SAP HANA via MDX
D. Direct access to column tables in SAP HANA 

Answer: B

QUESTION: 307
Which of the following privileges do you need to activate views?
A. SELECT option on the _SYS_BI schem
B. SELECT option on the _SYS_BIC schema
C. SELECT option on the _SYS schema
D.  SELECT option on the _SYS_REPO schema

Answer: D

QUESTION: 308
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (Universe) to access data in SAP HANA?
Note:  There are multiple correct answers to the question
A. WebIntelligence 
B. Crystal Reports 2011
C. Analysis Office v1.1
D. Crystal Reports for Enterprise
E. Dashboards 

Answer: A, D, E

QUESTION: 309
For what purpose do you use SQL Script in SAP HANA? 
Note:  There are multiple correct answers to the question
A. To combine two analytic views 
B. To shift complex calculations and logic to the client side
C. To create database procedures
D. To transfer a large amount of data between engines 
E. To achieve very high performance on SELECT statements 

Answer: A, C

QUESTION: 310
Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities? 
A. ODBO connector via SQL requests to analytic or calculation views
B. ODBC connector via MDX requests to analytic or calculation views 
C. ODBO connector via MDX requests to analytic or calculation views 
D. ODBO connector via MDX requests to column tables 

Answer: C

No comments:

Post a Comment