SAP HANA: Certification Questions 291 through 300

QUESTION: 291

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance? 
A. Universe 
B. Web Intelligence report 
C. Analytic view
D. Calculation view using an Attribute value variable

Answer: C

QUESTION: 292

You want to use an extractor to build a model in SAP HANA. Which table can you use to view detailed information about the extractor?

A. BSEG 

B. RODELTAM 

C. ROOSOURCE 

D. RSOLTPSOURCE 

Answer: C

QUESTION: 293

You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?

Note:  There are multiple correct answers to the question

A. Remove ALTER SYSTEM in the system privileges for the modeling users

B. Use randomized data for the development of data models

C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system

D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users

Answer: B, C

QUESTION: 294

When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows? 

A. Remove all filters from the analytic views

B. Deactivate the Limit Size of Result Set parameter in the business layer

C. Set the Array Fetch Size parameter to the maximum in the relational connection

D. Deactivate the Limit Size of Result Set parameter in the Central Management Console

Answer: B

QUESTION: 295

Which of the following properties of a derived attribute view can you modify?

A. Description 

B. Description mapping

C. Calculated attributes

D. Filters 

Answer: A

QUESTION: 296

Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface?
Note:  There are multiple correct answers to the question

A. Projection

B. Union

C. Intersect

D. Aggregation

Answer: A, B

QUESTION: 297

Which data store type is recommended for write-intensive scenarios? 

A. Row store

B. Column store

C. Object store

D. Table store

Answer: A

QUESTION: 298

Which delivered role is mandatory for a system administrator in SAP HANA? 

A. SYS_ADMIN

B. IC MODELER

C. CONTENT_ADMIN

D. SAP_ALL

Answer: C

QUESTION: 299

What is the purpose of the savepoint process in SAP HANA? 

A. Free-up memory by saving less used data to the persistent storage

B. Save changed data and logs to the persistent storage on a regular basis

C. Save changed data to the persistent storage when a transaction is committed

D. Save logs to persistent storage when a transaction is committed

Answer: B

QUESTION: 300

Which best practices should you apply when you use SQL script in SAP HANA? 
Note:  There are multiple correct answers to the question
A. Use the WHERE clause for updates
B. Use UNION ALL instead of UNION
C. Use dynamic SQL with variables
D. Use Cursors
E. Use CE functions

Answer: A, B, E