Modeling Question Section

Modeling

Qs:1 Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)


A. Data Foundation 
B. Aggregation 
C. Join 
D. Analytic Privilege

Qs:3 Which of the following can be part of an analytic view? (Choose three)

A. Query transformation 
B. Unions 
C. Logical joins 
D. Data foundation 
E. Attributes

Qs:12 Which of the following can you use as a source for a graphical calculation view? (Choose three)

A. Calculation view 
B. SQL view 
C. Decision table 
D. Table E. Procedure

Qs:18 Where is the physical data stored, on which a calculation view is based?

A. In the _SYS_BI schema 
B. In a schema 
C. In the _SYS_BIC schema 
D. In a package

Qs:19 Which of the following automatically aggregates data? (Choose two)

A. Analytic view 
B. Calculation view 
C. Column table 
D. Attribute view

Qs:25 You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you implement these restrictions? (Choose two)

A. The schema mapping 
B. The restricted measures 
C. The analytic privileges 
D. The universe


Qs:29 What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME

A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'. 
B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'. 
C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'. 
D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

Qs:33 Which of the following are required elements when you create any type of hierarchy in SAP HANA? (Choose two

A. A child node 
B. An analytic view 
C. A data foundation 
D. An attribute view

Qs:36 How can you restrict SAP HANA modeling users from viewing sensitive data?

A. Use scrambled source data. 
B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. 
C. Use the pre-delivered MODELER role. 
D. Remove ALTER SYSTEM in the system privileges for the modeling 

Qs:37 An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to the same country attribute view twice. What must you create to achieve this?

A. A derived attribute view 
B. A shared attribute view 
C. Two data foundations 
D. An attribute view using the Copy From method.

Qs:41 Which of the following are required to create an attribute view? (Choose two)

A. Data Foundation 
B. Default Schema 
C. Join 
D. Key Attribute

Qs:43 Which of the following are required to build a SQLScript calculation view? (Choose two)

A. Define a data foundation. 
B. Define a measure. 
C. Set the MultiDimensional Reporting property to false. 
D. Add columns to the var_out output parameter.

Qs:45 Which of the following can you use to build the data foundation for an attribute view? (Choose two)

A. Referential Join 
B. Union 
C. Projection 
D. Text Join

Qs:48 How can you create a computed column in an information model? (Choose two)

A. Create a calculated attribute within a calculation view. 
B. Create a counter in an analytic view. 
C. Create a restricted measure in a calculation view. 
D. Create a restricted measure in an analytic view.

Qs:49 You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?

A. Referential join 
B. Projection node 
C. Aggregation node 
D. Union