Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Login / Register

Question # 4

What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

A.

Data architect

B.

Modeler

C.

Kubernetes expert

D.

ABAP developer

Full Access
Question # 5

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

A.

Fiscal

B.

Julian

C.

Gregorian

D.

Factory

Full Access
Question # 6

You want to join two tables in a calculation view.Why do you use a non-equi join?

A.

Join columns have different data types.

B.

The number of joined columns is different in each table.

C.

Join columns need to be ignored when NOT requested by the query.

D.

The join condition is not represented by matching values.

Full Access
Question # 7

What do you use in the definition of a dynamic SQL analytic privilege?

A.

A table function that returns a list of allowed values.

B.

A scalar function that returns a list of the allowed values for each attribute.

C.

A procedure that returns the data access condition as an SQL expression.

D.

An organization hierarchy that provides role-based access to data.

Full Access
Question # 8

Why would you choose to implement a referential join?

A.

To develop a series of linked joins

B.

To define conditions for potential data source pruning

C.

To reuse the settings of an existing join

D.

To automate the setting of cardinality rules

Full Access
Question # 9

You have products that appear in table A and sometimes they also appear in table B. You want to select the products that appear ONLY in table A. Which node type do you use?

A.

Aggregation

B.

Minus

C.

Intersect

D.

Union

Full Access
Question # 10

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

A.

Projection

B.

Join

C.

Union

D.

Aggregation

Full Access
Question # 11

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

A.

Tables

B.

CUBE calculation view

C.

DIMENSION calculation view

D.

Table functions

Full Access
Question # 12

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A.

SQL expression

B.

Dynamic

C.

Hierarchy function

D.

Attributes

E.

Graph

Full Access
Question # 13

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

A.

Your function includes a TRUNCATE statement.

B.

Your function refers to a scalar function.

C.

You did NOT define a valid table type.

D.

You did not define at least one input parameter.

Full Access
Question # 14

A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

A.

7 months

B.

3 months

C.

2 weeks

D.

1 year

Full Access
Question # 15

When is the first column store compression executed?

A.

When a delta merge is triggered

B.

When the table is created

C.

When partitions are regenerated

D.

When a backup is started

E.

Question

Full Access
Question # 16

Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

A.

To automate the generation of the code

B.

To pass parameters from calculation views

C.

To exploit additional data types

D.

To include ABAP syntax in the code

E.

To implement conditional logic

Full Access
Question # 17

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

A.

Analytics

B.

Intelligent Suite

C.

Experience Management

D.

Application Development & Integration

Full Access
Question # 18

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

A.

Higher data compression rates

B.

Improved write performance on frequent updates

C.

Additional indexes are used

D.

Parallel access is improved

E.

Higher performance for query operations

Full Access
Question # 19

In a calculation view, what is the purpose of a variable?

A.

To pass values between procedures and calculation views

B.

To provide a dynamic value in a calculated column

C.

To break up complex SQL into smaller steps

D.

To filter an attribute at runtime based on a user input

Full Access
Question # 20

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

A.

Usage statistics of the calculation view

B.

Joins that are defined on calculated columns

C.

Information about join cardinality

D.

Expected memory consumption

Full Access
Question # 21

Why would you write your SQL code in a procedure instead of a function? Note: There are 3 correct answers to this question.

A.

To modify the content of a table

B.

To process input parameters

C.

To implement SQLScript syntax

D.

To develop a dynamic analytic privilege

E.

To generate multiple tabular output data sets

Full Access
Question # 22

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

A.

Specify the join cardinality

B.

Limit the number of joined columns

C.

Use an inner join

D.

Define join direction in a full outer join

Full Access
Question # 23

You have generated a calculation view properties file.What does it contain?

A.

Descriptions of all objects defined in a calculation view

B.

All settings defined in a calculation view

C.

Dependencies between calculation views

D.

Documentation to support the calculation view

Full Access
Question # 24

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

A.

You already mapped the input parameters in another calculation view.

B.

The names of the input parameters do not match.

C.

You selected the wrong parameter mapping TYPE.

D.

Your source calculation view is of type DIMENSION.

Full Access
Question # 25

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

A.

To warn of potential performance issues related to calculated columns

B.

To display the execution time of a calculation view

C.

To identify the root data sources of a function

D.

To preview data at the node level of a calculation view

Full Access
Question # 26

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

A.

Deploy the folder that contained the deleted design-time file.

B.

Execute a DROP statement in an SQL Console connected to the HDI container.

C.

Deploy the project that contained the deleted design-time file.

D.

Execute the refactor function for the calculation view.

Full Access