

Write and execute an appropriate SQL statement.ġ1. Execute an information space using SAP Business Objects Explorer.ĭ. Execute a Web Intelligence report and check the duration of the previous refresh.Ĭ. Use the Data Preview function in the SAP HANA studio.ī. How can you evaluate the speed of a calculation within the database? (Choose two)Ī. Which of the following properties of a derived attribute view can you modify?ġ0. You can easily create an IDT business layer.ĩ. You can execute ad-hoc business analytics quickly.Į. You can access information for data discovery intuitively.ĭ. You can easily create your own queries to access information.Ĭ.

You do not need to create your own queries to access information.ī. What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)Ī. In the calculation view using an attribute value variableĨ. Where do you apply the filter for optimal performance?ĭ. You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Authorizations granted on a schema are automatically propagated to all objects within the schemaħ. It is possible to grant authorizations on a table level.Ĭ. One table may appear in exactly one schemaī. Which of the following statements are true?Ī. Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.Ħ. Plant_text = SELECT plant_text FROM WERKS WHERE id = ant The two queries below, which is more efficient? Import source system metadata -> Deploy ->Create Information Models -> Provision Data -> Consumeĥ. Import source system metadata -> Provision Data -> Deploy -> Create Information Models -> Consumeĭ. Import source system metadata -> Provision Data ->Create Information Models -> Deploy -> ConsumeĬ. Import source system metadata -> Create Information Models -> Provision Data -> Deploy -> Consumeī. Which of the following represents a logic flow of activities?Ī. SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models. HANA supports which of the following hierarchies?Ĥ. Calculation views can include measures and be used for multidimensional reporting or can contain no measures and used for list-type of reportingģ. Calculated attributes are derived from one or more existing attributes or constants.ĭ. An analytic view is used to model data that includes measures.Ĭ. All these views are non-materialized views.ī. There are four types of information views: attribute view, analytic view, hierarchy view and calculation view. Which of the following is NOT a replication method for data replication from a source system to SAP Hana?Ģ.

When the installation is complete, the system displays the message "You have successfully installed the SAP HANA Studio."
