Sh_3

What are the database query languages used by SAP HANA? There are 2 correct answers to this question. Response: ODBC. JDBC. SQL. ABAP. MDX.

A company sends out a lot of quotes. Some customers accept the quotes, and they’re invoiced. The company asks you to find a list of the customers that did NOT accept the quotes. How do you find the customers that received quotes but did NOT receive invoices? Please choose the correct answer. Response: Use a left outer join. Filter to show only customers on the right table. Use a right outer join. Filter to show only customers on the left table. Use a right outer join. Filter to show only the NULL values on the right table. Use a left outer join. Filter to show only the NULL values on the right table.

When we refer to mixed modelling, what do we mean? Please choose the correct answer. Response: Classic BW models combined with SAP HANA optimized BW models. Models from BW on anyDB combined with models from BW on HANA. BW models combined with native SAP HANA models. NetWeaver models combined with native SAP HANA models.

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

What is XS? Please choose the correct answer. Response: A native, lightweight application server. A user interfaces. A data cleansing engine. An optional engine to handle excessive data loads.

What is a new and recommended way to work with SQL and SQL-Script? Please choose the correct answer. Response: Use CE-functions rather than SQL syntax. Use table functions rather than scripted calculation views. Use. procedure files rather than creating SQL and SQL-Script via the package context menu. Create runtime objects rather than design-time objects.

For which deployment scenario does SAP deliver prebuilt data models? Please choose the correct answer. Response: SAP HANA on the cloud. SAP HANA as a platform. SAP HANA as an accelerator. SAP HANA as a sidecar solution.

In the SAP HANA modeler, what object does the ‘Rename and Adjust References’ feature apply to? Please choose the correct answer. Response: A node in an information view. An information views. A column in an information view. An input parameter in an information view.

What API would you use in SAP HANA SPS 11/12 to display search results in an ABAP system? Please choose the correct answer. Response: The esh_search procedure. SAP HANA Simple Info Access API (SINA). SAP HANA Text Analysis XS JavaScript API. SAP HANA Text Mining XS JavaScript API.

Which recent trends have triggered the need for a next generation data processing platform? There are 3 correct answers to this question. Response: Increasing connectivity of people and devices. Move transactional processing and analysis to separate servers for better scalability. Massive growth in data volume. Increase in use of mobile devices.

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? There are 3 correct answers to this question. Response: The supported file types for upload are .csv, and .txt. The new table always has a 1:1 mapping between the file and table columns. When loading new data in a table that already contains data, the new data is appended to the existing data. Renaming of columns and changing data types is allowed when loading data to new HANA tables.

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. Response: Polygon. Point. Line. Multipolygon.

Modeling package Shops is a subpackage of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. How can you achieve this? Please choose the correct answer. Response: Assign REPO.READ privilege only to package Regions. Refactor package Shops to another package. Revoke analytic privileges for models in package Shops. Assign REPO.EXPORT only to package Shops.

How many tiers do you usually find in an SAP HANA application? There are 2 correct answers to this question. Response: 1. 3. 4. 2.

To what subset of SQL does the SELECT statement belong? Please choose the correct answer. Response: DCL. DQL. DML. DDL.

The company’s board members want to run simulations on the year-end financial data. What do you use to build this for them? Please choose the correct answer. Response: A variable. An expression. A decision table. A parent-child hierarchy.

What is SQLScript? Please choose the correct answer. Response: A simplified query language aimed at business users that generates SQL. An extension to standard SQL that provides additional expressions, functions and datatypes. A subset of standard SQL that is exposed to HANA database procedures. A subset of standard SQL that is exposed to HANA modelers.

Where is SAP HANA Live installed? Please choose the correct answer. Response: In the reporting tool. On SLT. In the SAP HANA database. On the SAP ERP application server.

What do we implement to restrict access to specific data rows of a calculation view? Please choose the correct answer. Response: Authorisation object. Analytic privilege. SQL permission. HANA Database Procedure.

To start and stop Data Provisioning tasks, which are the following privileges should users have to start or stop tasks? There are 2 correct answers to this question Response: Start task: sap.hana.io.dp.monitor::StartTask. Stop task: sap.hana.io.dp.monitor::StopTask. Start task: sap.hana.im.dp.monitor::StartTask. Stop task: sap.hana.im.dp.monitor::StopTask.

In SAP HANA Studio, what would you find in a Package? There are 3 correct answers to this question. Response: Tables. Procedures. Analytic Privileges. Calculation Views.

In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? There are 2 correct answers to this question. Response: Reporting performance. Superior data quality. Tighter security. Data loading performance.

