Which spatial data formats can you import into SAP HANA?
There are 2 correct answers to this question. Well-Known Text (WKT) ESRI shapefiles ESTI shapefiles Scalable Vector Graphic (SVG).
Why do you assign semantic types to measures or attributes in calculation views?
Please choose the correct answer. To allow client applications to present data in appropriate formats To ensure consistency across calculation views To provide meaningful value help when using variables To enable the activation of the calculation view.
What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question. Use unions instead of joins for combining large datasets. Use left outer joins instead of right outer joins. Always specify the cardinality of a join. Join as many tables as possible in a star join view’s data foundation. Always mark joins as dynamic to improve performance.
You create a full-text index. For what text feature clause do you need to specify a configuration? SEARCH ONLY FUZZY SEARCH INDEX TEXT MINING TEXT ANALYSIS.
What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question. SAP client restrictions Domain fix values Filter expressions Restricted columns Generated columns.
Which text feature do you use to find sentiment in textual data?
Please choose the correct answer. Full-text index Fuzzy text search Text analysis Text mining.
What do you need for Active/Active (read-enabled) mode?
There are 2 correct answers to this question. Log replication Disaster recovery Extended storage Multitenant Database Containers (MDC).
Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live?
There are 2 correct answers to this question. More use cases are available with CDS than with SAP HANA Live. Deeper BI functionality is available with CDS compared to SAP HANA Live. CDS is tied to the application layer for better control of complete source code transportation. Calculation views cannot be used with S/4HANA tables.
What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
Response:
Perform calculation before aggregation in your analytic views. Investigate partitioning of large tables. Apply filters as late as possible. Push down aggregations to SAP HANA. Minimize the transfer of data between the execution engines.
You want to show a male and female option to end users. What feature do you use?
There are 3 correct answers to this question. Expressions Input parameters Variables Value help Domain fix values.
You want to build a hierarchy on a time-based data structure, such as year, month, and day. What type of hierarchy do you use?
Please choose the correct answer. Parent-child hierarchy Unbalanced hierarchy Ragged hierarchy Level hierarchy.
Which of the following benefits characterize the use of a design time filter?
There are 3 correct answers to this question. The filter is applied on the table before the query is executed. It is defined on the runtime in the SQL query. It is applied before a table join is executed. It reduces the result set of data. The filter is applied on the result set of a query.
What is a multistore table?
Please choose the correct answer. A table that can be shared across multiple instances of SAP HANA Cockpit 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 distribute its partitions across memory and extended storage tiers.
In a calculation view, where can you use SQL?
There are 3 correct answers to this question. Union pruning conditions Filter expression Calculated column expression Input parameter Aggregation node.
Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question. Avoid aggregating data early in the data flow Partition large tables Minimize layering of calculation views Implement union pruning.
Why might you use the keep flag in an aggregation node?
Please choose the correct answer. To retain the results of the aggregation node for reuse in a drill-down based on hierarchy To include columns that are NOT requested by a query but are essential for the correct result To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query.
Question: 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.
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.
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.
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.
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.
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?
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.
You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.
Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?
Please choose the correct answer. Impact Analysis Database explorer Show lineage Where used.
Why might you use SAP HANA Graph with text analysis?
Please choose the correct answer. To provide a visual method to build a custom text analysis To highlight similarities between documents using hierarchies. To illustrate multi-point relationships between text entities To uncover the dependencies between parts of speech.
Where is SDI used? (2) For data cleansing For data transformation For data streaming For data loading.
What are the typical characteristics of Data replication? (2) Virtualization Transformation Real-time Batch Synchronisation.
Which standard data streaming language does SAP HANA support? Computational Continuous Language Dynamic SQL Python Pearl.
What is the type that used for currency conversion? VARCHAR(10) VARCHAR(5) CHAR(5) NCHAR(10).
YOU WILL DO A QUERY IN (CCL) COMPUTATION CONTINUOUS LANGUAGE. THAT WILL BRING A LOT OF DATA, WHAT TYPE OF QUERY SHOULD BE USED? DATABASE QUERIES CONTINUOUS QUERIES PYTHON PEARL.
WHICH OF THE FOLLOWING VIEWS CAN YOU EXTEND WITH THE SAP HANA LIVE? (2) REUSE VIEWS VALUE HELP VIEWS PRIVATE VIEWS CUSTOMER QUERY VIEWS QUERY VIEWS CALCULED VIEWS.
You have a procedure called by a DECISION TABLE, through which you can send the conditions (CONDITIONS)? INPUT PARAMETER CONDICION VARIABLE FILTRO.
TWO STATES OF A TABLE: THE FIRST WITH A NUMERIC DATA COLUMN, AND ANOTHER COLUMN WITH YEAR; THE SECOND STATE WITH A COLUMN FOR EACH YEAR AND THE RESULT OF THAT NUMBER FOR EVERY YEAR. WHAT ARE YOU REFERRING TO?
(Al parecer son dos (2) respuestas) CALCULATED COLUMNS ANALYTIC COLUMN RESTRICTED COLUMN CONVERSION COLUMNS.
Which of the following views can be extended by using the SAP HANA Live extension assistant?
There are 2 correct answers to this question. A custom view A query view A private view A reuse view.
In an XSA/HDI environment, which of the following is used for source version control of calculation views?
Please choose the correct answer. SAP HANA studio CTS (Change Transport System) CMS (Change Management System) Open-source Git.
Which type of join supports a temporal condition in a calculation view?
Please choose the correct answer. Text join Referential join Inner join Left outer join.
Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to creating the output from the screenshot?
Please choose the correct answer. Create a filter expression that uses an OR operator Create a restricted column for each year Implement a union node and map each year as a separate column.
You are building a new calculation view, A, Which includes a projection node that refers to another calculation view, B. WHY would you use the extract semantics feature?
Please choose the correct answer. To apply the semantics of calculation view B TO the semantics of calculation view A To automatically map the input parameters from calculation view B to an input parameter of calculation A To SET the semantics of calculation view A TO THE DEFAULT VALUES To improve the performance of calculation view A by only referencing the semantics calculation view B and not duplicating it.
You created a calculated column in a star join view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong results.
What could be the problem? You mistyped the calculated column expression. You chose the SQL expression syntax. You did NOT enable the Keep Flag. You did NOT enable the currency conversion.
In your rank node, why do you set the dynamic partition element flag?
Please choose the correct answer. To define time dependency on a partition
To determine the ranking threshold value base on an input parameter To generate the ranking partition based on the column selected in the query To determine the partitioning logic using an SQL expression.
Which generated output column uses hierarchies?
Please choose the correct answer. Restricted Column Calculated Column Node Column Rank Column.
What are the features of dynamic analytic privileges?
There are 2 correct answers to this question. Filter the condition based on a variable entered by the user when they query the view Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data Filter the data based on a variable entered by the user when they query the view.
Where will you find the Data Distribution Optimizer? SAP BW/4HANA SAP HANA Studio SAP S4/HANA Dictionary SAP HANA Data Warehousing foundation.
You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view.
- In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view.
- You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?
There are 2 correct answers to this question. When you build only the dimension calculation view, the build fails. When you build the HDB module, the build fails. When you build only the dimension calculation view, the build is successful. When you build the HDB module, the build is successful.
What SAP HANA feature do you use to host multiple applications for different companies in single SAP HANA landscape while ensuring isolation?
Please choose the correct answer. Multitenant Database Containers (MDC) Active/Active (read-enabled) mode SAP HANA as a distributed database Extended storage.
What are the features of Delta Store? Read-optimized, sorted columns Read-optimized, non sorted columns or rows Write-optimized, non sorted columns or rows Write-optmized, sorted columns.
What is prerequisite and what must be installed to install *PAL (Predictive Analisys Library)*?
3 correct answers. Se debe tener instalado AFL (Application Function Library) El script server debe estar iniciado Al usuario se le haya asignado el rol AFL_SYS_AFL_AFLPAL_EXECUTE TO_SYS_REPO with grant option.
La pregunta de term matrix. Full text search Text mining .
Pregunta del text analisis. rules set text mining term matrix Consultar respuesta.
Pregunta sobre poligonos. Scalable vector graphic (SVG) GeoJson ESRI WKT .
¿Se se necesita tener instalado para el APL?
respuestas: ScriptServer Database AFL PAL Consultar respuestas.
|
