SuperYaz 1

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, discovery edition. SAP BusinessObjects Web Intelligence. SAP Crystal Reports for Enterprise. SAP Lumira, designer edition.

What can you determine using the hierarchy function in a calculation view? There are 3 correct answers to this question. Time interval of hierarchy nodes. Distance between root and each hierarchy node. Source attributes of a composite hierarchy node. Number of siblings for a hierarchy node. Hierarchy nodes that have no parent.

Identify the features and benefits of a calculation view. There are 3 correct answers to this question. It is not possible to join several fact tables in a calculation view. It can contain calculated attributes. It supports you to include more advanced calculations. It can be defined as a graphical view or a scripted view.

Why would you implement SAP HANA spatial services? There are 2 correct answers to this question. To map all possible relationships in a network of elements. To identify unions and intersections of elements. To calculate distances between elements. To forecast movements of elements.

In an XSA/HDI environment, which of the following is used for source version control of calculation views? Please choose the correct answer. CMS (Change Management System). Open-source Git. SAP HANA studio. CTS (Change Transport System).

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. You get a build error when you build Model A. You get an error when you build the entire HDB module. Model B gets deleted from the HDI container. The build of Model A is successful. The build of the entire HDB module is successful.

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 acts based on combinations of events. It is a standalone product for use with any target system. It uses databases queries.

What type of input parameters do you use to choose the data from a field in the current table? Please choose the correct answer. Derived from table. Value help. Direct. Column.

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. Data from the USA. Data from Europe and the USA. Data from Asia and the USA. Data from Europe, Asia, and the USA.

Which of the following would you create to build a predictive model? Please choose the correct answer. A function. A procedure​. A decision tree. A flowgraph.

Where can you set the default value for the SAP client for the entire calculation view? Please choose the correct answer. In the default node of the calculation view. In the semantic layer of the calculation view. In the Join node of the calculation view. In the Preferences option of the Tools menu.

Two calculation views, A and B, are defined as shown in the diagram. The three analytic privileges have been granted to you. When you preview calculation view A, what data do you see? Please choose the correct answer. US for P1. US for P1 and P2, and GE for P2. No data at all. US for P1 and GE for P1.

Why do we support SQL development in SAP HANA data modelling projects? Please choose the correct answer. To make changes to the runtime objects of your calculation view with SQL. As an alternative to developing calculation views when high performance is essential. To support development of custom logic within calculation views. To provide access to your data model to additional client tools.

What are the currency conversion functionalities supported by SAP HANA? There are 3 correct answers to this question. Determination of target currency based on attributes or input parameters. Conversion based on customer-defined tables. Multiple exchange rate types. Enabling of decimal shifts.

Which of the following approaches improve the performance of joins in a cube calculation view? There are 2 correct answers to this question. Determine join direction in a full outer join. Use an inner join. Limit the number of joined columns. Specify the join cardinality.

What can you use SAP HANA smart data access for? There are 2 correct answers to this question. To replicate remote data sources. To load harmonize data from disparate sources. To expose data from remote tables. To push down queries to data sources.

What are the three areas of SAP HANA Text Processing? There are 3 correct answers to this question. Text Mining. Text Analysis. Text Profiling. Text Search.

You have a view with two tables joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join? Please choose the correct answer. Change the join to a referential join. Keep the left outer join. Change the join to a right outer join. Change the join to a text join.

How could you improve the performance of joins in cube calculation views? There are 2 correct answers to this question. Specify the cardinality of the join. Avoid the use of referential joins. Join on calculated columns. Reduce the number of columns used in the join.

Where do you use SQLScript outside of the development environment discussed in this chapter? There are 3 correct answers to this question. Text analytics. Reporting tools. Security. Creating tables. Calculation views.

Why do you use Debug Query mode in a calculation view? Please choose the correct answer. To check which database engines will be invoked by each node?. To measure the overall run-time of the query. To check if SAP HANA can paralyze the entire query. To observe the generated SQL for each node.

Which type of tables required extended storage? Please choose the correct answer. In-memory tables. Multistore tables. Row tables. Column tables.

In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? There are 2 correct answers to this question. Task. Procedure. Function. Container.

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. Data footprint is automatically reduced through compression. Only the columns required are actually loaded to memory.

What information can you find in the SAP HANA Cockpit? There are 2 correct answers to this question. Trace and log files. List of operators. SQL Plan Cache. SQL generated in each step.

What do you need to do after creating a new project with an HDB module? Please choose the correct answer. Convert the new module to an HDB module. Create an .hdinamespace file. Select a space for running the project.

When using the CONTAINS predicate, what are the restrictions you must you keep in mind? There are 2 correct answers to this question. 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. Non-physical columns, such as calculated columns, are not search-relevant.

You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this? Please choose the correct answer. Mapping Required Calculation View A Input parameter Calculation View B Input parameter. You already mapped the input parameters in another calculation view. You selected the wrong parameter mapping TYPE. The names of the input parameters do not match. Your source calculation view is of the type SQL Access Only.