What is SAP Enterprise Architecture Designer? Please choose the correct answer. Response: A tool to support sizing of an SAP HANA solution. A tool to support the build of a logical data model. A tool used to simulate different HANA hardware configurations. A tool used to define a data loading job.

What SAP HANA spatial type would you most likely use to represent the State of Colorado on a visual application? Please choose the correct answer. Response: Square. Line. Polygon. Point.

When would you use a function? Please choose the correct answer. Response: 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. To develop a calculation view with the best possible performance.

What can be used to return multiple result sets? There are 2 correct answers to this question. Response: Procedure. Table function. View. Scalar function.

What are features of SAP S/4HANA? There are 2 correct answers to this question. Response: Optimized for SAP HANA but maintains compatibility with other platforms. SAP HANA Live provides real time operational analytics. Embedded Analytics. Rewritten ABAP code optimized for SAP HANA.

When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system? Please choose the correct answer. Response: When you edit an existing model. When validation of a model fails. When you selected Revert to Active on an inactive version. When you create a new model.

Which scenario is supported to base an analytic privilege on a hierarchy defined on an attribute column? Response: Create a classical analytic privilege based on a level hierarchy. Create an SQL analytic privilege based on a parent-child hierarchy. Create a classical analytic privilege based on a parent-child hierarchy. Create an SQL analytic privilege based on a level hierarchy.

The SAP HANA Direct Extractor Connection (DXC) provides SAP HANA with out-of-the-box foundational data models based on SAP Business Suite entities. Which are the following characteristics match with SAP HANA DXC? There are 3 correct answers to this question Response: Scale down the timelines for SAP HANA implementation projects. No additional server or application needed in system landscape. Batch-driven data acquisition and considered as a form of extraction. Provides a mechanism to properly handle data from all landscape processing. Reduces complexity of data modeling tasks.

In which of the following circumstances do you use graph processing? There are 2 correct answers to this question. Response: To identify customer sentiments from social media content. To find the shortest path between supplier and consumer. To identify the strongly connected members of a social media group. To improve performance on complex charts and dashboards.

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

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

You create a graphical calculation view that is consumed in ABAP. What setting in the currency semantics dialog box ensures that a currency column is interpreted correctly in the ABAP layer? Please choose the correct answer. Response: Rounding. Decimal shift back. Conversion. Decimal shift.

In which sequence is SAP ERP data exposed to a reporting tool using SAP HANA Live? Please choose the correct answer. Response: - The reporting tool reads a reuse view. - The reuse view is based on a query view. - The query view is based on physical tables. - The reporting tool reads a value help view. - The value help view is based on a reuse view. - The reuse view is based on a query view. - The reporting tool reads a private view. - The private view is based on a query view. - The query view is based on a table function. - The reporting tool reads a query view. - The query view is based on a reuse view. - The reuse view is based on physical tables.

What must I create to develop a predictive model? Please choose the correct answer. Response: Flowgraph. Predictive Analysis Library. Procedure. Calculation View.

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

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

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

Which of the following statements describe a standard SAP system land- scape used for transports? Please choose the correct answer. Response: The quality assurance system is normally a recent copy of the production system. You perform development in the quality assurance system. Transports go from production to quality assurance. It consists of only a quality assurance and a production system.

How should I ensure my users do not see values in a sensitive column that is part of a standard SAP HANA Live view? Please choose the correct answer. Response: Mark the column as ‘hidden’ in the semantic layer of the view. Delete the column from the private view. Delete the column from the query view. Use the Extension Assistant to remove the column.

You 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. What do you use? Please choose the correct answer. Response: A variable from a projection node. A variable from the semantics node. An input parameter from the semantics node. An input parameter from an aggregation node.

When do you use the hidden attribute in a dimension calculation view? Please choose the correct answer. Response: When you want to hide an attribute that is not required for client consumption. When you want to hide the attribute in your cube calculation view. When you want to include an attribute that is not required for cube consumption. When you need to include the attribute in your calculation view to define a join.

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

Which are true statements? There are 3 correct answers to this question. Response: SAP HANA runs on Intel x86 and SPARC hardware platforms. SAP HANA can be installed only by certified engineers for production purposes. Customers can re-use their own certified hardware components in an SAP HANA system. SAP HANA runs on Unix. SAP HANA is available in the cloud or on premise or a combination of both.

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

What do you create to find the number of unique items sold per shop? Please choose the correct answer. Response: A calculation view with a counter in an aggregation node. A calculation view with a counter in a projection node. A calculation view with a restricted column in an aggregation node. An analytic view with a calculated column in an star join node.

