You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

• A.Calculated columns
• B.Joins
• C.Filters
• D.Data sources of unions

Comment: *

Name: *

Email: *

Verification: *

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

• A.Use dynamic SQL.
• B.Choose declarative language instead of imperative language.
• C.Break up large statements by using variables.
• D.Control the flow logic using IF-THEN-ELSE conditions.

Comment: *

Name: *

Email: *

Verification: *

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

• A.To improve data replication performance on large row tables
• B.To improve query performance when accessing large column tables
• C.To overcome the 2 billion record limit
• D.To improve response time when multiple users access the same table

Comment: *

Name: *

Email: *

Verification: *

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue. What could be the reason? Note: There are 2 correct answers to this question.

• A.The .hdinamespace file specifies a different namespace property than the one in the identifier of the calculation view.
• B.An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.
• C.The imported calculation view and its data source have different namespaces.
• D.The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

Comment: *

Name: *

Email: *

Verification: *

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference.
Afterward, you perform the following deploy operations: Deploy the DIMENSION calculation view as a single object. / Deploy the entire SAP HANA database module. / What is the outcome of the deploy operations?

• A.(a) The first deployment is successful. (b) The second deployment fails.
• B.(a) The first deployment fails. (b) The second deployment is successful.
• C.(a) The first deployment is successful. (b) The second deployment is successful.
• D.(a)The first deployment fails. (b) The second deployment fails.

Comment: *

Name: *

Email: *

Verification: *