Prueba de fuego HANA 1.2

Identify the principles that you need to follow during modeling. There are 2 correct answers to this question. You should reduce data transfer between the views by applying filters as low down as possible. You should push data processing to the client as much as possible. You should perform calculations before aggregation. You should create joins on key columns.

The relational model of SAP HANA Live is built using which type of views? Please choose the correct answer. Analytic views and attribute views. Calculation views of data category cube without star join. Scripted calculation views. Calculation views of data category cube with star join.

What are typical characteristics of SAP HANA data replication? There are 2 correct answers to this question. Real-time. Duplicate data. Streaming. Virtualization.

What node uses a special configuration table to optimize performance? Please choose the correct answer. Aggregation node. Projection node. Join node. Union node.

Which of the following are types of calculation view? There are 2 correct answers to this question. Virtual. Cube. Composite. Dimension.

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. Suggested filter for the tables in the Join node. Total number of records returned by the node. Time taken by the join. Tables used by the join in the node.

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). CTS (Change Transport System). SAP HANA studio. Open-source Git.

What are the limitations of using a full outer join in a star join node? There are 2 correct answers to this question. It is restricted to one dimension in a star join node. It is NOT available in a star join node. It CANNOT be mixed in the same star join nod with other join types. It must appear in the last dimension in the star join node.

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? There are 2 correct answers to this question. To ensure that the join execution only uses the join columns requested in the query. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query. To ensure that the aggregation always happens after the join execution. To allow data analysis at different levels of granularity with the same calculation view.

What are some best practices when developing calculation views? There are 2 correct answers to this question. Avoid mixing CDS views with calculation views. Create calculation views that can be unfolded. Create star schemas using analytic views. Include all data flow logic within one calculation view.

What can you extract using the standard text analysis configuration: Voice of the Customer? There are 2 correct answers to this question. Sentiments. Recommendations. Suggestions. Requests.

Why might you want to reference a user-provided service in a project? Please choose the correct answer. To access data from your project container. To access data from another container. To access data from a classic database schema.

What is a role of the SAP HANA Cockpit? Please choose the correct answer. To secure the SAP HANA Database. To provide an application developer collaboration hub. To provide KPIs to help focus on business performance. To provide key system performance information for one or more HANA instances.

What are key features of SAP HANA? There are 3 correct answers to this question. Removes the need for cache. Combined OLTP and OLAP processing on one platform. In-memory database. Automatic compression of data.

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.

You’re working with a currency measure. What is decimal shift used for? Please choose the correct answer. To increase the accuracy of the currency conversion. To avoid rounding errors during the conversion. To undo the decimal adjustment for ABAP. For currencies with more than two decimal places.

Which business intelligence tool queries SAP HANA using MDX? Please choose the correct answer. SAP BusinessObjects Web Intelligence. SAP Lumira, discovery edition. SAP Analysis for Microsoft Office. Microsoft Excel.

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 and P2, and GE for P2. No data at all. US for P1 and GE for P1. US for P1.

Which modeling features can you use in flowgraphs? There are 2 correct answers to this question. Text. Predictive. Graph. Spatial.

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-relatedissue and the build fails. What could be the reason? There are 2 correct answers to this question. The imported calculation view and its data source have different namespaces. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. The .hdinamespace file specifies a different namespace property than the one in the identifier of the calculation view. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

From where does the Extract Semantics feature get the definition of hierar- chies? Please choose the correct answer. From the table data sources. From the underlying dimension views. From the SQL view data sources. From the current calculation view.

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes. What is the correct approach? Please choose the correct answer. - Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. - Use a star join node to join the dime1sions to the fact table. - Combine the transaction tables using a star join node in a calculation view of type cube with star join. - Use the same star join node to connect the dimensions to the fact table. - Combine the transaction tables using a join node in a calculation view of type cube with star join. - Use a star join node to join the dimensions to the fact table. - Combine the transaction tables using a star join node in a calculation view of type cube with star join. - Use a join node to join the dimensions to the fact table.

What performance technique should you implement to improve the performance of SAP HANA information views? Please choose the correct answer. Supply reporting tools with all the data in one transfer. Output as many fields as possible. Build single large views. Implement union pruning conditions.

What are the four SAP HANA platform services? There are 4 correct answers to this question. Application Services. Processing Services. Security Services. Integration Services. Database Services.

You want to retrieve data from a web application. Which of the following could you use? There are 3 correct answers to this question. BICS. JDBC. JSON. OData. REST.

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 provides a quick start for customers using Business Suite on non HANA databases. There is no data movement. It offers a simplified landscape.

