Advanced H.2

You want to join 2 tables in CV . When would you non-equi join?. Join is part of Star join. Join requires a <(Less than) Operator. Cardinality is impossible to determine. Cardinality is 1: n.

In SAP Web IDE for SAP HANA , what can a flow graph generate in a predictive analysis scenario?. Function. Container. Task. Procedure.

Which of the following are no longer required in the architecture of SAP S/4 HANA. Synonyms. Aggregates. Column tables. Indexes.

In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA. Your stacked model consists of multiple CV. your column table`s delta store is frequent larger than its main store. You have a large column store table that is consumed in a view with a variable on country column. you have a large row store table that is consumed a view with a variable on country column.

In your rank mode, why do you set the dynamic partition element flag. To define the ranking threshold value based on input parameters. To generate the ranking partition based on columns select in the query. To determine the partitioning logic using an SQL expression. To define time dependency on a partition.

What can you identify using Performance Analysis Mode?. Information about join cardinality. Longest running query step. sage statistics of the calculation view. Joins that are based on calculated columns.

Which of the following views can be extended by using the SAP HANA Live extension assistant. custom view. private view. reuse view. query view.

What is the persistent storage layer used for?. To enable data to be recovered if hardware fails. TO improve the parallel processing of queries. To store the data primarily used for transaction processing. To unload the least-used data when the memory is full.

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables Dimension calculation view provide the attributes. What is the correct approach?. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use an aggregation node to join the dimensions to the fact table. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.

In text processing, where do you use the Term Document Matrix?. Text mining. Fact and entity extraction. Linguistic extraction. Fuzzy text search.

You are a data analysis working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?. To restrict data access for specific users or roles. To provide partial value such as #3434 3#34##. To add noise to the data to hide the actual values. To hide individual patients in groups of similar records.

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval? Please choose the correct answer. Horizontal disaggregation. Vertical aggregation. Vertical disaggregation. Horizontal aggregation.

What conditions must be met before you can implement time dependency on a hierarchy in a calculation view?. The hierarchy must be a parent-child hierarchy. The hierarchy must be a level hierarchy. The key date parameter must be derived from an input parameter. The hierarchy must be enabled for SQL access.

What can you extract using the standard text analysis configuration: Voice of the Customer?. Sentiments. Request. Recommendation. Suggestions.

You set up currency conversion in a calculation view. When your currency conversion failed, what could you choose to populate the target column?. The source amount. A default value. Null. <EMPTY>.

What conditions must be met to ensure the Dynamic Join feature works properly? 2 correct. At least one joined column must be specified in the query. Multiple columns must be defined in the join. Cardinality must be set. The join must be defined on key columns.

Before deploying your calculation views to a PROD environment, which sequence of steps is required? Please choose the correct answer. Build the HDB module -> Build the project. Activate the project -> Build the HDB module. Build the project -> Build the HDB module. Export the HDB module -> Export the project.

Why do you use the query debug mode in a calculation view?. To check if SAP HANA can parallelize the entire query. To measure the overall run-time of the query. To observe the generated SQL for each node. To check which database engines will be involved by each node.

In a calculation view, where can you use SQL? 3 correct. Calculated column expression. Filter expression. Input parameter. Aggregation node. Union pruning condition.

Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018? Please choose the correct answer. Use an intersect node. Use a full outer join. Use an left outer join. Use a union node.

Why would you use the XS Advanced Migration Assistant? 2 correct. To convert attribute views to CDS views. To convert Studio-developed objects for use with Web IDE for SAP HANA. To move HDI-developed calculation views to repository packages. To convert analytic views to calculation views.

When can you expose a hierarchy that is defined in a calculation view for access with SQL?. When the hierarchy is a local hierarchy. When the hierarchy is a shared hierarchy. When the hierarchy is defined in a calculation view of type CUBE. When the hierarchy is defined in a calculation view of type DEFAULT.

An SAP HANA Live model is displayed as an invalid view in the list of models in the SAP HANA Live browser. What could be the reason? 2 correctas. The model has been deleted. The model is missing an underlying table. The model´s underlying table is not fully replicated. The model is missing a dependent view.

Which are views of the SAP supplied virtual data model of Embedded Analytics? There are 2 correct answers to this question. Composite. Calculation. Basic. Attribute.

On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA. Which tools can you use? There are 2 correct answers to this question. SAP HANA smart data access. SAP HANA smart data integration. SAP Data Services. SAP Landscape Transformation Replication Server.

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot?. Implement a union node and map each year as a separate column. Create a restricted column for each year. Create a filter expression that uses an OR operator.

How can you optimize performance when writing SQL for use with calculation views? 2 correctas -. Use calculation engine (CE) functions instead of plain SQL. Increase paralization by using variables to break up statements. Control the flow logic using IF-THEN-ELSE conditions. Use declarative language instead of cursors.

Which of the following data sources can you include in a graphical calculation view? 2 correctas. SQL view. Table function. Procedures. Scalar function.

Why does SAP issue warnings about the use of imperative of procedural SQL Script statements?. They are deprecated. NOT all reporting tools can consume the results. They introduce security risks due to SQL injection. They can ham SQL optimization.

You created a table function to sum the total weekly working hours for each employee and update the personnel table. You CANNOT activate the table function. What could be the problem? -. You did NOT define a valid table type. You do NOT have write permissions to the personnel table. You CANNOT update records using a table function. You did NOT create synonyms for the table.

Why do you use parameter mapping in a calculation view? 2 correctas. To push down filters to the lowest level calculation views. To pass a value from a variable to an input parameter. To convert the data types of input parameters. To pass variable values to external value help views.

Which types of data are used to represent spatial information? 2 correct. Rasted data. Column data. Vector data. Graph data.

When modeling in the Web IDE for SAP HANA, which object do you build provide access to tables in external schemas?. Container. Analytic privileges. Synonym. Role.

What can you use SAP HANA smart data access for? Note: these are 2 correct answers to this question. To load and harmonize data from disparate sources. To push down queries to data sources. To expose data from remote tables. To replicate remote data sources.

When using the CONTAINS predicate, what are the restrictions you must you keep in mind? 2 correctas. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only of the tables. Wild cards * and ? are supported for text columns but not string columns. The NOT (-) operator can only be specified directly after the OR operator. Non-physical columns, such as calculated columns, are not search relevant.

You have two tables with two columns CUSTOMER_NAME and COUNTRY_NAME, one with Italian customers and other with French customers. What type of calculation view should you create to combine customers?. Dimension type with join node. Cube with join node. Cube with union node. Dimension with union node.

ou want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this?. Your source calculation view is of the type DEFAULT. You did not push the Auto Map button. You already mapped the input parameters in another calculation view. You selected the wrong parameter mapping TYPE.

In an XSA / HDI environment, which of the following is used for source version control of calculation views?. SAP HANA studio. Open-source Git. MS (Change Management System). CTS (Change Transport System).

You use the Show Lineage feature within a Calculation View What information does this feature provide. The Origin of column. The list of data sources for each node. THe overview of all data sources. An overview of information model that consumed in the view.

What must you consider to create PAL functions. 1. Function. 2. Synonym. 3. Wrapper. Container.

What can you discover using data Lineage. Data changes since last refresh. Access Statistics. Underlying calculation. Frequency of load.

10. You create a hierarchy in a dimension calculation view. You then consume this dimension cal. View. How do you allow SQL access to the hierarchy. 1. Enable SQL access in view proprieties of the dimension cal. View. Obtain generated node names in local hierarchies. 2. Enable SQL access in view proprieties of the cube cal. View. Obtain generated node names in shared hierarchies. 3. Enable SQL access in view proprieties of the cube cal. View. Obtain generated node names in local hierarchies. 4. Enable SQL access in view proprieties of the dimension cal. View. Obtain generated node names in shared hierarchies.

Which of the following column types can you assign to rank column. 2 correct answers. 1. Calculated column. 2. Attribute. 2. Measure. 4. Restricted Column.

Which of the following allows data replications. SAP HANA SDQ. SAP HANA SDI. SAP HANA SDA. SAP HANA Streaming Analytics.

A column in your table will be used for a text search, why do you define a column as a text type instead of string type. To allow processing of multiple lang. To enable the full set up SQL Operations. To enable lower memory consumption. To enable linguistic analysis.

What is the purpose of active/active-read enabled mode. To utilize dyn. Tiring for right intensive tasks. . To utilize dyn. Tiring for read intensive tasks. . To use for not continuous back up , to assist in read intensive in task. . To use you're not continuous back up, to assist in write intensive task .

What could you do to improve the performance of join in cube cal. Views. 2 correct ans. Always flag joins as dyn. Use left outer joins instead of right otter joins. Use temporal joins instead of full outer joins. Specify the cardinality of the join.

How do you define a dynamic SQL analytic privilege. Create a procedure that returns a table type parameter. Create a procedure that returns on SQL expression similar to Where clause in a select statement. Include a table function in the sQL expression of the analytic privilege. Create a scalar function that returns a list of the allowed values for each secured.

You joined two tables using a referential join and set the cardinality to 1..n. what type of join is execute at run time, If your query does not request columns from the right table. Inner join. Right outer join. Full outer join. Left outer join.

Why might you use SAP HANA Graph with text analysis?. To uncover the dependencies between parts of sèech. To highlight similarities between documents using hierarchies. To illustrate multi-point relationships between text entities. To provide a visual method to build a custom text analysis.

You join two tables using a referential join and set the cardinality to 1..n What type of join is executed at runtime if your query does NOT request columns from the right table?. Left outer join. Right outer join. Full outer join. Inner join.

In SAP HANA Series Data processing, what is the definition of a profile?. The granularity of time intervals, such as day, hour, or minute. he values that you are storing, such as temperature, energy consumption, or speed. The object you collect data agained, such as house, building, or town. A variant of the data set, such as actual, forecast, or long-term plan.

When modeling a decision tree, what are the stages of the learning phase? 3 correctas. Connecting. Training. Validation. Testing. Rejecting.

In a calculation view, what is the purpose of a variable?. To pass values between procedures and calculation views. To provide a run-time attribute filter based on a user input. To break up complex SQL into smaller steps. To capture the interim result of a calculation in an expression.

A partitioned column table is prevent only in the persistent layer of an SAP HANA system. Which columns and partitions are loaded into memory when the table is accessed by an application?. ONLY the required columns and the required partitions. ONLY the required partitions and all the columns. All the partitions but ONLY the required columns.

What are the components of a graph workspace? 2 correctas. Space. Edge. Vertex. Partition.

You want to join 2 tables in a calculation view When would you use non-equi join?. The join is part of start join. The cardinality is 1:n. The cardinality is impossible to determine. The join requires a < (less than) operator.

What does SQL script provide to extend standard SQL? 2 correctas. Feature to encourage processing in the database. Integrated source code version management. Additional data types for the definition of text and spatial data. Support for ABAP Syntax.

Your calculation view presents employee names which must only be seen by managers. All other employees should see the employee name in the format M### G### Which steps are required to implement this? 2 correctas. Create an SQL expression to define the concealing logic for the column. Set the column to ‘hidden’ in the calculation view. Assign the UNMASK privilege to the managers for the calculation view. Include an anonymization node in the calculation view.

In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?. Container. Function. Procedure. Task.

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 Keep Flag property for both SHIRT_ID and PROMO_LEVEL. Set the Transparent Filter property for STATE. Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL. Set STATE as an aggregated column.

Which of the following must you consider when you define namespaces in an SAP HANA database (HDB) module? There are 3 correct answers to this question. The namespace defined in a design-time object must match the namespace properties of the folder in which it is located. Modeling content should be created before the namespace rules have been defined. Synonyms can have different namespaces. A namespace is a mandatory component of the object identifier. Two different objects can have the same name if they are assigned to different namespaces.

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterwards, you perform the following build operations. - Build the dimension calculation view as a single object - Build the entire SAP HANA database module. What is the outcome of the build operations?. The first build is successful The second build is successful. The first build is successful. The second build fails. The first build fails The second build fails. The first build fails The second build is successful.

What do SAP S/4HANA embedded analytics and SAP HANA live have in common? Note: these are 3 correct answers to this question. They are built using ABAP CDS. They expose operational data from SAP services. Their data access is controlled using analytic privileges. They are built and maintained by SAP. They can be extended by customers.

Which type of join supports a temporal condition in a calculation view?. Referential join. Text join. Left outer join. Inner join.

A calculation view includes a rank node that users the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?. 8 rows. 6 rows. 2 rows. 9 rows.

What can you determine using the hierarchy function in a calculation view? 3 correctas. Source attributes of a composite hierarchy node. Number of siblings for a hierarchy node. Distance between root and each hierarchy node. Hierarchy nodes that have no parent. Time interval of hierarchy nodes.

Your calculation view includes the followings: SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY * PRICE. In which node do you define the calculation to display the correct aggregated result?. Union. Aggregation. Projection. Join.

You created a table using the SQL console inside the HANA Deployment Infrastructure (HDI) container of your project. You export your project and re-import it whit a different project name to the same database What do you observe in the SAP HANA database module?. The build is successful and the table and its data are present. The build is successful but the table is NOT present. The build fails and the table is NOT present.

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?. Where used. Show lineage. Impact analysis. Database explorer.

How can you define a variable that presents its value help hierarchically? 2 correctas. Create a parent-child hierarchy and assign it to the variable Ensure the variables reference column is the parent attribute of the hierarch. Create a level hierarchy and assign it to the variable Ensure the variables reference column is the leaf level of the hierarchy. Create a parent-child hierarchy and assign it to the variable Ensure the variables reference column is the child attribute of the hierarchy. Create a level hierarchy and assign it to the variable Ensure the variables references column is the top level of the hierarchy.

In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?. - CDS view. Table function. Procedure. Scalar function.

Why do you build a calculation view of type DEFAULT?. To provide a leaner model when only attributes are required. 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.

You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the users? There are 2 correct answers to this question. -. User 2 can view United States for 2017. User 1 can view any year for United States. User 1 can view Canada for 2018. User 2 can view any year for United States.

Why might you use the keep flag in an aggregation node?. To ensure that the aggregation behavior delined in the aggregation node for a measure CANNOT be overridden by a query. To include columns that are NOT requested by a query but are essential for the correct result. To retain the results of the aggregation node for reuse in a drill-down based on a hierarchy.

Which of the following techniques can you use to improve the performance of calculation views? Note: these are 2 correct answers to this question. Partition large tables. Implement union pruning. Avoid aggregating data early in the data flow. Minimize layering of calculation view.

You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this?. Your source calculation view is of the type DEFAULT. You did not push the Auto Map button. You already mapped the input parameters in another calculation view. You selected the wrong parameter mapping TYPE.

What does a graph neighborhood reveal? Please choose the correct answer. Vertices that are closely connected. Shortest path between vertices. Vertices that contain the same attributes. Strongly connected Vertices.

In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully? 2 correctas -. Ensure that you have only one HDB module in your project. Assign the project to a space to which you have developer authorizations. Explicitly build the HDB module instead of the project. Ensure that the name of your HDB module is included in the corresponding schema name.

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 projection node. What might the effects of this be? 2 correctas: Increased performance. A change to the data that is returned by the view. The view will return the profit calculation for only the US. Decreased performance.

What restrictions apply to a Graph mode that you include in a calculation view?. It must be the first mode in the data flow. Its data source must be provided by a projection mode. It must be the final mode in the data flow. It cannot be included in a calculation view of type dimension.

Why do you create a multistore table?. To have the option to partition table across different storage tiers. To improve read performance when accessed by simultaneous application. To have a table than combines the characteristics of row and column stores -. To evently distribute the data across all available server nodes.

why do you create calculation views of data category DIMENSION with type TIME?. To provide the time intervals required by time-dependent parent-child hierarchies. To apply automatic adjustments 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.

Why do you use SAP HANA Graph?. To develop a dashboard to present KPIs. To access advanced chart types from calculation views. To push down graphic processing to the database. To model highly networked entities.

Why do you use a hierarchy function node in a calculation view -. To convert parent-child hierarchies to level hierarchies. To generate additional meta data that can be used for analysis of a hierarchy structure. To enable hierarchical navigation in reporting tools. To display value help using hierarchies.

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join you did not set cardinality of the data sources. Why will this NOT work?. Full outer joins CANNOT be mixed on the same star join node with other join types. Full outer joins require to be set. Full outer joins restricted to one dimension in a star join node. Full outer joins are NOT available in the star join node.

How could you improve the performance of joins in cube calculation views? Note: these are 2 correct answers to this question. - Avoid the use of referential joins. -. Reduce the number of columns used in the join. Specify the cardinally of the join. Join on calculated columns. Avoid the use of referential joins.

When you create a full text index, why do you specify FAST_PREPROCESS OFF?. To generate text analysis results in multiple languages. To avoid the generation of the term document matrix. To enable a full linguistic search. To prevent the creation of a fluzzy search index.

Refering to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation View?. A SELECT privilege on the CUBE and an analytic Privilege (Country = United States) on the DIMENSION Calculation View. Analytic Privileges and SELECT Privileges on the CUBE Calculation View. SELECT Privileges and Analytics Privileges on both views. A SELECT Privilege and an Analytic Privileges.

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?. To improve the performance of calculation view A by only referencing the semantics of calculation view B and not duplicating it. To automatically map the input parameters from calculation view B to an input parameter of calculation view A. To apply the semantics of calculation view B to the semantics of calculation view A. To set the semantics of calculation view A to the default values.

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 the effects of this action? 3 correctas -. Additional memory will be consumed by the calculation view. CPU usage for the calculation view will be reduced. Updating of the underlying tables in the calculation view will be delayed for 120 minutes. Users may no longer see the most current data in the output. Variables can no longer be used by this calculation view.

In text processing, where do you use the Term Document Matrix?. Text mining. Fact and entity extraction. Linguistic extraction. Fuzzy text search.

You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data… Which of the following items must you build? 2 correct answers to this question. Authorization. HDB module. Synonym. Project.

In an XSA / HDI environment, where do you find run-time object?. Database user schema. Repository package. Container schema. _SYS_BIC schema.

You are assigned a role that contains two SQL analytic privilege. --> AP_COUNTRY_US restricts the country attribute to US, --> AP_YEAR_2015 restricts the year attributes to 2015. both analytic privilege are assigned to a calculation view that is set to check the SQL analytic privilege. Which data is displayed when you query the cal. View using SAP analytics. The rows for which country = US and year = 2015. The rows for which country = US or Year = 2015. None of the rows of the cal. View. All the rows of the cal. View.

55. What are the elements of custom text analysis. 1. Term document matrix. 2. Configuration. 3. Python script. 4. Dictionary. 5. Rule set.

49. In which parts of a SELECT statement can you include ST_WITHIN spatial predicate. 2 correct ans. 1. Join condition. 2. Group by clause. 3. Where clause. 4. Having clause.

48. You cannot enable a hierarchy for time dependency, what could be the reason for this. 1. You created a parent child hierarchy. 2. You defined the temporal condition on an integer data type column. 3. You created a level hierarchy. 4. You did not include a hierarchy column table.

46. To which category of analysis functions K-Means belong. 1. Clustering. 2. Association. 3. Regression. 4. Classification.

45. Why do you use the performance analysis mode to analyze the Join node. 2 correct ans. 1. To display the pruning rules. 2. To identify the execution engines. 3. To find the number of records in each join pair. 4. To confirm the cardinality setting.

44. You created a table using the SQL console inside the Hana deployment infrastructure HDB container of your project. …. 1. You observe in the SAP Hana database module. 2. Child fails the table is not present. 3. Child is success but table is not present. 4. Child is successful and the table and its data present.

43. Which of the following are tasks that you must perform, before you can build predictive analytics. 3 correct answers. 1. Create a DB connection. 2. Assign authorisation. 3. Define a namespace. 4. Install AFL. 5. Start the script server.

42. In calculation view which object type do you assign to a projection node to consume a…. 1. Scalar functions. 2. Synonym. 3. Input parameter. 4. Table function.

39. You are working on dynamic currency conversion, you pass the target currency at run time using input parameter. What data type does SAP recommend for the input parameter to ensure the consistency with TCUR* table data types. 1. NVARCHAR(3). 2. LCHAR(5). 3. CHAR(5). 4. VARCHAR(5).

38. Which of the following SAP Hana modeling principle does sAP recommend. 3 correct ans. 1. Join tables on key or indexed columns. 2. Define filters on calculated columns. 3. Implement input parameter to push down filter. 4. Reduce data transfer between views. 5. Perform the aggregation after calculation.

34. In SAP WEB IDE for SAP Hana you created an SQL analytic privilege that secures your cal. View. What could be reason. 1. The data category property of the cal. View was not set correctly. 2. You did not assign the analytic privilege to a role. 3. Calculation views cannot be assigned to analytic privileges. 4. The apply privileges property of the cal. View was not defined correctly.

24. Which of the following approaches can be used to implement union pruning. 2 correct ans. 1. Define union pruning condition in pruning configuration table. 2. Define the cardinality between the data sources. (this should not be the answer). 3. Define the constant value for each data source in the union node. 4. Define a restricted column and include it in both data sources of a union.

23. When using the contains predicate which of the following must… 3 correct ans. 1. The NOT(.)Operate can only be specified directly after the OR operate. 2. Wildcard!? Are supported for text columns but not string columns. 3. Nonphysical columns such as calculated Column search. 4. If you specify multiple contains predicates in the where clause of the select statement…. 5. Several tables are joined are column mentioned in the contains predicate must have ….

22. One SQL analytic privilege authorize you to view data for Europe and USA in the sales cal. View … view the income view uses the sales view as input both the calculation view and SQL .. Privileges. What data can you visualize when consuming income cal. View. 1. Data from Europe Asia and USA. 2. Data from Europe and US. 3. Data from US. 4. Data from Asia and US.

21. An SAP Hana live model is displayed as in invalid view in the model in the SAP Hana live processor. What could be the reason. 2 correct ans. 1. The models underlying table is not fully replicated. 2. The model has been deleted. 3. The model Is missing an underlying table. 4. The model Is missing dependent view.

19. What is the propose of active/active-read enabled mode. 1. To utilize dyn. Tiring for right intensive tasks. 2. To utilize dyn. Tiring for read intensive tasks. 3. To use for not continuous back up , to assist in read intensive in task. 4. To use you're not continuous back up, to assist in write intensive task .

14. In a calcu. View what can you only do after you enable hierarchies for SQL access, 2 correct answers. 1. Consume the hier. In BI tools. 2. Use the hier. Mode in a group by clause. 3. Sort the members of hier. 4. Filter the results, set based on hier. Node.

Why should you use variables in SQLScript?. To implement flow control logic. To support processing push-down. To increase parallelization opportunities. To improve code readability.

Why would you implement the SAP HANA Data Warehousing Foundation?. To add OLAP data warehousing capabilities to SAP HANA. To implement a SQL-driven approach to data warehousing. To improve the loading and reporting performance of SAP Business Warehouse. To enable reporting on SAP HANA data using the full suite of SAP BusinessObjects.

Which table partitioning types does SAP HANA support?. Hash. Composite. Round-robin. Cluster. Range.

What are the rules for defining a stepparent in a hierarchy?. A stepparent only applies to parent-child hierarchies. 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. The stepparent node must already exist in the hierarchy at the root level.

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

You imported the following objects. Which of them always require an activity from you before they can be built?. Synonyms definition. Multi-target application. Logical schema definition. SAP HANA database module.

Why might you want to reference a user-provided service in a project?. To access data from another container. To access data from a classic database schema. To access data from your project container.

Which of the following are characteristics of SAP HANA Smart Data Streaming?. It uses databases queries. It is a standalone product for use with any target system. It acts based on combinations of events. It provides reports and analysis on the received data.

Why do you create a time dimension calculation view?. To support temporal joins in a cube calculation view with star schema. To enhance a calculation view with a drilldown on a time hierarchy. To provide date-based help values for a DIRECT type input parameter. To enable time dependency on parent-child hierarchies.

What is included with the Predictive Analysis Library (PAL)?. Data preparation functions. Text mining functions. Predictive algorithms. Flowgraphs.

Which recent trends have triggered the need for a next generation data processing platform?. Increase in connectivity of people and devices. Separation of transactional processing and analysis processing to dedicated servers. Increase in use of mobile devices. Massive growth in data volume.

Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?. Faster disk access. Multi-core processing. Larger memory availability.

What are key features of SAP HANA. Fully in-memory database. Automatic compression of data. Cache not needed.

Why might customers choose to implement SAP HANA as a Service (HaaS)?. They prefer a simpler version of SAP HANA. Reduce administration effort on customer side. Pay per usage. Change size as needed. They prefer to re-use their own hardware components.

What is meant by SAP HANA ‘Tailored Data Centre Integration’?. Customer creates a customized hardware platform on which to install SAP HANA, by reusing existing and SAP certified hardware components. Partners provide cloud infrastructure on which SAP HANA can be installed. Partners provide a fully installed SAP HANA on certified hardware for use onpremise.

Which is a valid tool for extracting, transforming and loading data to SAP HANA, and is built in to the SAP HANA platform?. Smart Data Integration (SDI). SAP Data Services. SAP Landscape Transformation Replication Server (SLT).

What is used to deliver the different levels of capabilities of SAP HANA 2.0?. Editions. Support Pack Stacks (SPS). Options.

SAP Enterprise Architecture Designer is used to generate complete SAP HANA based applications. True. False.

What are the two main views in the Web IDE for SAP HANA?. Database Explorer. Development. Catalog.

What is a role of the SAP HANA Cockpit?. To provide KPIs to help focus on business performance. To provide key system performance information. To provide an application developer collaboration hub.

What are advantages of column store tables versus row store tables?. Data footprint is automatically reduced through compression. Only the columns required for processing are actually loaded to memory. Columns can be partitioned to improve performance. They are optimized for fast writes and updates to records.

Why do we still need a disk layer when SAP HANA is referred to as an in-memory database?. To store data that has been unloaded from memory when memory becomes full. To hold the delta store for newly-arrived records. To enable full database recovery in the event of a power failure. To store data that is frequently used.

What is a multistore table?. A table that can hold data in row and column orientation. A table that can distribute its partitions across memory and extended storage tiers. A table that can be shared across multiple instances of HANA.

Active/active-read enabled mode allows applications to redirect read-intense workloads to a secondary redundant read-only HANA node?. True. False.

What are scale-out scenarios with SAP HANA?. Provision of extra redundant standby servers to be switched to in case of hardware failure. Access to remote servers to store archived data that is rarely used. Deployment of low-cost generic servers to support high volume data streaming applications. Use of multiple servers to spread data storage and processing in order to improve performance.

What is the role of core modeling in SAP HANA?. To push data-intensive processing away from the application and to the database. To develop re-useable data processing logic in the database. To simplify application code.

What are valid types of calculation view?. Dimension. Cube. Cube with star schema. Dimension with star schema.

If I need to create multiple output data sets using SQL Script. Which HANA object do I use?. Procedure. Function.

What do we implement to restrict access to specific data rows of a calculation view?. SQL Permission. Authorization Object. Analytic Privilege.

Which SAP application is compatible with SAP HANA Live?. SAP S/4HANA. SAP Business Suite. SAP Ariba.

Which of these is used to build the virtual data model layer for SAP S/4HANA?. ABAP CDS. SAP HANA Live. Universe. SAP HANA CDS.

In SAP HANA Text Analysis, why would you use the Voice of Customer dictionary?. To extract the sentiment from customer feedback on social media. To extract common entities such as company, country, currencies, and so on, found in documents. To identify close matches in words and expressions, to catch misspellings.

Why would an organization implement SAP HANA Spatial?. To enrich core ERP data with geographic insight. To identify unhappy customers who need a response. To determine how closely related two customers are.

Which of these provide the algorithms that can be used with SAP HANA predictive analysis?. EML. APL. PAL. SDA.

SAP HANA Graph Processing powers real-time, high-performance business charts, and dashboards. True. False.

In SAP HANA, cold data is stored in HANA Extended Storage. True. False.

What are typical characteristics of SAP HANA data replication?. Virtualization. Duplicate data. Real-time. Continual streaming. Significant transformations.

SAP SLT can be used for real-time replication from SAP and also non-SAP sources. True. False.

What are features of SDA?. Automatic data type translation. Data cleansing. Evaluation and execution of push-down possibilities to remote sources. Merging data from multiple sources.

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?. The new table always has a 1:1 mapping between the file and table columns. The supported file types for upload are .csv, and .txt. 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.

What are features of SAP Business Suite powered by SAP HANA?. Includes Embedded Analytics. ABAP is replaced with JAVA. Combine operational analytics and transaction processing. Performance improvement.

What are features of SAP S/4HANA?. Optimized for SAP HANA but maintains compatibility with other databases. Embedded Analytics. Rewritten ABAP code optimized for SAP HANA. SAP HANA Live included to provide real time operational analytics.

What are key capabilities of SAP HANA Analytics Cloud (SAC)?. Landscape monitoring. Predictive. Business Intelligence. Planning.

Which of the following does SAP HANA use to connect to reporting tools?. IDOC. ODBC. JDBC. ODBO.

In which key areas can we expect improvements when running SAP BW powered by SAP HANA?. Tighter security. Data loading performance. Superior data quality. Reporting performance.

Why do I install SAP HANA Data Warehousing Foundation add-on?. To enhance the performance of SAP BW powered by SAP HANA. To provide the essential components needed to develop an SQL-driven custom data warehouse. To move my SAP BW/4HANA on-premise solution to the cloud.

Which interface client is used for XSA application development?. SAP HANA Web-based Workbench. SAP Web IDE for SAP HANA. SAP HANA Studio. SAP Web IDE.

Applications developed with XS classic must be migrated to XSA before they can run in SAP HANA 2.0. True. False.

What does XSA based application development use for source code management?. HDI. Node.JS. Git. Cloud Foundry.

Which of the following are types of calculation views?. Cube. Composite. Cube with star join. Dimension.

A dimension can have attributes and measures. True. False.

Which are true statements relating to calculation views of the type DEFAULT?. They do not expose their meta data to reporting tools. They are mainly used for reusing inside other calculation views. They must include at least one measure. They include a star join node.

Which are supported data source types for calculation view consumption?. Calculation views. Flat files. Virtual tables. Column tables. Row tables.

What is a time-based dimension calculation view?. A view that is only accessible by users for a limited time. A view that stores the values of attributes across time.

What does SAP recommend you use to check your calculation view produces correct result?. Excel pivot tables. Custom SQL queries. Data preview function in Web IDE.

In a calculation view semantic node, which are valid column types?. Measure. Attribute. Dimension. Cube.

Why do you hide columns in a dimension calculation view?. When you want to hide a column that is not required or allowed for client consumption. When you do not want to expose a sensitive column to a consuming calculation view. To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.

What is the purpose of the projection node?. To apply filters on the data. To extract only the required columns from a data source. To aggregate measures. To join data sources.

Why do you use a referential join?. To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query. When you need to display only facts that have associated master data attributes. When you want to display facts even when the associated master data attributes are missing.

A text join is a right outer join used to join a text table containing multi-language descriptions, to an attribute in a dimension. True. False.

Identify the type of join that ensures records are only selected if they fit a specified data range. Left Outer Join. Right Outer Join. Temporal Join. Full Outer Join.

In a union, you do not have to select all source columns and the source columns do not have to have the same name. True. False.

I have customers who appear in table A and sometimes they also appear in table B. I want to select the customers that appear ONLY in table A. Which node type do you use?. Intersect. Minus. Union.

In an aggregation node, a calculated column is always computed before the aggregate function. True. False.

Which flags are relevant to the control of the aggregation behavior?. Keep Flag. Transparent filter. Dynamic join. d.

In a star join node, what do you join to the central entity (fact table)?. Cube calculation views. Column tables. Dimensions calculation views.

In a rank node, you can choose whether to assign the generated rank column as an attribute or a measure. True. False.

A restricted columns provide a subset of the original column filtered by attribute values.. True. False.

When is the design time filter expression applied in a calculation view?. Before a query on the calculation view begin to execute. On the final result of a query, similar to a ‘where’ clause. Before any joins are executed within the calculation view.

When the Default Client property of a calculation view is set to Session Client, the data is filtered dynamically based on the CLIENT assigned to the user. True. False.

Identify the object that adds a WHERE clause to the query. Modeler. Attributes. Input parameter. Variable.

In a calculated column which do you use as a placeholder for a dynamic value in an expression?. Variable. Input parameter.

What are the features of a parent-child hierarchy?. A parent can be formed by combining attributes. Parent and child columns have the same data type. Recursive data structure defines the hierarchy. The hierarchy always generates two levels.

A hierarchy navigation function must be preceded by a hierarchy generator function inside a calculation view. True. False.

While converting currencies, in addition to source and target currencies, which value is also needed?. Time. Country. VAT rate.

When might you use SAP HANA Studio. To migrate deprecated object types to the supported types. To access the latest features of calculation view modeling. To maintain attribute and analytic views. To work with a tool you are familiar with when modeling XSA based development objects.

Why is knowledge of SQL important to an SAP HANA modeler?. So that they can avoid creating calculation views and use SQL. So that they can understand how to implement a function or procedure. So that they can extend the capabilities of a calculation view using SQL expressions.

You are using the SQL console of the We IDE for SAP HANA Database Explorer. When are schema references not required in your code?. When writing SQL against a database connection of the type HDI Container. When writing SQL against a database connection of the type SAP HANA Database.

What types of user defined function can you include in a calculation view?. Table. Column. Scalar.

When would you use an SQL function. As a replacement for a graphical calculation view when you need more flexibility. When you need to write results back to a table. When you need to define custom data processing logic that the graphical calculation view cannot provide.

How should you create a procedure?. Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure. Use the CREATE PROCEDURE statement in SQL Console.

Procedures can be used in the FROM clause of a SELECT statement. True. False.

Why should I define my SAP HANA tables using CDS and not SQL ‘Create table’ syntax?. The syntax is much simpler than the standard SQL Create Table expression. table that is created with CDS performs better than one created with the standard SQL ‘Create Table’ expression. The table definition is easily transported as part of the overall application to ensure all artifacts are kept together.

The relational model of SAP HANA Live is built using which type of views?. Calculation views of data category cube without star join. Calculation views of data category cube with star join. Calculation views of data category ‘blank’. Calculation views of data category dimension.

Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?. It provides a quick start to use SAP HANA Live for customers using SAP Business Suite on non-SAP HANA databases. There is no requirement to copy data from SAP Business Suite to SAP HANA. It offers a simplified landscape where SAP Business Suite and SAP HANA Live share the same in-memory tables.

Which version of CDS is used by SAP S/4HANA embedded analytics?. ABAP CDS. SAP HANA CDS.

What are two reasons why SAP recommends developing data models using calculation views versus CDS?. More use cases are available with calculation views than CDS. Not all features and settings relevant to BI are available with CDS. More optimization possibilities are available with calculation views. Calculation views can define the persistence layer as well as data modeling layer.

To work with calculation view debug query, you first need to build the calculation view?. True. False.

What is the purpose of the SQL Analyzer?. To identify the longest running SQL statements. To investigate the generated SQL for each node in my calculation view. To highlight syntax errors in my SQL code.

Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance. True. False.

Where do I define a pruning configuration table?. Join nodes. Union nodes. Projection nodes.

Which database artifact do you use to access external data from an XS Advanced project?. Calculation view. Synonym. Logical schema. User-provided service.

The Git architecture relies on a central server that stores a unique version of your source code and includes a check-out process that prevents several users from modifying the same source file at the same time. True. False.

Which phase of a project does SAP Enterprise Architecture Designer support?. Development. Design. Planning. Running.

SAP Enterprise Architecture Designer can be used as an alternative to develop calculation views in SAP Web IDE. True. False.

What is a dynamic analytic privilege?. A reusable analytic privilege that can be used for several users who need to access different data. An analytic privilege that takes its filter values from variables defined in the calculation view. A temporary analytic privilege that has a defined time validity set for its use.

What is data masking?. Obscuring column values by hiding some or all characters with replacement characters. Replacing column values with a higher level group such as replacing a person id with team name. Removing complete rows of data that should not be seen by users.

Why do you implement data anonymization?. To hide sensitive data using alternative characters such as ‘XXXXX’. To hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed. To remove complete records so that they cannot be seen by unauthorized users.

Which of the following core SAP HANA modeling topics should a modeler be competent in before working with advanced modeling topics?. HTML. SQL Script. Calculation views. Functions. Procedures.

Why should a modeler develop skills in spatial, text, graph, series and predictive analysis topics?. To extend core data models with additional processing and analysis capabilities. To ensure they understand how to optimize the performance of calculation views. To combine new types of data with traditional business data. To broaden their skills set outside SAP HANA.

In which of the following objects can you call a PAL function directly?. A flowgraph. An HDB AFLLANG procedure. A calculation view. A catalog SQLScript procedure.

Which of the following are basic nodes found in a PAL flowgraph?. Data target. Data store. Data source. Data transformation.

Which of the following node types can be used in a calculation view to reach a PAL function?. Semantic. Projection. Table Function. Star Join.

Prior to SAP HANA 2.0 SPS 02, which of the following did you need to call a PAL function?. Container. Wrapper. Folder. Package.

A decision tree is an example of an algorithm that requires a training phase. True. False.

Which of the following are common spatial geometries used in spatial analysis?. Line string. Vector. Polygon. Points.

A geometry of type ST_GeometryCollection can only contain an ST_MultiPoint, an ST_MultiLineString or an ST_MultiPolygon. True. False.

Regardless of the different geometry types, SAP HANA provides two spatial data types in column tables: ST_POINT and ST_GEOMETRY. True. False.

Which of the following constructors can you use to create a polygon?. ST_MultiPolygon. ST_MultiPoint. ST_GeomFromText. ST_GeomFromMultiPoint.

Which of the following are types of Spatial Reference Systems that can be defined in SAP HANA?. Round-Earth. WGS84. Planar. Web Mercator.

After creating a table with a spatial column and inserting records, you can change the SRID (Spatial Reference System Identifier) of the spatial column. True. False.

How can you import an ESRI shapefile into the SAP HANA Database?. Using an SQL statement refering to the shapefiles located on the server. Using an SQL statement refering to the shapefiles located on the client. Using the GUI in SAP HANA Studio to access shapefiles located on the server. Using the GUI in SAP HANA Studio to access shapefiles located on the client.

Which of the following features of graphical Calculation Views modeling support operations on spatial data columns?. Calculated Columns. Filter Expressions. Joins.

Which of the following are the key elements of a workspace?. Vertex. Edge. Vector. Partition.

Why do you use the Graph Viewer?. To browse available chart types. To display and interact with workspaces. To navigate through spatial data.

Which of the following are graph algorithms that can be called using a Graph node in a calculation view?. Strongly Connected Components. Shortest Path. Distant Relatives.

Why do you use GraphScript?. To develop custom algorithms for graph analysis. To define complex patterns for the pattern matching algorithm. To automate the maintenance of graph workspaces when new attributes are needed.

You want to enable full text search on a VARCHAR column. Which of the following statement is correct?. The full text index is created automatically. The full text index is created manually. The full text index is not required.

In SQL, what must you use to define an EXACT text search?. WHERE. CONTAINS. LIKE.

Which of the following is a linguistic search?. A fault tolerant search. An exact search with wildcard characters. A search based on word stems. A search across multiple languages.

Which of the following defines a fuzzy threshold?. The maximum wait time before the search should return results. A filter that allows you to define how closely the matches should be to be included in the results. The column in the results of a search that indicates the closeness of the matches.

Why do you implement text analysis?. To search for content in documents. To extract interesting information from documents. To classify documents.

It is possible to add custom columns to the text analysis table $TA_. True. False.

Which of the following are files types in SAP Web IDE that can be used in text analysis configurations?. Configuration. Rule Set. Profile. Dictionary.

Which of the following are use cases for SAP HANA text mining?. Classify articles into a hierarchy. Examine tweets to discover how customers feel about new products. Search for documents that discuss similar topics. Produce a list of documents that closely match a given search term.

SAP HANA series data can disaggregate data from day to hour even if the data is not stored at hour intervals. True. False.