[2022] C_HANAIMP_17 Exam Dumps, Test Engine Practice Test Questions [Q46-Q69]

Rate this post

[2022] C_HANAIMP_17 Exam Dumps, Test Engine Practice Test Questions

Pass C_HANAIMP_17 exam [Aug 06, 2022] Updated 82 Questions

NO.46 Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 2 correct answers to this question.
Response:

Disaster recovery

Failover

High availability

Backups

NO.47 Why did SAP move from XS to XSA?
There are 2 correct answers to this question.
Response:

To move to Cloud Foundry architecture to allow flexible application deployment options

To provide better source code management tools inside SAP HANA

To implement micro-services architecture

To include ABAP as a key development language for native SAP HANA applications

NO.48 What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

Dimension

Vertex

Edge

Association

NO.49 Which of the following views can you extend with the SAP HANA Live Extension Assistant?
Please choose the correct answer.
Response:

Query views with a union

All SAP-delivered views

Your own custom views

Reuse views

NO.50 Why might you use the Keep Flag property in an aggregation node?

To cache the results of the aggregation node for drill-down

To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

To include columns that are NOT requested by a query but are essential for the correct result

To retain the correct aggregation behavior in stacked views.

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

To provide a dynamic value in a calculated column

To break up complex SQL into smaller steps

To provide a run-time attribute filter based on a user input

To pass values between procedures and calculation views

NO.52 Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.
Response:

The supported file types for upload are .csv, and .txt

The new table always has a 1:1 mapping between the file and table columns

Renaming of columns and changing data types is allowedwhen loading data to new HANA tables

When loading new data in a table that already contains data, the new data is appended to the existing data

NO.53 You have a calculation view which includes nodes as shown in the graphic.
You decide to select the “Ignore multiple output for Filters” checkbox on projection node 3. What might the effects of this be?
There are 2 correct answers to this question.
Response:

The view will return the profit calculation for only the US

Decreased performance

Increased performance

A change to the data that is returned by the view

NO.54 Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question.
Response:

SAP Replication Server

SAP Data Services

SAP HANA XS engine

SDA

SDI

NO.55 For which deployment scenario does SAP deliver prebuilt data models?
Please choose the correct answer.
Response:

SAP HANA as a side-by-side accelerator

SAP HANA as an SQL Data Warehouse

SAP HANA as a platform

SAP HANA on the cloud

NO.56 In an XSA/HDI environment, which of the following is used for source version control of calculation views?
Please choose the correct answer.
Response:

Open-source Git

CTS (Change Transport System)

SAP HANA studio

CMS (Change Management System)

NO.57 Which SAP tools can work with data from Hadoop?
There are 3 correct answers to this question.
Response:

SDA

SDI

RDSync

SAP Vora

SAP Landscape Transformation Replication Server

NO.58 How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

Call the SAP-provided PAL decision tree procedure from the table function

Use dynamic SQL in the table function to generate the SQL code

Copy and adapt the SQL code generated by a flow graph into the table function

Build a flow graph and call it from the table function using input parameters

NO.59 What is an example of a use of Text Analysis?
Please choose the correct answer.
Response:

Extraction of key facts from entire database transactions

Developing a user input field where misspellings are tolerated.

Cluster documents that discuss similar topics.

Extraction of key facts from a business article.

NO.60 After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails.
What could be the reason?
Note: There are 2 correct answers.

The HDB module references a user-provided service that does not exist.

You have assigned the project to a space that you do not have developer authorizations for.

You have not built the project.

The project is not assigned to a space.

NO.61 You have successfully built a project you imported in the Web IDE workspace, but you cannot see the corresponding runtime database objects.
What could be the reason?
Please choose the correct answer.
Response:

The project is not assigned to a space

You have the Developer role in the assigned space

Building a project does not generate the database content of its HDB modules

You do not have the Developer role in the assigned space.

NO.62 Identify the object that adds a WHERE clause to the query.
Please choose the correct answer.
Response:

Variable

Input parameter

Attributes

Modeler

NO.63 Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:

Operational reporting moving back to the OLTP system

Analytical reporting moving back to the OLTP system

Analytical reporting moving back to the OLAP system

Operational reporting moving back to the OLAP system

NO.64 In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

Full outer joins are restricted to one dimension in a star join node.

Full outer joins require cardinality to beset.

Full outer joins CANNOT be mixed in the same star join node with other join types.

Full outer joins are NOT available in the star join node.

NO.65 What are the vertices in a graph model?
Please choose the correct answer.
Response:

The relationships between the nodes

The attributes of the nodes

The nodes themselves

NO.66 When do you use the hidden attribute in a dimension calculation view?
Please choose the correct answer.
Response:

When you want to include an attribute that is not required for cube consumption.

When you want to hide the attribute in your cube calculation view.

When you want to hide an attribute that is not required for client consumption.

When you need to include the attribute in your calculation view to define a join.

NO.67 What are features of SDA?
There are 2 correct answers to this question.
Response:

Automatic data type translation

Evaluation and execution of push down possibilities to remote sources

Data cleansing

Merging data from multiple sources

NO.68 In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

Table function

CDS view

Procedure

Virtual Table

NO.69 In which direction do you build calculation views when including the source tables in Join nodes?
Please choose the correct answer.
Response:

From the Join node down to the default node

From the Semantics node down to the Join nodes

From the Semantics node up to the default node

From the Join nodes up to the semantics node