What are the two views in the Web IDE for SAP HANA? There are 2 correct answers to this question. Response: Catalog. Database Explorer. Database Functions. Development.

You created a procedure without defining the security option. Which user’s authorizations are checked when the procedure is executed in production? Please choose the correct answer. Response: The system administrator that transported the procedure. The _SYS_REPO user. The user calling the function. The developer that created the procedure.

Which of the following benefits characterize the use of a design time filter? There are 3 correct answers to this question. Response: The filter is applied on the table before the query is executed. It is applied before a table join is executed. It is defined on the runtime in the SQL query. It reduces the result set of data. The filter is applied on the result set of a query.

Which are of the following languages supported by SAP HANA Graph are optimized for graph processing? There are 2 correct answers to this question. Response: SQL Script. SQL. GraphScript. Cypher Query Language.

In Web IDE for SAP HANA, what can I create in a HDB module? There are 3 correct answers to this question. Response: Calculation View. Flowgraph. HTML file. Analytic Privilege.

Why did SAP move from XS to XSA? There are 2 correct answers to this question. Response: To provide better source code management tools inside SAP HANA. To include ABAP as a key development language for native SAP HANA applications. To implement micro-services architecture. To move to Cloud Foundry architecture to allow flexible application deployment options.

Which recent technology advances have made SAP HANA possible? There are 2 correct answers to this question. Response: Larger and cheaper memory. Multicore processors. Faster disk speeds. Faster internet speeds.

You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed? There are 3 correct answers to this question. Response: SAP HANA predictive analytics library (PAL) flows. SAP HANA extended application services (XS) programs. SAP HANA smart data access (SDA) queries. SAP HANA smart data streaming (SDS) projects. SAP HANA enterprise information manager (EIM) jobs.

Which of the following features analyze dependencies between models? There are 2 correct answers to this question. Response: Column lineage. Impact analysis. Mapping Analysis. Data lineage.

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

What system privilege do you need to create a delivery unit? Please choose the correct answer. Response: REPO.IMPORT. REPO.WORK_IN_FOREIGN_WORKSPACE. REPO.EXPORT. REPO.MAINTAIN_DELIVERY_UNITS.

Which of the following features of an XS Advanced application are provided by an HDB module? There are 2 correct answers to this question. Response: Virtual data modeling. Persistence layer. Business logic. User interface.

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

What happens when you activate an information model? There are 2 correct answers to this question. Response: It checks the validation rules. It generates a runtime object. It exports an active version. It reverts to the active version.

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

What are features of Business Suite on SAP HANA? There are 2 correct answers to this question. Response: Combine operational analytics and transaction processing. Massive performance improvement. Embedded Analytics. ABAP is replaced with JAVA.

Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? There are 2 correct answers to this question. Response: Data is available in real time using SLT. It offers a simplified landscape. It provides a quick start for customers using Business Suite on non HANA databases. There is no data movement.

In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question. Response: The function can return multiple values. The function must be of the type scalar. The generated value can be overwritten at runtime. The input parameter must be set to mandatory.

The virtual data model for SAP S/4HANA is based on which of these? Please choose the correct answer. Response: ABAP CDS. SAP HANA CDS. SAP HANA Live. Universe.

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

Which version of CDS is used by S/4HANA? Please choose the correct answer. Response: None of these. HANA CDS. Both ABAP CDS and HANA CDS. ABAP CDS.

Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session. The value of a global session variable is not visible from another session. Please choose the correct answer. Response: SET <global> = <key>;. SET <key> = <value>;. SET <key> = <global>;. SET <value> = <key>;.

How many processing tiers do you usually find in a native SAP HANA application stack? Please choose the correct answer. Response: 3. 4. 1. 2.

What information is available when you use the Explain Plan functionality on an SQL statement? There are 2 correct answers to this question. Response: Estimated execution time. Operator names. Execution engines. Estimated number of records.

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

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. Response: 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 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.

Identify the object that adds a WHERE clause to the query. Please choose the correct answer. Response: Attributes. Modeler. Input parameter. Variable.

In which SAP HANA views will you find measures? There are 2 correct answers to this question. Response: Calculation view of type cube. Attribute views. Database views. Calculation view of type cube with star join.

Where do you build a flowgraph? There are 2 correct answers to this question. Response: Web IDE for SAP HANA. SAP HANA Studio modeler perspective. SAP HANA Studio development perspective. Web-based development workbench.

What node can you use to generate a column for use in sorting results? Please choose the correct answer. Response: Union node. Rank node. Aggregation node. Projection node.

