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

To overcome the 2 billion record limit

To improve query performance when accessing large column tables

To improve response time when multiple users access the same table

To overcome the 2 billion record limit

To improve data replication performance on large row tables

To improve query performance when accessing large column tables

Why would you enable Debug Query mode in a calculation view?

To identify data sources that are not accessed by a query

To set breakpoints and step through the execution

To identify data sources that are not accessed by a query

To understand how tables are partitioned

To check which database engines are invoked

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

Break up large statements by using variables.

Choose declarative language instead of imperative language.

Break up large statements by using variables.

Control the flow logic using IF-THEN-ELSE conditions.

Choose declarative language instead of imperative language.

What is a calculation view query snapshot?

A record of the query statement executed on a calculation view

The stored results of a query on a calculation view

The results of a query generated by a front end tool on a calculation view

A record of the query statement executed on a calculation view

A bookmark of a frequently used navigation state of a query result

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

Information about join cardinality

Joins that are defined on calculated columns

Usage statistics of the calculation view

Information about join cardinality

Joins that are defined on calculated columns

You have created a calculation view query snapshot and you want to generate an interface view. What is the purpose of the generated input parameter of the interface view?

To allow the user to select whether to run a query on the snapshot table or on the original calculation view

To map the attributes of the interface view to the original calculation view attributes

To allow the user to select whether to run a query on the snapshot table or on the original calculation view

To define the selection criteria used during the scheduled insertion of records into the snapshot table

To evaluate the analytic privileges of different users who access the snapshot table

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

Avoid defining joins on calculated columns.

Include all data flow logic within one calculation view.

Avoid defining joins on calculated columns.

Include all data flow logic within one calculation view.

Define filters on calculated columns.

Aggregate at the lowest possible node.

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?

You did not define a filter in the cache setting.

The query requests only a subset of the cached results.

You did not define a filter in the cache setting.

Your cache setting does not specify any columns.

The cache data retention period has expired.

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

The block must start with a node that defines a table as a data source.

Only one block can be defined across a stack of calculation views.

Multiple blocks can be defined only within a single calculation view.

The block must have only one start node.

The block must start with a node that defines a table as a data source.

Only one block can be defined across a stack of calculation views.

Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.

Limit the number of stacked calculation views.

Aggregate data early in the data flow.

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.

Limit the number of joined columns.

Define join direction in a full outer join.

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

The Keep flag is activated for the Customer column.

Integrity constraint is set to RIGHT.

The Country column is requested.

The Keep flag is activated for the Customer column.

Integrity constraint is set to RIGHT.

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

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

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

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

A table function that returns a list of allowed values.

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

You run a CREATE REMOTE SOURCE SQL statement to create a smart data integration remote source, but the statement fails. What could be the reason? Note: There are 2 correct answers to this question.

The credentials clause defines TYPE 'PASSWORD' but does not specify a technical user

The specified adapter is not registered with your SAP HANA system

The credentials clause defines TYPE 'PASSWORD' but does not specify a technical user

The remote system is not reached through the company network

You do not have the CREATE REMOTE SOURCE privilege on the remote system

The specified adapter is not registered with your SAP HANA system

Why do you nest flowgraphs? Note: There are 2 correct answers to this question.

To reduce flowgraph maintenance

To improve flowgraph performance

To reduce flowgraph maintenance

To access additional node types

To improve flowgraph performance

To start multiple flowgraphs at the same time

Which of the following are characteristics of the OPTIMIZED linked database feature? Note: There are 2 correct answers to this question.

The metadata of remote tables is cached on the target system

The source and target system must be SAP HANA

The metadata of remote tables is cached on the target system

Hidden virtual tables are automatically created on the target system

The source and target system must be SAP HANA

A database name is used in an SQL statement to identify the remote object

Which of the following tasks are necessary to implement data replication?Note: There are 3 correct answers to this question.

Enable the linked database feature

What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question.

The replica table always stores real-time data

You can toggle queries routing between remote table data and replica table data

You do not need to create the physical replica table manually

The consuming application always references the virtual table

The replica table always stores real-time data

You can choose your own replica table name

You can toggle queries routing between remote table data and replica table data

You do not need to create the physical replica table manually

What is the purpose of a remote subscription?

To update data in a local table based on changes made to a remote table

To establish a connection to the replication service

To be notified when remote data has changed

To update data in a local table based on changes made to a remote table

To assign a virtual table to a remote source

What privileges do you need to create a virtual table referencing a remote SAP HANA table? Note: There are 2 correct answers to this question.

CREATE VIRTUAL TABLE on the remote source

CREATE ANY on the target schema

CREATE VIRTUAL TABLE on the remote source

CREATE ANY on the target schema

Your flowgraphs defines a template table as a data target. What triggers the generation of the template table?

Defining the flowgraph data target node

Building/deploying the flowgraph

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

Descriptions of all objects defined in a calculation view

Dependencies between calculation views

Descriptions of all objects defined in a calculation view

All settings defined in a calculation view

Documentation to support the calculation view

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

To warn developers that the calculation view is no longer supported

To indicate that it should not be used as a data source to other calculation views

To warn developers that the calculation view is no longer supported

To indicate that it should not be used as a data source to other calculation views

To lock the calculation view from further modifications

To redirect queries on this calculation view to another one

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

The imported calculation view and its data source have different namespaces.

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

The .hdinamespace specifies 'sub-folder':'append', so calculation views can only be created in subfolders.

The imported calculation view and its data source have different namespaces.

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

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.

Why do we use Git when modeling calculation views?

To manage versions of source files

To display dependencies in stacked scenarios

To manage versions of source files

To enable collaboration between developers

In an XS Advanced project, what is the purpose of the .hdiconfig file?

To specify which HDI plug-ins are available

To specify in which space the container should be deployed

To specify an external schema in which calculation views will get their data

To specify which HDI plug-ins are available

To specify the namespace rules applicable to the names of database objects

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?

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

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

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

Execute the refactor function for the calculation view.

A cube calculation view consumes a dimension calculation view. You rename the design time file of the dimension view but do NOT choose the option to rename the runtime view and adjust the reference. Afterward, you perform the following operations:* A: Build/deploy the dimension calculation view as a single object.* B: Build/deploy the entire SAP HANA database module. What is the outcome of the build/deploy operations?

A is successful. * B is successful.

Why would you implement SQL in calculation views? Note: There are 2 correct answers to this question.

To define dynamic analytic privileges

To increase the possibilities for consumption

To define dynamic analytic privileges

SAP C_HAMOD_2404 Practice Test 2 - Free Online Exam Prep & Questions

What are possible consequences of unfolding? Note: There are 2 correct answers to this question.

Results are read from static cache.

Count-distinct results are incorrect.

SQL compilation time increases.

Query processing time improves.

Comment (0)

SAP C_HAMOD_2404 Practice Test 2

Question

SAP C_HAMOD_2404 Practice Tests

Practice Tests