When do you use the SQL Analyzer? Please choose the correct answer. To investigate the generated SQL for each node in my calculation view. To hide the syntax errors in my SQL code. To highlight syntax errors in my SQL code. To identify the longest running SQL statements.

What character is prepended to a SQLScript variable when it’s used as an input variable? Please choose the correct answer. _ (underscore). : (colon). ! (exclamation mark). & (ampersand).

You have to build a parent-child hierarchy. What type of join do you expect to use? Please choose the correct answer. Relational join. Temporal join. Dynamic join. Self-join.

Identify the join that checks the From and To column on the left table. Please choose the correct answer. Left Outer Join. Temporal Join. Text Join. Right Outer Join. Full Outer Join.

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 a spatial data type. Store green as an attribute. Store green as a CDS view. Store green as a measure.

How would you most likely represent the location of an ATM in a visual application that uses SAP HANA spatial processing? Please choose the correct answer. Line. Multipolygon. Point. Polygon.

Why do you create a multistory table? Please choose the correct answer. To have a table that combines the characteristics of row and column stores. To have the option to partition the table across different storage tiers. To evenly distribute the data across all available server nodes. To improve read performance when accessed by simultaneous applications.

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

Why do you use SAP HANA Graph? Please choose the correct answer. To model highly-networked entities. To access advanced chart types from calculation views. To push down graphic processing of the database. To develop a dashboard to present KPIs.

Which interface client is used for XSA application development? Please choose the correct answer. SAP Web IDE for SAP HANA. SAP HANA Studio. SAP Web IDE. SAP HANA Web-based Workbench.

Why would you develop an SQL procedure instead of a function? There are 3 correct answers to this question. Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. Contribute: Please send the correct answers with reference text/link on feedback@erpprep.com to get up to 50% cashback. Optimal performance is a priority. You want to create a dynamic analytic privilege. You need to use conditional logic. The code should modify data in the table. A temporary table must be created within the code.

Which types of calculation views can you create? There are 2 correct answers to this question. Time-based. Standard. Derived. Materialized.

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

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

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

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.

Referring to the diagram which privileges would a user require to view United States data when querying the CUBE Calculation view? Please choose the correct answer. A SELECT privilege on the CUBE and an analytic privilege (Country = United States) on the DIMENSION calculation view. A SELECT privilege and an analytic privilege (Country = United States) on the DIMENSION calculation view. Analytic Privilege and SELECT privilege on the CUBE calculation view. SELECT privileges and Analytic Privileges on both views.

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

Which are functions of SAP HANA series data? There are 2 correct answers to this question. Anonymize observations. Identify abnormal observations. Align observations to a consistent time interval. Geo-code observations.

A referential join gives the same results as which other join type? Please choose the correct answer. Star join. Left outer join. Spatial join. Inner join.

What is the preferred way to create a procedure? Please choose the correct answer. Use the Import menu in the SAP Web IDE for SAP HANA. Use the CREATE PROCEDURE statement in the SQL console. Create a .procedure file. Create a .hdbprocedure file.

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join you did not set cardinality of the data sources. Why will this NOT work? Please choose the correct answer. Full outer joins are NOT available in the star join node. Full outer joins CANNOT be mixed on the same star join node with other join types. Full outer joins require to be set. Full outer joins restricted to one dimension in a star join node.

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 allow imperative statements. To prevent queries from unfolding. To access the full set of SQL functions.

Which words are associated with the log volume? There are 2 correct answers to this question. Synchronous. Savepoint. Transaction manager. Page manager.

What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer. Extract - Transform - Load. Load - Transform - Extract. Load - Extract - Transform. Extract - Load - Transform.

When using the CONTAINS predicate, what are the restrictions you must you keep in mind? There are 2 correct answers to this question. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables. Non-physical columns, such as calculated columns, are not search-relevant. Wild cards* and? Are supported for text columns but not string columns. The NOT (-) operator can only be specified directly after the OR operator.

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

Which generated output column uses hierarchies? Please choose the correct answer. Node Column. Restricted Column. Calculated Column. Rank Column.

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

What tool generates files to help configure SAP Landscape Transformation Replication Server table replication? Please choose the correct answer. Authorization Assistant. SAP HANA Live Extension Assistant. SAP HANA Studio. SAP HANA Live Browser.

In SAP WebIDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the opt on to rename the runtime view and adjust the reference. Afterward, you perform the following build operations: - 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. The first build is successful. The second build fails. The first build fails. The second build fails. The first build fails. The second build is successful. The first build is successful. The second build is successful.

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 container’s technical user. The user calling the function. The owner of the function. The SYSTEM user.

