- Which of the following are capabilities of SAP HANA Live Browser?
There are 3 correct answers to this question.
You can launch the views using SAP Analysis Edition for Microsoft Excel.
You can develop personal lists of frequently used query views. You can adjust the views by adding additional columns. You can graphically illustrate the dependencies between SAP HANA Live views.
What can you use to limit users to see only 2018 data?
There are 2 correct answers to this question.
An object privilege A SQL analytic privilege A view with a filter A view with a restricted column.
What are components of SAP HANA EIM?
There are 2 correct answers to this question.
SDQ SDA SDI SDS.
What combination enabled real-time computing?
Please choose the correct answer.
Multicore CPUs with large level 1 caches In-memory technology and multicore CPUs Multicore CPUs and solid-state disks In-memory technology with solid-state disks.
Which interface client is used for XSA application development?
Please choose the correct answer.
SAP HANA Studio SAP Web IDE for SAP HANA SAP HANA Web-based Workbench SAP Web IDE.
How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question.
1 2 3 4.
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.
Expressions Input parameters Variables Value help Domain fix values.
You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
SQL function Scalar function Window function Table function.
What phrase describes the main table area in the delta merge scenario?
Please choose the correct answer.
Row store Unsorted inserts Write-optimized Read-optimized.
In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system?
There are 2 correct answers to this question.
SAP S/4HANA SAP BW powered by SAP HANA SAP HANA Live SAP HANA as a platform.
In SAP BW/4HANA, what do you use instead of an InfoCube?
Please choose the correct answer.
CompositeProvider Open ODS View InfoObject Advanced DataStore Object.
When would you use a function?
Please choose the correct answer.
When you need to write results back to a table. When you need to define complex data sources for my calculation view that require conditional logic. To develop a calculation view with the best possible performance. To break SQL into smaller statements.
What PAL algorithm category can you use for supervised learning?
Please choose the correct answer.
Classification Clustering Association Social network analysis.
You want to build a hierarchy on a time-based data structure, such as year, month, and day. What type of hierarchy do you use?
Please choose the correct answer.
Parent-child hierarchy Unbalanced hierarchy Ragged hierarchy Level hierarchy.
Where in a calculation view can you add a Graph node?
Please choose the correct answer.
Anywhere from the bottom (leaf) node to the default node Only as the top node Always as the bottom (leaf) node.
What do you call the data displayed in the data foundation of an SAP HANA information view?
Please choose the correct answer.
Key figures Facets Characteristics Measures.
How should you create a procedure?
Please choose the correct answer.
Create a runtime object in a HANA project Create a design-time object in a HANA project. Create a design-time object in a SQL console Create a runtime object in the SQL console.
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?
There are 2 correct answers to this question.
Data is available in real time using SLT. It offers a simplified landscape. It provides a quick start for customers using Business Suite on non HANA databases. There is no data movement.
Where do you build a flowgraph?
There are 2 correct answers to this question.
Web IDE for SAP HANA Web-based development workbench SAP HANA Studio modeler perspective SAP HANA Studio development perspective.
You have Model B that is based on Model A. You have successfully built both models. You delete Model B. What happens during the build?
There are 2 correct answers to this question.
Model B gets deleted from the HDI container You get a build error when you build Model A The build of the entire HDB module is successful The build of Model A is successful You get an error when you build the entire HDB module.
Where is SDI used?
There are 2 correct answers to this question.
Data transformation For data loading Data cleansing Data streaming.
What information can you find in Performance Analysis Mode when you view the analysis for a Join node?
There are 2 correct answers to this question.
Total number of records returned by the node Time taken by the join Tables used by the join in the node Suggested filter for the tables in the Join node.
What does SAP HANA load when starting up and before indicating that it’s ready?
There are 3 correct answers to this question.
Some column tables Some row tables All row tables All partitions All system tables.
When do you use the hidden attribute in a dimension calculation view?
Please choose the correct answer.
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.
In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
L R JavaScript SQLScript.
You imported the following objects. Which of them always require an activity from you before they can be built?
There are 2 correct answers to this question.
Synonyms definition Logical schema definition SAP HANA database module Multi-target application.
You want to call a procedure in a SELECT statement (e.g., a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
WITH RESULTS VIEW LANGUAGE SQLSCRIPT SEQUENTIAL EXECUTION READS SQL DATA.
You’re given an old government paper form with lines, blocks, and fields. You’re asked to create a report that looks like this form.
Which business intelligence tools do you use?
Please choose the correct answer.
SAP Lumira, discovery edition SAP BusinessObjects Web Intelligence SAP Crystal Reports for Enterprise SAP Lumira, designer edition.
While converting currencies, which parameter is as important as source and target currencies?
Please choose the correct answer.
Time Money Season Location.
What is the role of core modeling in SAP HANA?
There are 2 correct answers to this question.
To develop reuseable data processing logic in the database To push data-intensive processing up to the application to obtain the best performance To develop more secure user authentication To simplify applications.
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.
You have the Developer role in the assigned space Building a project does not generate the database content of its HDB modules The project is not assigned to a space You do not have the Developer role in the assigned space.
What are the database query languages used by SAP HANA?
There are 2 correct answers to this question.
ABAP JDBC ODBC MDX SQL.
For what SQL keyword is the Aggregation node the equivalent?
Please choose the correct answer.
DISTINCT ORDER BY GROUP BY UNIQUE.
You need to return multiple result sets using SQL Script. What do you use?
Please choose the correct answer.
Procedure Scripted calculation view Table function Scalar function.
You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
Dynamic join Temporal join Relational join Self-join.
What SAP HANA feature do you use to host multiple applications for different companies in single SAP HANA landscape while ensuring isolation?
Please choose the correct answer.
Multitenant Database Containers (MDC) Active/Active (read-enabled) mode SAP HANA as a distributed database Extended storage.
If we change the transaction “Laura buys 10 apples” to “Laura buys 10 green apples,” how would we store the color green?
Please choose the correct answer.
Store green as an attribute. Store green as a CDS view. Store green as a spatial data type. Store green as a measure.
In which SAP HANA views will you find measures?
There are 2 correct answers to this question.
Calculation view of type cube with star join Calculation view of type cube Database views Calculation view of type dimension.
What join type should you use to see all the suppliers?
1 correct Inner join Referential join Left outer join Right outer join.
What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the correct answer.
Insert-only Parallelism Unsorted inserts Sorted inserts.
Where is SAP HANA Live installed?
Please choose the correct answer.
In the reporting tool On SAP Landscape Transformation Replication Server On the SAP ERP application server In the SAP HANA database.
|
