In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? (2) Container Function Procedure Task.
You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create view that uses data from one ta-ble located in an external schema.
Which of the following items must you build? (2)
HDB MODULE Project Authorization Synonym.
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.
User 2 can view United States for 2017 User 1 can view any year for United States User 1 can view Canada for 2018 User 2 can view any year for United States.
Which of the following are no longer required in the architecture of SAP S/4HANA?
There are 2 correct answers to this question. Aggregates Indexes Column tables Synonyms.
Question:
You want to join 2 tables in a calculation view. When would you use non-equi join?
Please choose the correct answer.
Response:
The cardinality is impossible to determine. The join is part of star join. The cardinality is 1: N The join requires a <(less than) operator.
If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use?
Please choose the correct answer.
Procedure Function Both Procedure and Function None of these.
Question:
One SQL analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another one authorizes you to view data for Asia and the USA in the income calculation view. The income view uses the sales view as a data source. Both calculation views check SQL analytic privileges.
What data can you visualize when consuming the income calculation view? (1)
Response:
Data from Asia and the USA Data from Asia and the USA Data from the USA Data from Europe and the USA.
You want to star schema using calculating view. The measure are based on columns from two transaction table dimension calculation views pro-vide the attributes.
What is the correct approach?
Please choose the correct answer.
Response:
1. Combine the transaction table using a star join node in a calculation view of cube with star join
2. Use a star node to join the dimensions to the fact table
1. Combine the transaction table using a star join node in a calculation view of cube with star join
2. Use an aggregation node to join the dimensions to the fact table
1. Combine the transaction table using a join node in a calculation view of cube with star join
2. Use a star join node to join the dimensions to the fact table
1. Combine the transaction table using an aggregation node in a calculation view of cube with star join
2. Use a star join node to join the dimensions to the fact table
.
What are features of Business Suite on SAP HANA?
There are 2 correct answers to this question.
Response:
ABAP is replaced with JAVA Combine operational analytics and transaction processin Massive performance improvement Embedded Analytics.
How does SAP HANA Live impact SAP Business Warehouse (SAP BW)?
Response: (1)
It makes SAP BW business content irrelevant. It adds more reporting tools to SAP BW. It simplifies SAP BW data modeling. It moves live, operational reporting to SAP HANA.
When can you expose a hierarchy that is defined in a calculation view for access with SQL?
Please choose the correct answer.
Response:
When the hierarchy is a local hierarchy When the hierarchy is defined in a calculation view of DEFAULT When the hierarchy is defined in a calculation view of type CUBE When the hierarchy is a shared hierarchy.
Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:
Operational reporting moving back to the OLAP system Operational reporting moving back to the OLAP system Operational reporting moving back to the OLTP system Analytical reporting moving back to the OLAP system.
Which are views of the SAP supplied virtual data model of Embedded Analytics?
There are 2 correct answers to this question.
Response:
Composite Calculation Basic Attribute.
In SAP Web IDE for SAP HANA, you created an SQL analytic privilege that secures your calculation view. You build the analytic privilege, but the build fails. What could be the reason?
Response:
The Apply Privileges property of your calculation view was NOT defined correctly. Calculation views CANNOT be assigned to an analytic privilege. The Data Category property of your calculation view was NOT set correctly. You did NOT assign the analytic privilege to a role.
How does SAP S/4HANA embedded analytics differ from SAP HANA Live?
There are 2 correct answers to this question.
Response:
It uses SAP HANA calculation views. It uses ABAP CDS views. Authorizations are at the database level. Authorizations are at the application level.
What performance technique should you implement to improve the per-formance of SAP HANA information views that include SQLScript?
Please choose the correct answer.
Response:
Break large statements into smaller steps. Use dynamic SQL. Use imperative logic. Use SELECT *.
What does a graph neighborhood reveal?
Please choose the correct answer.
Response:
Vertices that are closely connected Shortest path between vertices Vertices that contain the same attributes Strongly connected Vertices.
How can you define a variable that presents its value help hierarchically?
There are 2 correct answers to this question.
Response:
Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the child attribute of the hierarchy
Create a level hierarchy and assign it to the variable
Ensure the variables reference column is the leaf level of the hierarchy.
Create a level hierarchy and assign it to the variable
Ensure the variables references column is the top level of the hierarchy
Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the parent attribute of the hierarchy
.
When using the CONTAINS predicate, what are the restrictions you must you keep in mind?
There are 2 correct answers to this question
Response:
Non-physical columns, such as calculated columns, are not search-relevant The NOT (-) operator can only be specified directly after the OR operator If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables. Wild cards* and? Are supported for text columns but not string columns.
What does SQL script provide to extend standard SQL?
There are 2 correct answers to this question.
Response:
Feature to encourage processing in the database Integrated source code version management Additional data types for the definition of text and spatial data Support for ABAP Syntax.
How could you improve the performance of joins in cube calculation views?
There are 2 correct answers to this question.
Response:
Join on calculated columns Avoid the use of referential joins. Specify the cardinality of the join Reduce the number of columns used in the join.
Before deploying your calculation views to a PROD environment, which sequence of steps is required?
Please choose the correct answer.
Response:
Build the HDB module -> Build the project Activate the project -> Build the HDB module Build the project -> Build th HDB module Export the HDB module -> Export the project.
Question:
When you create a full text index, why do you specify FAST_PREPROCESS OFF?
Please choose the correct answer.
To prevent the creation of a fuzzy search index To enable a full linguistic search To avoid the generation of the term document matrix To generate text analysis results in multiple languages.
Which of the following must you consider when you define namespaces in an SAP HANA database (HDB) module?
There are 3 correct answers to this question.
Response:
The namespace defined in a design-time object must match the namespace properties of the folder in which it is located Modeling content should be created before the namespace rules have been defined synonyms can have different namespaces A namespace is a mandatory component of the object identifier Two different objects can have the same name if they are assigned to different namespa-ces.
You created a table function to sum the total weekly working hours for each employee and update the personnel table. You CANNOT activate the table function. What could be the problem?
Please choose the correct answer.
You do NOT create synonyms for the tables You do NOT have write permissions to the personnel table You did NOT define a valid table type You CANNOT update records using a table function.
Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018?
Please choose the correct answer.
Projection Sales January 2018
Projection Sales February 2018
Company Product Quantity Company Product Quantity
User an intersect node Use a full outer join Use a left outer join Use a union node.
What is the persistent storage layer used for?
There are 2 correct answers to this question.
Response:
To enable data to be recovered if hardware fails TO improve the parallel processing of queries To store the data primarily used for transaction processing To unload the least-used data when the memory is full.
In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterwards, you perform the following build ope-rations.
Build the dimension calculation view as a single object
Build the entire SAP HANA database module.
What is the outcome of the build operations?
Please choose the correct answer.
Response:
The first build is successful.
The second build fails.
The first build is successful
The second build is successful
The first build fails
The second build is successful
The first build fails
The second build fails
.
On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA.
Which tools can you use?
There are 2 correct answers to this question.
SAP HANA smart data access SAP HANA smart data integration SAP Data Services SAP Landscape Transformation Replication Server.
What restrictions apply to a graph node that you include in a calculation view?
Please choose the correct answer.
Response:
It must be the first node in the data flow. It must be the final node in the data flow It cannot be included in a calculation view of type dimension Its data sources must be provided by a projection node.
In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?
Please choose the correct answer.
Response:
Horizontal disaggregation Vertical aggregation Vertical disaggregation Horizontal aggregation.
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 analytic views to calculation views To convert attribute views to CDS VIEWS.
In text processing, where do you use the Term Document Matrix?
Please choose 2 correct answers.
Response:
Linguistic extraction Text mining Fact and entity extraction Fuzzy text search.
Which tables do you need for currency conversion?
Please choose the correct answer.
Response:
DD07* TCUR* BICS* SHINE*.
Why do you use the query debug mode in a calculation view?
Please choose the correct answer.
Response:
To observe the generated SQL for each node To check which database engines will be invoked by each node? To check if SAP HANA can paralyze the entire query To measure the overall run-time of the query.
In a calculation view, where can you use SQL?
There are 3 correct answers to this question.
Response:
Union pruning conditions Filter expression Calculated column expression Input parameter Aggregation node.
Which of the following techniques can you use to improve the performan-ce of calculation views?
There are 2 correct answers to this question.
Response:
Avoid aggregating data early in the data flow Partition large tables Minimize layering of calculation views Implement union pruning.
You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information.
The INDIA calculation view is built on top of the WORLD calculation view and shows information for Indian products.
What privilege must you assign to see your department’s specific data in a report built on the INDIA calculation view?
Please choose the correct answer.
Response:
An analytic privilege on the WORLD calculation view An analytic privilege on the INDIA calculation view An analytic privilege on both calculation views An object privilege on the WORLD calculation view.
In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.
Response:
Assign the project to a space to which you have developer authorizations Explicitly build the HDB module instead of the project Ensure that you have only one HDB module in your project Ensure that the name of your HDB module is included in the corresponding schema names.
Which business intelligence tool does NOT use BICS connectivity to SAP HANA?
There are 2 correct answers to this question.
Response:
Microsoft Excel SAP Analysis for Microsoft Office SAP Lumira, discovery edition SAP Lumira, designer edition.
From where does the Extract Semantics feature get the definition of hierar- chies?
Please choose the correct answer.
Response:
From the current calculation view From the table data sources From the underlying dimension views From the SQL view data sources.
Why might you use the keep flag in an aggregation node?
Please choose the correct answer.
Response:
To retain the results of the aggregation node for reuse in a drill-down based on hierarchy To include columns that are NOT requested by a query but are essential for the correct result To ensure that the aggregation behavior defined in the aggregation node for a measure CAN-NOT be overridden by a query.
|
