SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 7
Question list
List of questions
Related questions
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
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
Create a remote subscription
Create a target table
Define a flowgraph
Create a virtual table
What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question.
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
In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?
Projection
Aggregate
Case
Pivot
What is the purpose of a remote subscription?
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.
SELECT on the source object
CREATE VIRTUAL TABLE on the remote source
CREATE ANY on the target schema
ALTER on the remote source
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
Running the flowgraph
Saving the flowgraph
When you build/deploy a flowgraph, what can be generated? Note: There are 3 correct answers to this question.
Batch Task
Procedure
Function
Real-time Task
Replication Task
You have generated a calculation view properties file. What does it contain?
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
You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external schema within the same local database.
Which of the following items do you need? Note: There are 2 correct answers to this question.
Synonym
Remote source
SQL view
Authorization
Question