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.
You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables?
Please choose the correct answer. Calculation view of dimension type with a union node Calculation view of dimension type with a join node Calculation view of cube type with a join node Calculation view of cube type with a union node.
What can you identify using the performance Analysis Mode?
There are 2 correct answers to this question. Information about join cardinality Joins that are based on calculated columns Usage statistics of the calculation view Longest running query step.
You have a calculation view which includes nodes as shown in the graphic.
You decide to select the "Ignore multiple output for Filters" checkbox on projec-tion node 3. What might the effects of this be?
There are 2 correct answers to this question. Increased performance The view will return the profit calculation for only the US Decreased performance A change to the data that is returned by the view.
In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer. _SYS_BIC schema Repository package Container schema Database user schema.
You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
There are 2 correct answers to this question. To hide individual patients in groups of similar records To restrict data access for specific users or roles To add noise to the data to hide the actual values To provide partial values such as #3434 3#34##.
For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer. Master data Transactional data Materialized cube data Calculated data.
You require faster performance for a frequently queried calculation view. You have just enabled the static Results cache for this calculation view with a cache period = 120 minutes.
What are effects of this action?
There are 3 correct answers to this question. users MAY NO LONGER see the most current data in the output. Additional memory will be consumed by the calculation view Updating of the underlying tables in the calculation view will be delayed for 120 minutes. Variables can no longer be used by this calculation view CPU usage for the calculation view will be reduced.
Which recent technology advances have made SAP HANA possible?
There are 2 correct answers to this question. Multicore processors Faster disk speeds Faster internet speeds Larger and cheaper memory.
Identify the join that checks the From and To column on the left table.
Please choose the correct answer. Text Join Full Outer Join Right Outer Join Left Outer Join Temporal Join.
In SAP HANA Series Data processing, what is the definition of a profile?
Please choose the correct answer. A variant of data set, such as actual, forecast, or long-term plan The values that you are storing, such as temperature, en-ergy consumption, or speed The granularity of time intervals, such as day, hour, or mi-nute The object you collect data against, such as house, buidling, or town.
In a calculation view, what is the purpose of a variable?
Please choose the correct answer. To break up complex SQL into smaller steps To pass values between procedures and calculation views To provide a run-time attribute filter based on a user input To capture the interim result of a calculation in an expres-sion.
Why do you create calculation views of data category DIMENSION with type TIME?
Please choose the correct answer. To apply automatic adjustment to unequal time snapshots on series data To enable time-dependent master data attributes to be consumed in a star schema To provide additional time-related navigation possibilities. To provide the time intervals required by time-dependent parent-child hierarchies.
What can you discover using Data Lineage?
Please choose the correct answer. Access statistics Underlying calculation views and tables Frequency of load Data changes since last refresh.
Which of the following features of an XS Advanced application are provided by an HDB module?
There are 2 correct answers to this question. Persistence layer User interface Business logic Virtual data modeling.
What can you use SAP HANA smart data access for?
There are 2 correct answers to this question. To load harmonize data from disparate sources To expose data from remote tables To push down queries to data sources To replicate remote data sources.
Which of the following approaches can be used to implement union pruning?
There are 2 correct answers to this question. Define a constant value for each data source in the Union node. Define a restricted column and include it in both data sources of a union. Define the cardinality between the data sources. Define union pruning conditions in a pruning configuration table.
In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?
Please choose the correct answer. Table function Scalar function CDS View Procedure.
Where will you find the Data Distribution Optimizer?
Please choose the correct answer. SAP HANA Studio SAP BW/4HANA SAP HANA Data Warehousing foundation SAP S4/HANA Dictionary.
Why would you use SAP HANA Vora?
Please choose the correct answer. To provide a high-performance warm data store for data that is accessed infrequently To provide secure cloud integration with any HANA application To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis To ensure consistent HANA performance by offloading workloads when CPU usage is high.
What should you keep in mind when using imperative logic in SQLScript?
Please choose the correct answer.
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 created a table using the SQL console inside the HANA deployment infrastructure (HD) container of project You export project and re-import it with a different project name to same database.
What do you observe the SAP HANA database module?
Please choose the correct answer. The build fails and the table is NOT present The build is successful but the is NOT present The build is successful and the table and its data are present.
For which data types does SAP HANA automatically create full-text indexes?
There are 3 correct answers to this question. SHORTTEXT CLOB TEXT BINTEXT NVARCHAR.
Which type of cloud solution is Amazon Web Services (AWS) an example of?
Choose one: Hybrid cloud Private cloud Public cloud Community cloud.
What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question. The stepparent node ID must be entered according to the node style you selected for the hierarchy. The stepparent node must already exist in the hierarchy at the root level. A stepparent only applies to parent-child hierarchies. The stepparent node must already exist in the hierarchy at any level.
Which type of tables required extended storage?
Please choose the correct answer. Multistore tables Column tables Row tables In-memory tables.
Which deployment scenario can you use to accelerate reporting from an old SAP R/3 system?
Please choose the correct answer. SAP HANA as a database SAP HANA Multitenant Database Containers (MDC) SAP HANA as a side-by-side accelerator SAP HANA as a platform.
What is a multistore table?
Please choose the correct answer. A table that can distribute its partitions across memory and extended storage tiers A table that can hold data in row and column orientation A table that can be shared across multiple instances of HANA A table that can be shared across multiple instances of SAP HANA Cockpit.
To what subset of SQL does the SELECT statement belong?
Please choose the correct answer. DQL DDL DML DCL.
You set up in currency conversion in a calculation view. When your currency conversion fails, what could you choose to populate the target column?
There are 2 correct answers to this question. <EMPTY> Null THE source amount THE source amount.
You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.
The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY.
How do you ensure accurate results, regardless of the column in the query output?
Please choose the correct answer. Set the Transparent Filter property for STATE Set STATE as an aggregated column Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL.
Why do you build a calculation view of type DEFAULT?
Please choose the correct answer To support optimized multidimensional reporting To ensure all reporting tools can consume the calculation view To provide a data source that is only consumed by other calculation views. To provide a leaner model when only attributes are required.
In which parts of a SELECT statement can you include the ST_Within spatial predicate?
Note: There are 2 correct answers to this question. WHERE clause GROUP BY clause JOIN condition HAVING clause.
Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
Please choose the correct answer. They are deprecated They introduce security risks due to SQL injection They can harm SQL optimization NOT all reporting tools can consume the results.
What development tool is available for creating SAP HANA XSA and HDI information models?
Please choose the correct answer. SAP HANA Studio Database Explorer SAP Web IDE for SAP HANA SAP HANA Web-Based Development Workbench.
In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer. Container schema _SYS_BIC schema Database user schema Repository package.
In SAP HANA Series Data processing, what is the definition of a profile?
Please choose the correct answer. The granularity of time intervals, such as day, hour, or minute The values that you are storing, such as temperature, energy consumption, or speed The object you collect data against, such as house, buidling, or town A variant of data set, such as actual, forecast, or long-term plan.
In SAP BW, when we refer to mixed modeling, what do we mean?
Choose one: Integration of models from BW on non-HANA databases combined with SAP HANA optimized BWmodels Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views Integration of SAP NetWeaver Components into complex SAP HANA BW models.
What spatial data type would you use to store multiple shop locations?
Please choose the correct answer. ST_Polygon ST_MultiPoint ST_Point ST_MultiLineString.
|
