When we refer to mixed modeling, what do we mean?
Please choose the correct answer. Classic BW models combined with SAP HANA optimized BW models BW models combined with native SAP HANA models NetWeaver models combined with native SAP HANA models Models from BW on anyDB combined with models from BW on HANA.
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. Select a fixed currency. Use an input parameter. Use the Derived from Table option. Select a column.
What are typical characteristics of SAP HANA data replication?
There are 2 correct answers to this question. Virtualization. Duplicate data. Real-time. Streaming.
Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question. Security Calculation views Reporting tools Text analytics Creating tables.
How many processing tiers do you usually find in a native SAP HANA application stack?
Please choose the correct answer. 4 1 2 3.
What is SQLScript?
Please choose the correct answer. A simplified query language aimed at business users that generates SQL. A subset of standard SQL that is exposed to HANA modelers. A subset of standard SQL that is exposed to HANA database procedures. An extension to standard SQL that provides additional expressions, functions and datatypes.
What information can you find in the SAP HANA Cockpit?
There are 2 correct answers to this question. SQL Plan Cache Trace and log files SQL generated in each step List of operators.
In which type of node can you create calculated columns?
There are 2 correct answers to this question. Rank node Union node Graph node Projection node.
Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer. SDA SAP Landscape Transformation Replication Server SAP HANA streaming analytics Flat files.
Which spatial data formats can you import into SAP HANA?
There are 2 correct answers to this question. Scalable Vector Graphic (SVG) GeoJSON Well-Known Text (WKT) ESRI shapefiles.
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. The owner of the function The container’s technical user The SYSTEM user The user calling the function.
What node is used to link dimension views to a data foundation (fact tables)?
Please choose the correct answer. Star join node Projection node Join node Union node.
Why do you assign semantic types to measures or attributes in calculation views?
Please choose the correct answer. To allow client applications to present data in appropriate formats To ensure consistency across calculation views To provide meaningful value help when using variables To enable the activation of the calculation view.
Which business intelligence tool queries SAP HANA using MDX?
Please choose the correct answer. SAP Analysis for Microsoft Office SAP BusinessObjects Web Intelligence Microsoft Excel SAP Lumira, discovery edition.
What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question. Use unions instead of joins for combining large datasets. Use left outer joins instead of right outer joins. Always specify the cardinality of a join. Join as many tables as possible in a star join view’s data foundation. Always mark joins as dynamic to improve performance.
Why would you use SAP HANA Vora?
Please choose the correct answer. To provide a high-performance warm data store for data that is accessed infrequently To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis To ensure consistent HANA performance by offloading workloads when CPU usage is high To provide secure cloud integration with any HANA application.
In Web IDE for SAP HANA, what can I create in a HDB module?
There are 3 correct answers to this question. Calculation View Analytic Privilege Flowgraph HTML file.
What are features of SDA?
There are 2 correct answers to this question. Automatic data type translation Merging data from multiple sources Data cleansing Evaluation and execution of push down possibilities to remote sources.
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.
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 translations exist To find all places where an information model has been deployed To find all places where an information model is used.
Of which SAP HANA process are the transaction manager and page manager a part?
Please choose the correct answer. Index server Name server Application server Statistics server.
Which of the following are features of a data warehouse?
There are 3 correct answers to this question. Data governance A full transactional history Both OLTP and OLAP in one system Real-time reporting Consolidation.
Which of the following can a level hierarchy do?
Please choose the correct answer. Be used for a bill of materials (BOM) structure Enable drilldown in a value help list Have time-dependency Show variable deepness in the data.
What character is prepended to a SQLScript variable when it’s used as an input variable?
Please choose the correct answer. _ (underscore) : (colon) & (ampersand) ! (exclamation mark).
What are advantages of column store tables?
There are 3 correct answers to this question. Columns can be partitioned They are optimized for high-volume read / write transactional processing Only the columns required are actually loaded to memory Data footprint is automatically reduced through compression.
Which of the following features analyze dependencies between models?
There are 2 correct answers to this question. Data lineage Column lineage Impact analysis Mapping Analysis.
You use parallelism to calculate a year-to-date value quickly, and you elimi- nate a table from the database. What are some of the implications of this action?
There are 3 correct answers to this question. Smaller database backups Better user interfaces Faster inserts into the database Less code Faster response times.
With which statement can you call a table function?
There are 2 correct answers to this question. INSERT INTO CALL EXEC SELECT.
Which type of cloud solution is Amazon Web Services (AWS) an example of?
Please choose the correct answer. Public cloud Hybrid cloud Community cloud Private cloud.
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. When you build only the dimension calculation view, the build fails. When you build the HDB module, the build fails. When you build only the dimension calculation view, the build is successful. When you build the HDB module, the build is successful.
What do we implement to restrict access to specific data rows of a calculation view?
Please choose the correct answer. Authorisation object HANA Database Procedure SQL permission Analytic privilege.
Which storage is required if you implement multistore tables for SAP HANA?
Please choose the correct answer. Delta storage Nearline storage Extended storage Remote storage.
What are key features of SAP HANA?
There are 3 correct answers to this question. Automatic compression of data Removes the need for cache In-memory database Combined OLTP and OLAP processing on one platform.
You have Model B that is based on Model A. You have NOT built any of the models yet. You delete Model A. What happens during the build?
There are 2 correct answers to this question. The build of the entire HDB module is successful The build of Model B is successful You get an error when you build the entire HDB module You get a build error when you build Model B.
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 BusinessObjects Web Intelligence SAP Crystal Reports for Enterprise SAP Lumira, designer edition SAP Lumira, discovery edition.
Using SAP Analysis for Microsoft Office, your calculation view on SAP application data returns data from two clients. In SAP Web IDE, you have identified the column to be used as the client column.
Which of the following approaches will return data from only one client?
Please choose the correct answer. Create a variable on the client column in the properties of the Star join node.
Set flexible default values set for each user. Create a Union node with two sources.
Filter one source on client 001 and the other source on client 002. Set the default client property of the Semantic node to Session Client
Set the preferred client in the user settings of SAP HANA. Create a Context for each client.
Assign the relevant Context to each user.
Which are of the following languages supported by SAP HANA Graph are optimized for graph processing?
There are 2 correct answers to this question. SQL SQL Script Cypher Query Language GraphScript.
What is scale-out?
There are 2 correct answers to this question. Use of multiple servers to spread processing and improve performance. Use of commodity servers that are used in high volume steaming applications. Use of remote servers to store archived data that is rarely used. Use of standby servers in the event of hardware failure.
What should you keep in mind about procedures?
There are 3 correct answers to this question. They can call table functions. They are NOT open to SQL injection. They may have input parameters. They can call views. They must return values.
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. An object privilege on the WORLD calculation view An analytic privilege on both calculation views An analytic privilege on the WORLD calculation view An analytic privilege on the INDIA calculation view.