SAP Certified Application Associate C_HANAIMP_17 Dumps Updated Aug 31, 2022 - Dumpleader [Q27-Q46] : IT certification exam materials : http://blog.dumpleader.com

Q27. You want to show a male and female option to end users. What feature do you use?
There are 3 correct answers to this question.
Response:

Input parameters

Domain fix values

Expressions

Value help

Variables

Q28. When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.

Non-physical columns, such as calculated columns, are not search-relevant.

The NOT (-) operator can only be specified directly after the OR operator.

Wild cards * and ? are supported for text columns but not string columns.

If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

Q29. Which of the following data sources can you include in a graphical calculation view?
There are 2 correct answers to this question.
Response:

Table function

Procedure

SQL VIEW

Scalar function

Q30. What is SQLScript?
Please choose the correct answer.
Response:

An extension to standard SQL that provides additional expressions, functions and datatypes.

A subset of standard SQL that is exposed to HANA database procedures.

A subset of standard SQL that is exposed to HANA modelers.

A simplified query language aimed at business users that generates SQL.

Q31. Why would you use the XS Advanced migration Assistant?
There are 2 correct answers to this question.
Response:

To move HDI-developed calculation views to repository packages

To convert studio-developed objects for use with Web IDE FOR SAP HANA

To convert attribute views to CDS VIEWS

TO convert analytic views to calculation views

Q32. What can you discover using Data Lineage?
Please choose the correct answer.
Response:

Frequency of load

Underlying calculation views and tables

Data changes since last refresh

Access statistics

Q33. The company asks you to get data from IoT sensors. Which SAP tools could you use?
There are 3 correct answers to this question.
Response:

SAP Landscape Transformation Replication Server

SAP HANA Remote Data Sync (RDSync)

SAP HANA smart data access (SDA)

SAP HANA streaming analytics

SAP SQL Anywhere

Q34. In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer.
Response:
Repository package

_SYS_BIC schema

Container schema

Database user schema

Q35. What can a variable be used for?
Please choose the correct answer.
Response:

Call a procedure in SQL Script

Currency conversion

Calculated column expression

Filtering

Q36. Which text feature do you use to find sentiment in textual data?
Please choose the correct answer.
Response:

Full-text index

Text analysis

Fuzzy text search

Text mining

Q37. You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the users?
There are 2 correct answers to this question.
Response:

User 1 can view any year for United States

User 2 can view any year for United States

User 2 can view United States for 2017

User 1 can view Canada for 2018

Q38. You have a calculation view which includes nodes as shown in the graphic. You decide to select the “Ignore Multiple Output for Filters” check box on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question.

The view will return the profit calculation for only the US

A change to the data that is returned by the view

Increased performance

Decreased performance

Q39. Which business intelligence tool can publish storyboards?
Please choose the correct answer.
Response:

SAP Analysis for Microsoft Office

SAP BusinessObjects Web Intelligence

SAP BusinessObjects Analysis, edition for Microsoft Office

SAP Lumira, designer edition

Q40. Which recent technology advances have made SAP HANA possible?
There are 2 correct answers to this question.
Response:

Multicore processors

Faster internet speeds

Larger and cheaper memory

Faster disk speeds

Q41. What information can you find in the SAP HANA Cockpit?
There are 2 correct answers to this question.
Response:

SQL generated in each step

List of operators

Trace and log files

SQL Plan Cache

Q42. Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer.
Response:

SAP Landscape Transformation Replication Server

SDA

SAP HANA streaming analytics

Flat files

Q43. 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

Q44. 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

Q45. In which type of node can you create calculated columns?
There are 2 correct answers to this question.
Response:

Union node

Rank node

Graph node

Projection node

Q46. What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?

Database connection

Wrapper

Function

Synonym