How can you connect SAP Analysis for Microsoft Office to SAP HANA? Please choose the correct answer. Using Direct Access Mode. Using an SAP HANA Live data connection. Using an ODBO connection. Using an SAP BusinessObjects Enterprise platform web service.

What does SQL script provide to extend standard SQL? There are 2 correct answers to this question. Support for ABAP Syntax. Additional data types for the definition of text and spatial data. Feature to encourage processing in the database. Integrated source code version management.

Which hierarchies can you enable for SQL access? Please choose the correct answer. Shared hierarchies in a star join view. Time-dependent hierarchies in a dimension view. Level hierarchies in a calculation view of type cube. Local hierarchies in a star join view.

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 provide secure cloud integration with any HANA application. To ensure consistent HANA performance by offloading workloads when CPU usage is high.

What are the features of dynamic analytic privileges? There are 2 correct answers to this question. Reuse the same analytic privilege for several users who need to access different data. Change the filter condition in the underlying tables and views. Filter the data based on a variable entered by the user when they query the view. Filter the condition based on a variable entered by the user when they query the view​.

For which deployment scenario does SAP deliver prebuilt data models? Please choose the correct answer. SAP HANA on the cloud. SAP HANA as an SQL Data Warehouse. SAP HANA as a platform. SAP HANA as a side-by-side accelerator.

What do you need to read a table from another HDI container in your information model? There are 3 correct answers to this question. Authentication. Synonym. A user-defined service. Authorization. An HDI service.

What performance technique should you implement to improve join performance? Please choose the correct answer. Join on key fields between tables in a dimension view. Do NOT use dynamic joins if you require optimal performance. Use joins instead of unions for combining large datasets. Always use referential joins in star join views.

When creating a system connection in SAP HANA Studio, which of these is essential information? There are 3 correct answers to this question. A valid user and password. Host. Instance. URL.

Why do you partition a table in SAP HANA? There are 2 correct answers to this question. To overcome the two billion record limit. To improve loading performance on large row tables. To improve response time when multiple users access the same table. To improve query performance when accessing large column tables.

You define a hierarchy in a calculation view. You went to expose the hierarchy to SQL. Which of the following conditions must be met? There are 2 correct answers to this question. The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY. The hierarchy must be a shared hierarchy. The hierarchy must be a local hierarchy. The hierarchy must be exposed by a calculation view of type CUBE with star join.

What can you discover using Data Lineage? Please choose the correct answer. Underlying calculation views and tables. Access statistics. Data changes since last refresh. Frequency of load.

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 Canada for 2018. User 1 can view any year for United States. User 2 can view any year for United States.

Where in a calculation view can you add a Graph node? Please choose the correct answer. Always as the bottom (leaf) node. Only as the top node. Anywhere from the bottom (leaf) node to the default node.

Why do you use a hierarchy function node in a calculation view? Please choose the correct answer. To enable hierarchical navigation in reporting tools. To assist the developer by visualising hierarchies. To generate additional Meta data that can be used for analysis of a hierarchy structure. To display value help using hierarchies.

In your rank node, why do you set the dynamic partition element flag? Please choose the correct answer. To generate the ranking partition based on the column selected in the query. To determine the ranking threshold value base on an input parameter. To determine the partitioning logic using an SQL expression. To define time dependency on a partition.

What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container? Please choose the correct answer. Database Connection. Function. Synonym. Wrapper.

For what SQL keyword is the Aggregation node the equivalent? Please choose the correct answer. ORDER BY. UNIQUE. GROUP BY. DISTINCT.

What PAL algorithm would you use to analyze shopping baskets? Please choose the correct answer. K-means. Decision tree. Apriori. Link prediction.

Which of the following are capabilities of SAP HANA Live Browser? There are 3 correct answers to this question. You can adjust the views by adding additional columns. 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 develop personal lists of frequently used query views.

What is a multistore table? Please choose the correct answer. A table that can distribute its partitions across memory and extended storage tiers. A table that can be shared across multiple instances of HANA. A table that can be shared across multiple instances of SAP HANA Cockpit​. A table that can hold data in row and column orientation.

What is the SQL keyword used to process input parameters defined in a calculation view? Please choose the correct answer. Where. Set. Hint. Placeholder.

In SAP HANA Series Data processing, what is the definition of a profile? Please choose the correct answer. A variant of data set, such as actual, forecast, or long-term plan. The granularity of time intervals, such as day, hour, or minute. The object you collect data against, such as house, building, or town. The values that you are storing, such as temperature, energy consumption, or speed.

Which are the recommended assignments in SAP HANA? There are 2 correct answers to this question. Roles to users. Roles to roles. Roles to privileges. Privileges to users.

Why might you use the Keep Flag property in an aggregation node? Please choose the correct answer. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query. To exclude columns that are NOT requested by a query to avoid incorrect results. To retain the correct aggregation behavior in stacked views. To include columns that are NOT requested by a query but are essential for the correct result.

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot? Please choose the correct answer. Implement a union node and map each year as a separate column. Create a filter expression that uses an OR operator. Create a restricted column for each year. Create 3 calculated columns.

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January 2018 AND February 2018. What is the optimal way to do this? Please choose the correct answer. Use a minus node. Use an aggregation node. Use a union node. Use an intersect node.