Which of the following VDM views can be called by applications and reports? There are 2 correct answers to this question. Response: Private views. Query views. Value help views. Reuse views.

What are the advantages of columnar storage? There are 2 correct answers to this question. Response: Improved data reading performance. Improved data writing performance. Improved performance when all fields are selected. Improved compression.

Which of the following describe design-time objects? There are 3 correct answers to this question. Response: Catalog objects. Native objects. Active. Repository objects. Inactive.

Which database arteiact do you use to access external data from an XS Advanced project? Please choose the correct answer. Response: Synonym. Logical schema. Calculation view. User-provided service.

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

What are features of SDA? There are 2 correct answers to this question. Response: Evaluation and execution of push down possibilities to remote sources. Automatic data type translation. Merging data from multiple sources. Data cleansing.

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

When can you use the referential join? Please choose the correct answer. Response: When you have to report on all dimensions to confirm if there are matching facts or not. When you have to report on all posted facts. When referential integrity is assured. When you have to report on facts with matching dimensions.

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

Where in SAP HANA studio can you see if a table is row-based or column- based? There are 2 correct answers to this question. Response: The table’s icon. The table definition. The tooltip that appears on mouse hover over the table title. The context menu of a table.

What SELECT statement is not recommended for use with column tables? Please choose the correct answer. Response: SELECT in a subquery. SELECT *. SELECT ALL. SELECT with a time-travel clause.

Which modeling views are fading out and are not available in the SAP HANA web-based development workbench? There are 2 correct answers to this question. Response: Scripted calculation views. Attribute views. Graphical calculation views. Analytic views.

What is the recommended way to create full-text indexes going forward? Please choose the correct answer. Response: Procedures. Core Data Services. SQL statements in the SQL Console. User-defined functions.

Why do we still need a persistent layer? There are 2 correct answers to this question. Response: To enable full database recovery if we have a power failure. To hold the delta store for newly arrived records. To store data that has been unloaded from memory. To store data that is frequently used.

Which of following are features associated with SAP HANA Live? There are 2 correct answers to this question. Response: A new data warehouse. Precalculated aggregates stored in cubes. Hundreds of predeveloped views. Web-based tools.

BI tools connect to the SAP HANA database using which of these? There are 4 correct answers to this question. Response: BICS. TRFC. JDBC. ODBC. ODBO.

In which subfolder of the _SYS_BIC schema do you find activated information models? Please choose the correct answer. Response: Views. Column Views. Functions. Procedures.

Why would you use SAP HANA Vora? Please choose the correct answer. Response: To ensure consistent HANA performance by offloading workloads when CPU usage is high. To provide secure cloud integration with any HANA application. To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis. To provide a high-performance warm data store for data that is accessed infrequently.

In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node. Most queries using the view have no problems, but one query always gets a query runtime error. What is the cause of this error? Please choose the correct answer. Response: The two tables do NOT have referential integrity. The two tables are joined with a dynamic join. The language column is NOT specified in the join. An incorrect column was selected when the join was formed.

What are advantages of column store tables? There are 3 correct answers to this question. Response: They are optimized for high-volume read/write transactional processing. Columns can be partitioned. Only the columns required are actually loaded to memory. Data footprint is automatically reduced through compression.

To maintain good read performance in a constantly changing database, which two components are used? There are 2 correct answers to this question. Response: Delta storage. Column store. Memory store. Main storage.

What is a multi-target application (MTA)? Please choose the correct answer. Response: An application built with SAP HANA XS Classic (XS) that supports on-premise and cloud deployments. Multiple development project can be deployed multiple times to on-premise or cloud applications. An application built with SAP HANA XS Advanced (XSA) that supports on-premise and cloud deployments. One development project can be deployed single time to on-premise or cloud applications.

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

What character is used to terminate SQL statements? Please choose the correct answer. Response: ; (semicolon). . (period). : (colon). ? (question mark).

What are the rules for defining a stepparent in a hierarchy? There are 2 correct answers to this question. Response: The stepparent node must already exist in the hierarchy at any level. The stepparent node ID must be entered according to the node style you selected for the hierarchy. A stepparent only applies to parent-child hierarchies. The stepparent node must already exist in the hierarchy at the root level.

Which of the following SAP data provisioning tools can provide real-time data provisioning? There are 3 correct answers to this question. Response: SLT. DXC. SAP Data Services. SRS. SDI.

You are creating a currency conversion. What options do you have for the Target Currency field? There are 3 correct answers to this question. Response: Select a fixed currency. Use an input parameter. Select a column. Select a table type. Use the Derived from Table option.

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

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

