Kopieren und bearbeiten

SAP HANA PROFESSIONAL 2014

Beschreibung

Quiz am SAP HANA PROFESSIONAL 2014, erstellt von kim b am 04/09/2015.
kim b
Quiz von kim b, aktualisiert more than 1 year ago
kim b
Erstellt von kim b vor etwa 9 Jahre
144
1
0

Zusammenfassung der Ressource

Frage 1

Frage
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?
Antworten
  • A. Triggers and logging tables are deleted.
  • B. The table is dropped from the SAP HANA database.
  • C. Triggers and logging tables are kept.
  • D. The replication of the table is temporarily stopped.

Frage 2

Frage
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?
Antworten
  • A. Central Management Console
  • B. Information Design Tool
  • C. Web Intelligence D. SAP HANA Studio
  • D. SAP HANA Studio

Frage 3

Frage
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?
Antworten
  • A. Data preview
  • B. View contents
  • C. View log
  • D. SQL console

Frage 4

Frage
Which SAP HANA privileges are used for administration tasks such as creating schemas?
Antworten
  • A. System privileges
  • B. Package privileges
  • C. Analytic privileges
  • D. Application privileges

Frage 5

Frage
Which delivered role is mandatory for a system administrator in SAP HANA?
Antworten
  • A. SYS_ADMIN
  • B. CONTENT_ADMIN
  • C. SAP_ALL
  • D. IC MODELER

Frage 6

Frage
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)
Antworten
  • A. Install SAP Business Warehouse Accelerator (BWA).
  • B. Perform a database migration from your current DB to SAP HANA DB.
  • C. Execute the report RS_BW_POST_MIGRATION.
  • D. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.
  • E. Recreate SAP BW indexes after SAP HANA database migration.

Frage 7

Frage
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three)
Antworten
  • A. Define a projection.
  • B. Write an SQL script.
  • C. Save and activate the view.
  • D. Define output fields.
  • E. Choose a data source.

Frage 8

Frage
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 :-)
Antworten
  • A. RFC
  • B. ODBC/JDBC
  • C. BICS
  • D. ODBO

Frage 9

Frage
What is an example of a selective data load using SAP Landscape Transformation?
Antworten
  • A. Selected data field values are randomized and loaded into SAP HANA.
  • B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
  • C. Selected data for transformation is split into portions.
  • D. Selected data for a range of years is loaded into SAP HANA.

Frage 10

Frage
What is the purpose of a template table in SAP BusinessObjects Data Services?
Antworten
  • A. To create pre-designed information models
  • B. To fill an existing target table with new data
  • C. To read source data and perform data transformations D. To create a target table and fill this table with data
  • D. To create a target table and fill this table with data

Frage 11

Frage
You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? (Choose two)
Antworten
  • A. In the Catalog node of SAP HANA studio
  • B. In the SAP BusinessObjects Data Services job monitor
  • C. In the Content node of SAP HANA studio
  • D. In the SAP BusinessObjects Data Services table preview

Frage 12

Frage
You modify an existing view. How can you determine which models are affected by this change?
Antworten
  • A. Use the audit trail.
  • B. Use the History feature for the changed model.
  • C. Use the "Where-Used List" feature for the changed model.
  • D. Use the "Auto Documentation" to compare the object version of the changed model.

Frage 13

Frage
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?
Antworten
  • A. The Audit log
  • B. Entries in M_CONNECTIONS
  • C. The nameserver_history.trc file
  • D. The indexserver_alert.trc file

Frage 14

Frage
Which of the following criteria indicate that you should store data in row tables? (Choose two)
Antworten
  • A. The tables have a large number of columns.
  • B. The tables require frequent write access.
  • C. The information models search the table based on the values of a few columns.
  • D. The information models frequently needs to access complete records.

Frage 15

Frage
In which engines is an analytic view executed that contains a calculated column? (Choose two)
Antworten
  • A. Calculation engine
  • B. Row store engine
  • C. OLAP engine
  • D. Join engine

Frage 16

Frage
Which of the following are recommended SAP HANA modeling principles? (Choose two)
Antworten
  • A. Use complex expressions like IF or CASE
  • B. Always do the calculation after aggregation
  • C. Filter the data amount as early as possible in the lower layers
  • D. Join tables on key columns

Frage 17

Frage
Where can you reactivate a user after too many invalid logon attempts? (Choose two)
Antworten
  • A. In the SQL console
  • B. In the user specific schema
  • C. In the INVALID_CONNECT_ATTEMPS view
  • D. In the user properties

Frage 18

Frage
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?
Antworten
  • A. The filter condition is not set within square brackets.
  • B. The projection list contains a field that is not specified in the filter condition.
  • C. The filter condition must be specified inside the projection list.
  • D. The filter condition contains a field that is not part of the projection list.

Frage 19

Frage
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?
Antworten
  • A. Disaster recovery
  • B. Scale up
  • C. Side-by-side scenario
  • D. Scale out high availability

Frage 20

Frage
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)
Antworten
  • A. Fixed-scope implementation
  • B. No need for consultants
  • C. Lower risk
  • D. Pre-configured content
  • E. Customized content

Frage 21

Frage
Your data models use hierarchies. In which front end tool can you access these hierarchies? (Choose two)
Antworten
  • A. SAP BusinessObjects Dashboards
  • B. SAP BusinessObjects Crystal Reports 2011
  • C. SAP BusinessObjects Analysis, edition for OLAP
  • D. SAP BusinessObjects Analysis, edition for Microsoft Office

Frage 22

Frage
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?
Antworten
  • A. JOIN in a calculation view
  • B. JOIN in an analytic view
  • C. UNION in a calculation view
  • D. PROJECTION in a calculation view

