SAP HANA PROFESSIONAL 2014

1

What are the consequences of executing the stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?

1

You want to add a calculated column to an SAP BusinessObjects Web Intelligence report.
In which application do you create the calculation to achieve best report performance?

1

Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database.

Which SAP HANA tool would you use?

1

Which SAP HANA privileges are used for administration tasks such as creating schemas?

1

Which delivered role is mandatory for a system administrator in SAP HANA?

1

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)

1

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
(Choose three)

1

Which connection method that is listed on the left can you use with the tools that are available in the dropdown box on the right?

Guess that there should have been a photo here :-)

1

What is an example of a selective data load using SAP Landscape Transformation?

1

What is the purpose of a template table in SAP BusinessObjects Data Services?

1

You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)

1

You modify an existing view. How can you determine which models are affected by this change?

1

You need to find out which users logged on to the SAP HANA system over the course of the last week.
What would you check?

1

Which of the following criteria indicate that you should store data in row tables?

(Choose two)

1

In which engines is an analytic view executed that contains a calculated column? (Choose two)

1

Which of the following are recommended SAP HANA modeling principles?

(Choose two)

1

Where can you reactivate a user after too many invalid logon attempts? (Choose two)

1

You receive an activation error in a scripted calculation view that uses the following function:
CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')

What could be a reason for this error?

1

The IT department has a service level agreement (SLA) that states "all production systems must be available to the end user within ½ hour of any type of system failure."
Which of the following helps meet the SLA for SAP HANA system failures?

1

What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)

1

Your data models use hierarchies.

In which front end tool can you access these hierarchies? (Choose two)

1

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

1

Which of the following can be grouped when multiple schemas exist in an SAP HANA database?

1

Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)

1

Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?

1

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

1

You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?

1

If you want to create or drop tables in a schema, which privilege type do you need?

1

Which security settings can you apply in analytic privileges? (Choose two)

1

Which tool do you use for complex data transformation of SAP ERP data?

1

Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)

1

Which of the following describes an SAP HANA analytic view?

1

Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)

1

Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?

1

You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes.

Which of the following information objects are stored on the master node?

1

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)

1

When you try to delete an attribute view you receive the error message "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view? (Choose two)

1

Which of the following tools use SQL to communicate with SAP HANA? (Choose three)

1

Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)

1

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.

Which of the following are SAP recommended actions? (Choose two)

1

How can you define conditions and actions in a decision table? (Choose three)

1

Which of the following can you use to implement currency conversion in an information model? (Choose two)

1

Your customer has the following reporting requirements:
-Real-time profitability reporting on large-scale data volumes -On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension -Cost allocation reports with significantly faster processing time

Which application do you recommend?

Quiz on SAP HANA PROFESSIONAL 2014, created by kim b on 04/09/2015.

SAP HANA PROFESSIONAL 2014

What are the consequences of executing the stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?

You want to add a calculated column to an SAP BusinessObjects Web Intelligence report. In which application do you create the calculation to achieve best report performance?

Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database. Which SAP HANA tool would you use?

Which SAP HANA privileges are used for administration tasks such as creating schemas?

Which delivered role is mandatory for a system administrator in SAP HANA?

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three)

Which connection method that is listed on the left can you use with the tools that are available in the dropdown box on the right? Guess that there should have been a photo here :-)

What is an example of a selective data load using SAP Landscape Transformation?

What is the purpose of a template table in SAP BusinessObjects Data Services?

You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? (Choose two)

You modify an existing view. How can you determine which models are affected by this change?

You need to find out which users logged on to the SAP HANA system over the course of the last week. What would you check?

Which of the following criteria indicate that you should store data in row tables? (Choose two)

In which engines is an analytic view executed that contains a calculated column? (Choose two)

Which of the following are recommended SAP HANA modeling principles? (Choose two)

Where can you reactivate a user after too many invalid logon attempts? (Choose two)

You receive an activation error in a scripted calculation view that uses the following function: CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A') What could be a reason for this error?

The IT department has a service level agreement (SLA) that states "all production systems must be available to the end user within ½ hour of any type of system failure." Which of the following helps meet the SLA for SAP HANA system failures?

What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)

You want to add a calculated column to an SAP BusinessObjects Web Intelligence report.
In which application do you create the calculation to achieve best report performance?

Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database.

Which SAP HANA tool would you use?

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
(Choose three)

Which connection method that is listed on the left can you use with the tools that are available in the dropdown box on the right?

Guess that there should have been a photo here :-)

You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)

You need to find out which users logged on to the SAP HANA system over the course of the last week.
What would you check?

Which of the following criteria indicate that you should store data in row tables?

(Choose two)

Which of the following are recommended SAP HANA modeling principles?

(Choose two)

You receive an activation error in a scripted calculation view that uses the following function:
CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')

What could be a reason for this error?

The IT department has a service level agreement (SLA) that states "all production systems must be available to the end user within ½ hour of any type of system failure."
Which of the following helps meet the SLA for SAP HANA system failures?

Your data models use hierarchies.

In which front end tool can you access these hierarchies? (Choose two)

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes.

Which of the following information objects are stored on the master node?

When you try to delete an attribute view you receive the error message "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view? (Choose two)