Which tool should you use to generate and execute the SQL for a specific node of your calculation view? Please choose the correct answer. Explain Plan. SQL Analyzer. Database Explorer. Debug Query Mode.

An SAP HANA Live model is displayed as in invalid view in the list of models in the SAP HANA Live browser. What could be the reason? There are 2 correct answers to this question. The model has been deleted. The model's underlying table is not fully replicated. The model is missing a dependent view. The model is missing an underlying table.

Why would you create a procedure? There are 2 correct answers to this question. If you need to define a calculated column expression. If you need to insert records into a table. If you need to provide a data source to a graphical calculation view. If you need a mixture of scalar and tabular output parameters.

In which programming languages can you create procedures in SAP HANA? There are 2 correct answers to this question. L. Javascript. R. SQLScript.

What is needed in an SAP Vora deployment? There are 2 correct answers to this question. SAP HANA data warehousing foundation. Apache Spark. Apache Hadoop. SAP Data Services.

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. The name property. The mapping property. The label column property. The label property.

What join type should you use to see all the suppliers? Please choose the correct answer. Referential join. Inner join. Right outer join. Left outer join.

Which are the components of SAP HANA Cloud? There are 3 correct answers to this question. SAP Analytics Cloud. Native Storage Extension. SAP HANA Cloud data lake. SAP HANA in-memory database. SAP Data Warehouse Cloud.

Why would you implement a hierarchy function node in a calculation view? Please choose the correct answer. To assist the developer by visualizing hierarchies. To enable a hierarchical drill-down in reporting tools. To generate a list of descendants for a hierarchy node. To display value help using hierarchies.

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. SEQUENTIAL EXECUTION. LANGUAGE SQLSCRIPT. READS SQL DATA. WITH RESULTS VIEW.

After implementing static cache in a calculation view, you notice that queries are not hitting the cache. What might be the reason for this? There are 2 correct answers to this question. You set the hint to use cache at the top-most calculation view. You did not define any columns in the cache setting. Your calculation view checks analytic privileges. Your calculation view can be fully unfolded.

You have copied a design-time file from a source folder to a target folder that has the same namespace setting. In which of the following scenarios will a build of the copy design-time file be successful? There are 2 correct answers to this question. The source design-time file has been built once but the built has failed. The source design-time file has been deleted from the source folder in the meantime. The source design-time file has never been built. The build of the copy design-time file will always be successful.

Which type of cloud solution is Amazon Web Services (AWS) an example of? Please choose the correct answer. Community cloud. Private cloud. Hybrid cloud. Public cloud.

Which type of cloud solution is SAP HANA Enterprise Cloud an example of? Please choose the correct answer. Platform as a service (PaaS). Managed cloud as a service (MCaaS). Infrastructure as a service (IaaS). Software as a service (SaaS).

Why should you define calculated column expressions using plain SQL and avoid using column engine language? Please choose the correct answer. To benefit from additional SQL optimizations. To prevent queries from unfolding. To allow imperative statements. To access the full set of SQL functions.

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. Use an explicit reference to the schema. Assign the provided ::access role to your container’s technical user. Make use of the built-in HDI service. Make use of a user-provided service. Create a synonym.

What node can you use for sorting results, for example, to show the top 100? Please choose the correct answer. Projection node. Rank node. Union node. Aggregation node.

What are valid types of calculation view? There are 3 correct answers to this question. Dimension. Cube with star schema. Cube. Dimension with star schema.

What does SAP HANA provide to support native application development? There are 3 correct answers to this question. Tools for code creation and debugging. Choice of development language. Incident tracking tools. Tools to support automated regression testing. Full stack development.

What paradigm describes the SQL language? Please choose the correct answer. Application-focused. Procedural. Object-oriented. Set-oriented.

Which of the following node types can you use to build a dimension view? There are 3 correct answers to this question. Star join node. Aggregation node. Union node. Data foundation node. Semantics node.

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment? Please choose the correct answer. Build the project -> Build the HDB module. Activate the project -> Build the HDB module. Build the HDB module -> Build the project. Export the HDB module -> Export the project.

You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers. What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables? Please choose the correct answer. Calculation view of dimension type with a join node. Calculation view of cube type with a union node. Calculation view of dimension type with a union node. Calculation view of cube type with a join node.

What is the SAP HANA Application Function Library (AFL)? There are 2 correct answers to this question. Repository of ready-made predictive algorithms. Repository of ready-to-run applications that are powered by SAP HANA. Repository of ready-made business functions. Repository of connections that can be used by business functions.

A column in your table will be used for text search. Why do you define the column as a text type instead of a string type? Please choose the correct answer. To enable the full set of SQL operations. To enable a linguistic analysis. To allow processing of multiple languages. To enable lower memory consumption.