Frage 23

Frage
Which of the following can be grouped when multiple schemas exist in an SAP HANA database?
Antworten
  • A. Information models
  • B. Data tables
  • C. Packages
  • D. Users

Frage 24

Frage
Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)
Antworten
  • A. It is based on analytic denormalized data models
  • B. It uses real-time replication of time-critical data
  • C. It runs directly on top of the operational data
  • D. It persists transformed data

Frage 25

Frage
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?
Antworten
  • A. Analytic view
  • B. Calculation view using SQL
  • C. Calculation view using SQL Script
  • D. Attribute view

Frage 26

Frage
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
Antworten
  • A. Crystal Reports
  • B. Dashboards
  • C. Explorer
  • D. WebIntelligence

Frage 27

Frage
You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?
Antworten
  • A. Use the Activate with History function.
  • B. Use the Where-Used List function.
  • C. Use the Cascade Activate function.
  • D. Activate each view manually.

Frage 28

Frage
If you want to create or drop tables in a schema, which privilege type do you need?
Antworten
  • A. SYSTEM
  • B. ANALYTIC
  • C. PACKAGE
  • D. SQL

Frage 29

Frage
Which security settings can you apply in analytic privileges? (Choose two)
Antworten
  • A. Grant access to analytic views.
  • B. Restrict access within an analytic view using measure values.
  • C. Restrict access within an analytic view using attribute values.
  • D. Restrict access to hierarchies.

Frage 30

Frage
Which tool do you use for complex data transformation of SAP ERP data?
Antworten
  • A. SAP Landscape Transformation (SLT)
  • B. Sybase Replication Server
  • C. SAP BusinessObjects Data Services
  • D. SAP BusinessObjects Explorer

Frage 31

Frage
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)
Antworten
  • A. Define an output structure for the attribute view.
  • B. Define the data foundation.
  • C. Choose the type of hierarchy.
  • D. Define calculated attributes for the nodes of the hierarchy.
  • E. Define an analytic view.

Frage 32

Frage
Which of the following describes an SAP HANA analytic view?
Antworten
  • A. It is a set of tables joined together in a star schema.
  • B. It is a copy of data after transformation.
  • C. It is a reusable object in attribute views.
  • D. It is a materialized set of data.

Frage 33

Frage
Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)
Antworten
  • A. Generate and save an export file to a shared directory.
  • B. Assign the content repository to a transport request.
  • C. Mass copy the content repository into the other SAP HANA system.
  • D. Assign the package to a delivery unit.

Frage 34

Frage
Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
Antworten
  • A. Only the last active version
  • B. All active and inactive versions
  • C. All active versions
  • D. The last active and inactive version

Frage 35

Frage
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?
Antworten
  • A. SAP NetWeaver BW master data tables
  • B. DataStore Objects (DSOs)
  • C. ABAP system tables
  • D. Persistent Staging Area (PSA) tables

Frage 36

Frage
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)
Antworten
  • A. The sizing of your current SAP BW application servers remains valid.
  • B. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
  • C. It allows re-use of your available SAP BW application servers.
  • D. It eliminates the need to upgrade to the latest SAP BW application version.
  • E. The system usage is the same as an equivalent SAP BW on non-SAP databases.

Frage 37

Frage
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)
Antworten
  • A. History function
  • B. Auto Documentation function
  • C. Display XML function
  • D. Where-Used function

Frage 38

Frage
Which of the following tools use SQL to communicate with SAP HANA? (Choose three)
Antworten
  • A. SAP BusinessObjects Web Intelligence
  • B. SAP BusinessObjects Analysis, edition for OLAP
  • C. SAP BusinessObjects Information Design Tool
  • D. SAP BusinessObjects Analysis, edition for Microsoft Office
  • E. SAP BusinessObjects Dashboards

Frage 39

Frage
Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)
Antworten
  • A. SQL plan cache
  • B. Timeline
  • C. Explain plan
  • D. Visualize plan

Frage 40

Frage
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)
Antworten
  • A. Automate the ETL processes in SAP NetWeaver using process chains.
  • B. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.
  • C. Create new InfoObjects for the SAP HANA InfoProviders.
  • D. Schedule the real-time data loads into SAP HANA.

Frage 41

Frage
How can you define conditions and actions in a decision table? (Choose three)
Antworten
  • A. Use ABAP routines
  • B. Use conditional expressions
  • C. Use CE functions
  • D. Use date operations
  • E. Use mathematical operations

Frage 42

Frage
Which of the following can you use to implement currency conversion in an information model? (Choose two)
Antworten
  • A. A calculated column in a calculation view
  • B. A restricted column in an analytic view
  • C. A calculated column in an analytic view
  • D. A calculated column in an attribute view

Frage 43

Frage
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?
Antworten
  • A. SAP Bank Analyzer with SAP HANA
  • B. SAP Deposits Management with SAP HANA
  • C. SAP HANA CO-PA Accelerator
  • D. SAP HANA for Banking
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Physik: Elektrizität und Energie
JohannesK
Unregelmäßige Verben Englisch
Janine Egli
Stilmittel
Cassibodua
Lernplan
barbarabfm
Öff. Recht - Streitigkeiten Verwaltungsrecht AT
myJurazone
Die deutsche Romantik in der Literatur
Roland Baumann
Themen der Vektorrechnung II
Paula Raithel
GPSY ALPS
Malte Ni
Vetie - Biochemie
Fioras Hu
PuKW WERB (Matthes)
Lara Gundacker
Vetie Tierhygiene und Tierhaltung Übungsfragen 2019/2020
Maite J
Bibliothek durchsuchen