Which of these is used to build the virtual data model for SAP S/4HANA? Please choose the correct answer. Response: SAP HANA CDS. ABAP CDS. Universe. SAP HANA Live.

Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system? Please choose the correct answer. Response: SAP HANA as a sidecar solution. SAP HANA as a platform. SAP HANA as a database. SAP HANA multitenant database containers.

Which engine do most SAP HANA Live views use? Please choose the correct answer. Response: SQL engine. Join engine. OLAP engine. Calculation engine.

Which technologies does SAP HANA use to load more data into memory? There are 3 correct answers to this question. Response: Eliminate indices. Store data in column tables. Use multicore CPU parallelism. Use dictionary compression. Use RAR compression.

Which type of cloud solution is SAP HANA Enterprise Cloud (HEC) an exam- ple of? Please choose the correct answer. Response: Software as a Service (SaaS). Managed Cloud as a Service (MCaaS). Infrastructure as a Service (IaaS). Platform as a Service (PaaS).

You create a full-text index. For what text feature clause do you need to specify a configuration? Please choose the correct answer. Response: TEXT MINING. SEARCH ONLY. FUZZY SEARCH INDEX. TEXT ANALYSIS.

Which of the following are capabilities of SAP HANA Live Browser? There are 3 correct answers to this question. Response: You can launch the views using SAP Analysis Edition for Microsoft Excel. You can adjust the views by adding additional columns. You can develop personal lists of frequently used query views. You can graphically illustrate the dependencies between SAP HANA Live views.

What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer. Response: Sorted inserts. Unsorted inserts. Parallelism. Insert-only.

What are the features of a parent-child hierarchy? There are 3 correct answers to this question. Response: Parent and child field have the same data type. Heterogeneous fields are combined in a hierarchy. A single dedicated column is used to store the parent of each record of the table. Recursive data structure defines the hierarchy.

What are components of SAP HANA EIM? There are 2 correct answers to this question. Response: SDQ. SDI. SDA. SDS.

How should you create a procedure? Please choose the correct answer. Response: Create a design-time object in a SQL console. Create a runtime object in a HANA project. Create a design-time object in a HANA project. Create a runtime object in the SQL console.

In which subarea (folder) in the Systems view of SAP HANA studio can you find the SAP HANA database schemas? Please choose the correct answer. Response: Provisioning area. Security area. Catalog area. Content area.

What artifacts do you use in the output area of a decision table node? There are 2 correct answers to this question. Response: Input parameters. Conditions. Restrictions. Actions.

What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Response: Log area. Data volume. Memory. Delta store.

What should you keep in mind when using imperative logic in SQLScript? Please choose the correct answer. Response: You can only use if-then logic. It matches SQL’s set-oriented paradigm. It delivers the best possible performance. You can loop through records.

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

For what type of data are SAP HANA calculation views of type dimension used? Please choose the correct answer. Response: Transactional data. Master data. Materialized cube data. Calculated data.

Why should HANA consultants develop SQL skills? There are 2 correct answers to this question. Response: So they can perform basic database operations such as creating, filling and reading tables. So User authentication and authorization can be secures through the HANA platform. Because scripted calculation views are recommended. So they can develop sophisticated data flows that extend beyond graphical modeling tools.

Which are valid descriptions of delivery units? There are 2 correct answers to this question. Response: Always consist of one package. Can be exported. Can be imported. Are used to transport runtime objects.

Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live? Please choose the correct answer. Response: Deeper BI functionality is available with CDS compared to SAP HANA Live. Calculation views cannot be used with S/4HANA tables. CDS is tied to the application layer for better control of complete source code transportation. More use cases are available with CDS than with SAP HANA Live.

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

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

The Data Provisioning Monitor provides a browser-based interface to monitor agents, tasks, design time objects (flowgraphs and replication tasks), and remote subscriptions created in the SAP HANA system. After you take steps to set up this Data Provisioning Monitor. Which of the following way you can view the Data Provisioning Monitors? There are 2 correct answers to this question Response: Access smart data integration links in the SAP HANA cockpit. Enter the URL address of each monitor directly into a web browser. Monitor CDS view integration links in the SAP HANA Studio. Monitor Enterprise Semantic Services publications and the Entity Grid.

SAP HANA security services include which of the following? There are 4 correct answers to this question. Response: Audit logging. Encryption. Authorization. Antivirus Protection. Authentication.

Which SAP HANA column types are part of an SAP HANA graph workspace? There are 2 correct answers to this question. Response: Edge key column. Source vertex column. Generated column. Calculated column.