Questions I got wrong
What type of file would you create in the SAP Web IDE for SAP HANA to do data cleaning? Please choose the correct answer. .hdbcds .hdbtabledata .hdbflowgraph .hdbgraphworkspace
.hdbflowgraph
What do you use to build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars? Please choose the correct answer. A variable from a Projection node A variable from the Semantics node An input parameter from an Aggregation node An input parameter from the Semantics node
An input parameter from the Semantics node
In SAP HANA Studio, what would you find in a Package? There are 3 correct answers to this question. Analytic Privileges Procedures Tables Calculation Views
Analytic Privileges Procedures Calculation Views
What are features of SDA? There are 2 correct answers to this question. Data cleansing Automatic data type translation Evaluation and execution of push down possibilities to remote sources Merging data from multiple sources
Automatic data type translation Evaluation and execution of push down possibilities to remote sources
What are features of SDA? There are 2 correct answers to this question. Data cleansing Automatic data type translation Evaluation and execution of push down possibilities to remote sources Merging data from multiple sources
Automatic data type translation Evaluation and execution of push down possibilities to remote sources
For which data types does SAP HANA automatically create full-text indexes? There are 3 correct answers to this question. Response: NVARCHAR BINTEXT CLOB TEXT SHORTTEXT
BINTEXT TEXT SHORTTEXT
When we refer to mixed modeling, what do we mean? Please choose the correct answer. Models from BW on anyDB combined with models from BW on HANA NetWeaver models combined with native SAP HANA models Classic BW models combined with SAP HANA optimized BW models BW models combined with native SAP HANA models
BW models combined with native SAP HANA models
When we refer to mixed modeling, what do we mean? Please choose the correct answer. BW models combined with native SAP HANA models NetWeaver models combined with native SAP HANA models Classic BW models combined with SAP HANA optimized BW models Models from BW on anyDB combined with models from BW on HANA
BW models combined with native SAP HANA models
Where do you use SQLScript outside of the development environment discussed in this chapter? There are 3 correct answers to this question. Creating tables Calculation views Text analytics Security Reporting tools
Calculation views Text analytics Security
The relational model of SAP HANA Live is built using which type of views? Please choose the correct answer. Response: Analytic views and attribute views Calculation views of data category cube with star join Calculation views of data category cube without star join Scripted calculation views
Calculation views of data category cube without star join
What are the features of dynamic analytic privileges? There are 2 correct answers to this question. Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data Filter the condition based on a variable entered by the user when they query the view Filter the data based on a variable entered by the user when they query the view
Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data
What is the preferred way to create a procedure? Please choose the correct answer. Create a .hdbprocedure file. Create a .procedure file. Use the Import menu in the SAP Web IDE for SAP HANA. Use the CREATE PROCEDURE statement in the SQL console.
Create a .hdbprocedure file.
Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge? Please choose the correct answer. Creating a REST web service in the SAP HANA XS engine Creating business intelligence content with SAP Lumira, designer edition Creating a report in SAP Crystal Reports for Enterprise Creating a CompositeProvider in SAP BW
Creating business intelligence content with SAP Lumira, designer edition
What does SQLScript provide in SAP HANA? There are 2 correct answers to this question. Creation of column tables Powerful client-side processing Aggregation functions such as AVG() Flow control logic Variables to break up complex statements
Creation of column tables Flow control logic Variables to break up complex statements
What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Data volume Delta store Log area Memory
Data volume Log area
To maintain good read performance in a constantly changing database, which two components are used? There are 2 correct answers to this question. Delta storage Column store Main storage Memory store
Delta storage Main storage
What can you use to limit the number of records produced by a calculation view? There are 3 correct answers to this question. Domain fix values Restricted columns Filter expressions SAP client restrictions Generated columns
Domain fix values Filter expressions SAP client restrictions
What can you use to limit the number of records produced by a calculation view? There are 3 correct answers to this question. Domain fix values Restricted columns Generated columns SAP client restrictions Filter expressions
Domain fix values SAP client restrictions Filter expressions
You want to ignore columns defined in the Rank node that aren't included in the query. What setting do you set? Please choose the correct answer. Hidden Keep Flag Dynamic Partition Elements Default Client
Dynamic Partition Elements
You want to ignore columns defined in the Rank node that aren't included in the query. What setting do you set? Please choose the correct answer. Dynamic Partition Elements Keep Flag Hidden Default Client
Dynamic Partition Elements
Which storage is required if you implement multistore tables for SAP HANA? Please choose the correct answer. Extended storage Delta storage Remote storage Nearline storage
Extended storage
Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution? There are 2 correct answers to this question. Backups Disaster recovery Failover High availability
Failover High availability
What can a variable be used for? Please choose the correct answer. Call a procedure in SQL Script Currency conversion Calculated column expression Filtering
Filtering
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. Input parameters Value help Domain fix values Variables Expressions
Input parameters Value help Variables
What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer. Unsorted inserts Parallelism Insert-only Sorted inserts
Insert-only
What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer. Parallelism Insert-only Unsorted inserts Sorted inserts
Insert-only
Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer. It provides reports and analysis on the received data. It is a standalone product for use with any target system. It uses databases queries It acts based on combinations of events
It acts based on combinations of events
How does SQL Script extend SQL? There are 3 correct answers to this question. It adds imperative expressions to control data flow. It provides the data definition language (DDL) to create column tables. It allows an alternative syntax to simplify expressions. It enables usage of variables to break up complex code. It improves push-down opportunities.
It adds imperative expressions to control data flow. It provides the data definition language (DDL) to create column tables. It enables usage of variables to break up complex code.
What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Log area Memory Data volume Delta store
Log area Data volume
What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Log area Delta store Memory Data volume
Log area Data volume
You want to read a table from an SAP HANA classical schema. What do you need to do to get it working? There are 3 correct answers to this question. Make use of the built-in HDI service Make use of a user-provided service Assign the provided ::access role to your container's technical user Create a synonym Use an explicit reference to the schema
Make use of a user-provided service Assign the provided ::access role to your container's technical user Create a synonym
What are features of Business Suite on SAP HANA? There are 2 correct answers to this question. ABAP is replaced with JAVA Embedded Analytics Massive performance improvement Combine operational analytics and transaction processing
Massive performance improvement Combine operational analytics and transaction processing
What are features of Business Suite on SAP HANA? There are 2 correct answers to this question. Massive performance improvement Combine operational analytics and transaction processing ABAP is replaced with JAVA Embedded Analytics
Massive performance improvement Combine operational analytics and transaction processing
Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live? There are 2 correct answers to this question. More use cases are available with CDS than with SAP HANA Live. Calculation views cannot be used with S/4HANA tables. Deeper BI functionality is available with CDS compared to SAP HANA Live. CDS is tied to the application layer for better control of complete source code transportation.
More use cases are available with CDS than with SAP HANA Live. CDS is tied to the application layer for better control of complete source code transportation.
Which recent technology innovations have triggered the opportunity to build a next generation data processing platform? There are 2 correct answers to this question. Multi-core processing Faster disk access Larger memory availability
Multi-core processing Larger memory availability
What are the currency conversion functionalities supported by SAP HANA? There are 3 correct answers to this question. Multiple exchange rate types Enabling of decimal shifts Conversion based on customer-defined tables Determination of target currency based on attributes or input parameters
Multiple exchange rate types Enabling of decimal shifts Determination of target currency based on attributes or input parameters
What information can you find in the Plan Graph? There are 2 correct answers to this question. Number of records returned in each step SQL Plan Cache Execution engines used Time taken for each step
Number of records returned in each step Time taken for each step
You want to retrieve data from a web application. Which of the following could you use? There are 3 correct answers to this question. Response: OData JDBC REST JSON BICS
OData REST JSON
What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question. Flowgraphs Predictive algorithms Data preparation functions Text mining functions
Predictive algorithms Data preparation functions
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: SDA SAP Data Services SDI SAP HANA XS engine SAP Replication Server
SAP Data Services SDI SAP HANA XS engine
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 HANA as a platform SAP HANA Live SAP BW powered by SAP HANA
SAP HANA as a platform SAP HANA Live
You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required. Which tool do you recommend? Please choose the correct answer. SAP Lumira, designer edition SAP Lumira, discovery edition SAP BusinessObjects Web Intelligence SAP Crystal Reports for Enterprise
SAP Lumira, designer edition
Which business intelligence tool does NOT use BICS connectivity to SAP HANA? There are 2 correct answers to this question. Microsoft Excel SAP Lumira, designer edition SAP Analysis for Microsoft Office SAP Lumira, discovery edition
SAP Lumira, designer edition SAP Analysis for Microsoft Office
In which SAP HANA solution do you eliminate stored data, such as year-todate figures? Please choose the correct answer. Response: SAP CRM on SAP HANA SAP BW on SAP HANA SAP S/4HANA SAP HANA Enterprise Cloud
SAP S/4HANA
What is normally used to build SAP HANA XSC applications inside SAP HANA? There are 2 correct answers to this question. ABAP SAPUI5 Java JavaScript
SAPUI5 JavaScript
Which of the following data provisioning tools can you use to read data directly from Twitter? There are 3 correct answers to this question. SAP Replication Server SDA SDI SAP Data Services SAP HANA XS engine
SDI SAP Data Services SAP HANA XS engine
Which data provisioning tools can use SAP HANA adapters? There are 2 correct answers to this question. SAP Replication Server SDI SDA SAP HANA streaming analytics
SDI SDA
Which SAP tool can you use to include geospatial and predictive processing as part of the data transformation process? Please choose the correct answer. SDI SAP Data Services SDQ SDA
SDQ
What information can you find in the SAP HANA Cockpit? There are 2 correct answers to this question. SQL generated in each step SQL Plan Cache Trace and log files List of operators
SQL Plan Cache Trace and log files
Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question. The database administrator might type the name wrong. The focus is on the business requirements. The focus is on the database administration requirements. The database administrator should not get those privileges in the production system
The focus is on the business requirements. The database administrator should not get those privileges in the production system
Why might you want to reference a user-provided service in a project? Please choose the correct answer. To access data from another container To access data from a classic database schema To access data from your project container
To access data from a classic database schema
For what tasks would you use the Where-Used feature in SAP HANA? Please choose the correct answer. To find all places where a developer updated information models To find all places where an information model is used To find all places where translations exist To find all places where an information model has been deployed
To find all places where an information model is used
For what tasks would you use the Where-Used feature in SAP HANA? Please choose the correct answer. To find all places where a developer updated information models To find all places where an information model is used To find all places where translations exist To find all places where an information model has been deployed
To find all places where an information model is used
Why should you use variables in SQL Script? There are 2 correct answers to this question. To implement flow control logic To support processing push-down To increase parallelization opportunities To improve code readability
To increase parallelization opportunities To improve code readability
Which words are associated with the log volume? There are 2 correct answers to this question. Transaction manager Synchronous Savepoint Page manager
Transaction manager Synchronous
You're creating a currency conversion. What options do you have for the Target Currency field? There are 3 correct answers to this question. Select a table type. Use an input parameter. Select a fixed currency. Use the Derived from Table option. Select a column.
Use an input parameter. Select a fixed currency. Select a column.
How can you connect SAP Analysis for Microsoft Office to SAP HANA? Response: Using an ODBO connection Using an SAP HANA Live data connection Using an SAP BusinessObjects Enterprise platform web service Using Direct Access Mode
Using an SAP BusinessObjects Enterprise platform web service
How can you connect SAP Analysis for Microsoft Office to SAP HANA? Using an SAP BusinessObjects Enterprise platform web service Using Direct Access Mode Using an SAP HANA Live data connection Using an ODBO connection
Using an SAP BusinessObjects Enterprise platform web service
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 SEQUENTIAL EXECUTION READS SQL DATA LANGUAGE SQLSCRIPT
WITH RESULTS VIEW READS SQL DATA
You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view. - In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view. - You then accidentally delete the design-time object of the cube calculation view. During the build, which of the following scenarios are possible? There are 2 correct answers to this question. Response: When you build only the dimension calculation view, the build is successful. When you build only the dimension calculation view, the build fails. When you build the HDB module, the build fails. When you build the HDB module, the build is successful.
When you build only the dimension calculation view, the build fails. When you build the HDB module, the build is successful.
What do you create to find the number of unique items sold per shop? Please choose the correct answer. A calculation view with a counter in an Aggregation node An analytic view with a calculated column in a Star Join node A calculation view with a counter in a Projection node A calculation view with a restricted column in an Aggregation node
A calculation view with a counter in an Aggregation node
The virtual data model for SAP S/4HANA is based on which of these? Please choose the correct answer. ABAP CDS Universe SAP HANA CDS SAP HANA Live
ABAP CDS
What is the default node for a calculation view of type cube? Please choose the correct answer. Join node Star join node Aggregation node Projection node
Aggregation node
Which of the following node types can you use to build a dimension view? There are 3 correct answers to this question. Aggregation node Semantics node Star join node Data foundation node Union node
Aggregation node Semantics node Union node
Where is SDI used? There are 2 correct answers to this question. Data streaming For data loading Data transformation Data cleansing
For data loading Data transformation
Which of following are features associated with SAP HANA Live? There are 2 correct answers to this question. Precalculated aggregates stored in cubes Hundreds of predeveloped views Web-based tools A new data warehouse
Hundreds of predeveloped views Web-based tools
Why would you create a procedure? There are 2 correct answers to this question. If you need to provide a data source to a graphical calculation view If you need to define a calculated column expression If you need to insert records into a table If you need a mixture of scalar and tabular output parameters
If you need to insert records into a table If you need a mixture of scalar and tabular output parameters
What are the features of dynamic analytic privileges? There are 2 correct answers to this question. Should have chosen Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data Filter the condition based on a variable entered by the user when they query the view Filter the data based on a variable entered by the user when they query the view
Should have chosen Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data
Which of the following benefits characterize the use of a design time filter? There are 3 correct answers to this question. It is defined on the runtime in the SQL query. The filter is applied on the table before the query is executed. It reduces the result set of data. It is applied before a table join is executed. The filter is applied on the result set of a query.
The filter is applied on the table before the query is executed. It reduces the result set of data. It is applied before a table join is executed.
A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails. Which of the following are possible reasons for the failure? There are 2 correct answers to this question. The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one. The geometry is an ST_POLYGON where the last defined point is not the same as the first one. The geometry is an ST_MULTIPOLYGON that specifies only one polygon. The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.
The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one. The geometry is an ST_POLYGON where the last defined point is not the same as the first one.
You rename a field in the Semantics node to add clarity for end users. What does SAP HANA use to keep track of what the original field name is? Please choose the correct answer. Response: The name property The mapping property The label column property The label property
The mapping property
You created a user-defined function with the INVOKER security option. Which user's authorizations are checked when the function is executed? Please choose the correct answer. Response: The container's technical user The user calling the function The SYSTEM user The owner of the function
The user calling the function
Which of the following are capabilities of SAP HANA Live Browser? There are 3 correct answers to this question. You can develop personal lists of frequently used query views. You can graphically illustrate the dependencies between SAP HANA Live views. You can launch the views using SAP Analysis Edition for Microsoft Excel. You can adjust the views by adding additional columns.
You can develop personal lists of frequently used query views. You can graphically illustrate the dependencies between SAP HANA Live views. You can launch the views using SAP Analysis Edition for Microsoft Excel.