Your calculation view presents employee names which must only be seen by managers. Which steps are required to implement this? There are 2 correct answers to this question. Include an anonymization node in the calculation view. Set the column to hidden in the calculation view. Create SQL expression to define the concealing logic for the column. Assign the UNMASK privilege to the managers for the calculation view.

Which data provisioning tools can use SAP HANA adapters? There are 2 correct answers to this question. SDI. SAP Replication Server. SDA. SAP HANA streaming analytics.

When do you use the hidden attribute in a dimension calculation view? Please choose the correct answer. 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. When you want to include an attribute that is not required for cube consumption.

Question: Why should you use variables in SQL Script? There are 2 correct answers to this question. To increase parallelization opportunities. To support processing push-down. To implement flow control logic. To improve code readability.

Question: You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources. How do you check if pruning occurs? There are 2 correct answers to this question. Preview the data results in the calculation view. Enable Debug Query mode to identify the columns used. Use the SQL Analyzer to identify the tables used. Explore the number of used columns in the Performance Analysis mode.

Question: Which of the following data operations can you perform with SDA? There are 3 correct answers to this question. Data federation. Physical data warehouse. Logical data warehouse. Real-time replication.

Question: 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. Change the join to a right outer join. Change the join to a text join. Keep the left outer join.

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

Question: What does SAP HANA load when starting up and before indicating that it’s ready? There are 3 correct answers to this question. All system tables. All partitions. Some row tables. All row tables. Some column tables.

Question: What are some of the elements defined in a graph workspace? There are 2 correct answers to this question. Source and target columns of the vertex table. The vertex table. The language used to construct the graph. Source and target columns of the edge table.

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

Question: 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 deleted from the source folder in the meantime. The source design-time file has been built once but the built has failed. The build of the copy design-time file will always be successful. The source design-time file has never been built.

Question: In a text-type fuzzy search I enter ‘SAP’ as the search word. Against term ‘SAPPHIRE’ will I get a high or low score? Please choose the correct answer. Low. Medium. High. Normal.

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

Question: 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. The project is not assigned to a space. Building a project does not generate the database content of its HDB modules. You have the Developer role in the assigned space. You do not have the Developer role in the assigned space.

Question: In an XSA/HDI environment, where do you find run-time objects? Please choose the correct answer. Database user schema. Container schema. Repository package. _SYS_BIC schema.

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

Question: 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. Less code. Better user interfaces. Smaller database backups. Faster inserts into the database. Faster response times.

Question: How do you move code to SAP HANA? There are 2 correct answers to this question. Use stored procedures in SAP HANA. Delete the application server. Use row tables in SAP HANA. Use graphical data models in SAP HANA.

Question: 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. An input parameter from an Aggregation node. A variable from the Semantics node. A variable from a Projection node. An input parameter from the Semantics node.

Question: When you create a full text index, why do you specify FAST_PREPROCESS OFF? There are 2 correct answers to this question. To enable a full linguistic search. To prevent the creation of a fuzzy search index. To avoid the generation of the term document matrix. To generate text analysis results in multiple languages. When the hierarchy is a shared hierarchy.

Question: When would you use a function? Please choose the correct answer. To develop a calculation view with the best possible performance. When you need to write results back to a table. To break SQL into smaller statements. When you need to define complex data sources for my calculation view that require conditional logic.

You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies. Which tool do you use? Please choose the correct answer. SAP Lumira, discovery edition. SAP Lumira, designer edition. SAP Analysis for Microsoft Office. SAP BusinessObjects Web Intelligence.

Question: A partitioned column table is present only in the persistent layer of an SAP HANA system Which columns and partitions are loaded into memory when the table is accessed by an application? Please choose the correct answer. ONLY the required partitions and all the columns. ONLY the required columns and the required partitions. All the partitions but ONLY the required columns.

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

Question: You want to star schema using calculating view. The measure are based on columns from two transaction table dimension calculation views provide the attributes. What is the correct approach? Please choose the correct answer. 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 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 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. 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.

Question: Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer. It is a standalone product for use with any target system. It provides reports and analysis on the received data. It uses databases queries. It acts based on combinations of events.

Question: Why would you create a procedure? There are 2 correct answers to this question. 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. If you need to define a calculated column expression.

Question: What are the basic spatial shapes you can store in SAP HANA Spatial? There are 3 correct answers to this question. Lines. Polygons. Graphs. Points.

Relacione los colores: Amarillo + Rojo. Azul + Amarillo. Rojo + Azul. Blanco + Negro.