Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question. Table function Row table Scalar function Procedure.
In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code? Note: There is 1 correct answer to this question. Scalar function Table function Procedure Anonymous block.
What does SQLScript provide to extend standard SQL? There are 2 correct answers to this question. Features to push processing to the database Support for ABAP syntax Additional data types for the definition of text and spatial data Integrated source code version management.
Which of the following tasks are required to get the database objects created in the HDI container? There are 2 correct answers to this question. Explicitly build the HDB module instead of the MTA project. Build the MTA project. Create at least one namespace in the HDB module. Assign the project to a space to which you have developer authorizations.
Why do you implement column tables instead of row tables? There are 2 correct answers to this question. High performance for transaction processing is required Data is suitable for partitioning Records will be updated frequently Data volumes are large.
In SAP HANA Series Data processing, what is the definition of a profile? Please choose 1 correct answer. The object you collect data against, such as house, building, or town A variant of data set, such as actual, forecast, or long-term plan The values that you are storing, such as temperature, energy consumption, or speed The granularity of time intervals, such as day, hour, or minute.
Why would you use SAP HANA Replication Services? Note: There are 3 correct answers to this question. To replicate data from SAP HANA Cloud to SAP HANA on-premise To replicate data from SAP HANA on-premise to SAP HANA Cloud To replicate data from non-SAP cloud providers to SAP HANA Cloud To replicate users and their privileges from SAP HANA on-premise to SAP HANA Cloud To replicate calculation views from SAP HANA on-premise to SAP HANA Cloud.
On a weekly basis, you need to extract and apply complex transformations on data from three data sources SAP ERP, Microsoft Excel, and Apache Hadoop, and then combine and load the data into an SAP HANA table. Which tools can you use? There are 2 correct answers to this question. SAP Data Services SAP Landscape Transformation Replication Server SAP HANA smart data access SAP HANA smart data integration.
What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question. Aggregates are not adjusted. Read performance decreases. Memory is not optimized. New records are not read.
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 do you use to check where the output columns originate from? Note: There is 1 correct answer to this question. Impact analysis Label column Where used Show lineage.
Why should you define calculated column expressions using plain SQL and avoid using column engine language? Note: There is 1 correct answer to this question. To benefit from additional SQL optimizations To access the full set of SQL functions To allow imperative statements To prevent queries from unfolding.
What is a restricted measure? Note: There is 1 correct answer to this question. A measure that cannot be referenced by a calculated column. A measure that can only be displayed by those with necessary privileges. A measure that is filtered by one or more attribute values. A measure that can be consumed by a CUBE and not a DIMENSION.
Why does SAP issue warnings about the use of imperative or procedural SQLScript statements? Note: There is 1 correct answer to this question. They introduce potential security risks. They call multiple processing engines. They can limit parallelization of query execution. They could modify the database.
Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question. To pass variable values to external value help views To convert the data types of input parameters To assign variables to one or more attributes To push down filters to the lowest level calculation views.
In a calculation view, you use a rank node to identify the purchase orders with the highest total amount. The expected output includes the top orders that represent 15% of the total numbers of orders placed by each customer. How do you set the Aggregation Function and Result Set Type properties of the rank node to get the expected result? Please choose 1 correct answer. Aggregation Function: Sum Result Set Type: Absolute Aggregation Function: Sum Result Set Type: Percentage Aggregation Function: Rank Result Set Type: Absolute Aggregation Function: Row Result Set Type: Percentage.
Why would you implement active / active read-enabled mode? Note: There is 1 correct answer to this question. To improve query performance To enhance security for data access To synchronize query results with operational data To provide offline access to data.
Why would you enable Debug Query mode in a calculation view? Note: There is 1 correct answer to this question. To check which database engines are invoked To understand how tables are partitioned To set breakpoints and step through the execution To identify data sources that are not accessed by a query.
Your flowgraph begins with a row generator node. What does the generated column contains? Note: There is 1 correct answer to this question. The result of an SQL expression A range of dates A sequential row number A constant value.
What can you do with a projection node in your calculation view? Note: There are 3 correct answers to this question. Define a restricted column Define a calculated column Implement an input parameter Join multiple data sources Apply a filter to the data source.
Why do you set a transparent filter in a calculation view? Note: There is 1 correct answer to this question. To remove an unwanted attribute from an aggregation To allow a user to remove a predefined filter To expose the expression used in a filter to a user To include an attribute in an aggregation.
You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this? Note: There is 1 correct answer to this question. The cache data retention period has expired. You did not define any columns in the cache setting. You did not define a filter in the cache setting. The query requests only a subset of the cached results.
What can you discover using Data Lineage? Please choose 1 correct answer. Frequency of load Underlying calculation views and tables Access statistics Data changes since last refresh.
How can you define a variable that displays its value help organized as a hierarchy? There are 2 correct answers to this question. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the leaf level of the hierarchy. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the child attribute of the hierarchy. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the top level of the hierarchy. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the parent attribute of the hierarchy.
Which of the following are types of calculation view? There are 2 correct answers to this question. Virtual Dimension Cube Composite.
You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results? Note: There is 1 correct answer to this question. In the union node, map both source customer name columns to one target column. Define a restricted column in a union node. Include an aggregation node above the union node. Add an intersect node above the union node.
An analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another analytic privilege authorizes you to view data for Asia and the USA in the income calculation view. The income view uses the sales view as a data source. Both calculation views check analytic privileges. What data are you authorized to view when querying the sales calculation view? Note: There is 1 correct answer to this question. Data from the USA Data from Europe, Asia, and the USA Data from Europe and the USA Data from Asia and the USA.
What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question. It is restricted to one DIMENSION in a star join node. It must appear in the last DIMENSION in the star join node. Only one column can be included in the join condition. It CANNOT be mixed in the same star join node with other join types.
Which options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question. Assign them to a level below the root. Define an expression to determine a parent. Generate additional root nodes. Assign them to a node at the root level.
You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR? Note: There is 1 correct answer to this question. Null <empty string> ? 0.
Which of the following approaches can be used to implement union pruning? Note: There are 2 correct answers to this question. Define the cardinality between the data sources. Define union pruning conditions in a pruning configuration table. 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.
What does SAP HANA provide to support full stack native application development? Note: There are 2 correct answers to this question. Incident tracking tools Source code version management tool Code editors and debugger Support for automated regression testing.
Which are the components of SAP HANA Cloud? Note: There are 3 correct answers to this question. SAP Data Warehouse Cloud SAP HANA Cloud data lake Native Storage Extension SAP HANA in-memory database SAP Analytics Cloud.
What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question. Modeler ABAP developer Kubernetes expert Data architect.
In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question. Define constant values. Create and map an input parameter Assign a hierarchy node. Reference the output of a procedure. Map columns from lower nodes.
Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note: There are 2 correct answers to this question. To prevent passing columns in stacked calculation views To remove a column that is also used as a Label column To avoid exposing sensitive columns when defining calculated columns To ensure specific columns are NOT exposed to the reporting tool.
Why might you use the Keep Flag property in an aggregation node? Note: There is 1 correct answer to this question. To include columns that are NOT requested by a query but are essential for the correct result To retain the correct aggregation behavior in stacked views To exclude columns that are NOT requested by a query to avoid incorrect results To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query.
What can you do with shared hierarchies? Note: There are 2 correct answers to this question. Access hierarchies created in external schemas Provide reusable hierarchies for drilldown in a CUBE without star join Enable SQL SELECT statements to access hierarchies Provide reusable hierarchies for drilldown in a CUBE with star join.
What do you use in the definition of a dynamic SQL analytic privilege? Note: There is 1 correct answer to this question. A table function that returns a list of allowed values. An organization hierarchy that provides role-based access to data. A procedure that returns the data access condition as an SQL expression. A scalar function that returns a list of the allowed values for each attribute.
You are managing your source files using Git. In which sequence does your file progress towards a COMMIT? Note: There is 1 correct answer to this question. Staging area -> Working directory -> Local Git repository Working directory -> Staging area -> Local Git repository Local Git repository -> Staging area -> Working directory Working directory -> Local Git repository -> Staging area.
What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question. Only one block can be defined across a stack of calculation views. The block must start with a node that defines a table as a data source. The block must only have one start node. Multiple blocks can only be defined within a single calculation view.
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason? Note: There is 1 correct answer to this question. You did NOT define a valid table type. Your function includes a TRUNCATE statement. You did not define at least one input parameter. Your function refers to a scalar function.
Which of the following supports data replication? Note: There is 1 correct answer to this question. SAP HANA smart data access SAP HANA, streaming analytics option SAP HANA smart data integration SAP HANA smart data quality.
Why would you create a multistore table? Note: There is 1 correct answer to this question. To implement a table that combines the features of row and column store To enable partitioning of the table across different storage tiers To improve read performance when the table is accessed by simultaneous applications To evenly distribute the data across all available server nodes.
You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach? Note: There is 1 correct answer to this question. 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. 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 star join node in a calculation view of type CUBE with star join. Use the same star join node to connect 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.
In a calculation view, what is the purpose of a variable? Note: There is 1 correct answer to this question. To pass values between procedures and calculation views To filter an attribute at run-time based on a user input
Your answer is incorrect To break up complex SQL into smaller steps To provide a dynamic value in a calculated column.
Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question. Fiscal Gregorian Julian Factory.
Why do you create calculation views of data category DIMENSION with type TIME? Note: There is 1 correct answer to this question. To provide the time intervals required by time-dependent parent-child hierarchies. To add a temporal condition to a join to find matching records from two tables based on a date. To provide additional time-related navigation possibilities To store historical versions of attributes.
In an XS Advanced project, what is the purpose of the .hdiconfig file? Note: There is 1 correct answer to this question. To specify the namespace rules applicable to the name of database objects To specify which HDI plug-ins are available To specify in which space the container should be deployed. To specify an external schema in which calculation views will get their data.
When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas? Note: There is 1 correct answer to this question. Alias Virtual Table Association Synonym.
Why would you set the Ignore multiple outputs for filters property in a calculation view? Note: There is 1 correct answer to this question. To ensure semantic correctness To avoid duplicate rows in the output To hide columns that are not required To force filters to apply at the lowest node.
Which type of join supports a temporal condition in a calculation view? Note: There is 1 correct answer to this question. Inner join Referential join Left outer join Text join.
What are some best practices when developing calculation views? Note: There are 2 correct answers to this question. Avoid defining joins on calculated columns. Include all data flow logic within one calculation view. Model star schemas using a sequence of join nodes. Aggregate at the lowest possible node.
Why would you create SQL in calculation views? Note: There is 1 correct answer to this question. To provide an alternative to graphical modeling To fine-tune performance To enable write capabilities To implement custom logic.
You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe in the SAP HANA database container? Note: There is 1 correct answer to this question. The build fails and the table is not dropped. The build fails and the table is dropped. The build is successful and the data preview returns expected data. The build is successful but the data preview returns an error message.
Why would you build a calculation view of type SQL Access only? Note: There is 1 correct answer to this question. To provide a high performance model when only attributes are required To provide a data source that can only be consumed by a function or procedure To provide a data source that is only consumed by other calculation views To enable SQL access to your hierarchies.
Which tool generates and executes the SQL for a specific node of your calculation view? Note: There is 1 correct answer to this question. Explain plan Debug Query mode SQL analyzer Database explorer.
You want to join two tables in a calculation view. Why do you use a non-equi join? Note: There is 1 correct answer to this question. Join columns need to be ignored when NOT requested by the query. The number of joined columns is different in each table. The join condition is not represented by matching values. Join columns have different data types.
What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question. An SQL execution plan Cached results to improve read performance A column view in a container Metadata to enable consumption by external tools.
You deleted the design-time file of a calculation view in your HDB module. What is the recommended way to ensure that the corresponding runtime object is also removed from the database? Note: There is 1 correct answer to this question. Build the folder that contained the deleted design-time file. Execute the refactor function for the calculation view. Build the project that contained the deleted design-time file. Execute a DROP statement in an SQL console connected to the HDI container.
What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question. Assign them to a level below the root. Define an expression to determine a parent. Generate additional root nodes. Assign them to a node at the root level.
You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns. What is the recommended approach for verifying the results? Note: There are 2 correct answers to this question. Set the HIDE property for columns NOT required. Select and deselect columns from the output mapping. Select Data Preview for the calculation view. Write and execute a custom SQL query in the SQL Console.
Why did SAP move from XS to XSA? There are 2 correct answers to this question. To implement micro-services architecture To provide better source code management tools inside SAP HANA To move to Cloud Foundry architecture to allow flexible application deployment options. To include ABAP as a key development language for native SAP HANA applications.
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question. The hierarchy must be a local hierarchy. The hierarchy must be exposed by a calculation view of type CUBE with star join. The hierarchy must be a shared hierarchy. The hierarchy must be a parent-child hierarchy.
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 integration SAP Data Services SAP Landscape Transformation Replication Server SAP HANA smart data access.
How does SAP S/4HANA embedded analytics differ from SAP HANA Live? There are 2 correct answers to this question. It uses SAP HANA calculation views. Authorizations are at the database level. It uses ABAP CDS views. Authorizations are at the application level.
In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations: Deploy the DIMENSION calculation view as a single object. Deploy the entire SAP HANA database module. What is the outcome of the deploy operations? Note: There is 1 correct answer to this question. The first deployment is successful. The second deployment is successful. The first deployment fails. The second deployment fails. The first deployment is successful. The second deployment fails. The first deployment fails. The second deployment is successful.
Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question. Pre-calculated aggregates Indexes Stored procedures Table partitions.
Which SAP solution does SAP HANA Live support? Please choose the correct answer. SAP Ariba SAP BW/4HANA SAP S/4HANA SAP Business Suite.
When do you use the hidden attribute in a dimension calculation view? Please choose the correct answer. When you want to hide the attribute in your cube calculation view. When you need to include the attribute in your calculation view to define a join. When you want to include an attribute that is not required for cube consumption. When you want to hide an attribute that is not required for client consumption.
You have generated a calculation view properties file. What does it contain? Note: There is 1 correct answer to this question. Dependencies between calculation views Documentation to support the calculation view Descriptions of all objects defined in a calculation view All settings defined in a calculation view.
Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question. SAP HANA database SAP Enterprise Architecture Designer Data lake SAP Analytics Cloud.
You create a user-provided service to access tables in external schemas. In which file type do you assign the user-provided service to your database module? Note: There is 1 correct answer to this question. .yaml .mtar .namespace .hdiconfig.
You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue. What could be the reason? Note: There are 2 correct answers to this question. The .hdinamespace specifies sub-folder:append, so calculation views can only be created in subfolders. The imported calculation view and its data source have different namespaces. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.
You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query To ensure that the aggregation always happens after the join execution To allow data analysis at different levels of granularity with the same calculation view To ensure that the join execution only uses the join columns requested in the query.
What are possible consequences of unfolding? Note: There are 2 correct answers to this question. Query processing time improves Results are read from static cache SQL compilation time increases Count-distinct results are incorrect.
What information can you find in Performance Analysis Mode when you view the analysis for a Join node? There are 2 correct answers to this question. Suggested filter for the tables in the Join node Time taken by the join Total number of records returned by the node Tables used by the join in the node.
Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE. In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE. In which type of node do you define the calculation to display the correct result? Note: There is 1 correct answer to this question. Union Projection Join Aggregation.
At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question. Entire workspace Individual container Individual source file Sub-folder of a database module.
Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question. You want to use containers to isolate objects. You want to use synonyms to access external data. You want to create database objects using source files. You want to use SAP Business Application Studio. You want to develop calculation views.
You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL? Note: There is 1 correct answer to this question. To define limits for query unfolding Incorrect aggregations may be generated Column engine language is not supported. To benefit from additional SQL optimizations.
What information can you find in the SAP HANA Cockpit? There are 2 correct answers to this question. Trace and log files List of operators SQL generated in each step SQL Plan Cache.
What are features of SDA? There are 2 correct answers to this question. Merging data from multiple sources Data cleansing Evaluation and execution of push down possibilities to remote sources Automatic data type translation.
You want to use a field in a formula but don't want to expose the values of the original field to the end users. What do you do? Please choose the correct answer. Mark the field as hidden. Make the field a key column. Change the data type of the field. Rename the field.
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question. To convert currencies To generate a restricted column To generate hierarchies To generate a calculated column To define a filter.
What are the features of a parent-child hierarchy? There are 3 correct answers to this question. 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.
In which package in SAP HANA will you find the SAP HANA Live views? Please choose the correct answer. /public /sap/hba /sap/bc /sap/hana/democontent.
In a database module, what is the purpose of the .hdiconfig file? Note: There is 1 correct answer to this question. To specify an external schema in which calculation views will get their data To specify which HDI plug-ins are available To specify in which space the container should be deployed To specify the namespace rules applicable to the name of database objects.
What are the advantages of columnar storage? There are 2 correct answers to this question. Improved compression Improved data reading performance Improved performance when all fields are selected Improved data writing performance.
Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question. Hierarchy function Dynamic Attributes SQL expression Graph.
What are the currency conversion functionalities supported by SAP HANA? There are 3 correct answers to this question. Conversion based on customer-defined tables Determination of target currency based on attributes or input parameters Enabling of decimal shifts Multiple exchange rate types.
Which are views of the SAP supplied virtual data model of Embedded Analytics? There are 2 correct answers to this question. Calculation Basic Composite Attribute.
You want to read a table from an SAP HANA classical schema. What do you need to do to get it working? There are 3 correct answers to this question. Make use of a user-provided service Create a synonym Use an explicit reference to the schema Make use of the built-in HDI service Assign the provided ::access role to your container's technical user.
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 aggregation Vertical aggregation Vertical disaggregation Horizontal disaggregation.
In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system? There are 2 correct answers to this question. SAP HANA Live SAP HANA as a platform SAP BW powered by SAP HANA SAP S/4HANA.
In which programming languages can you create procedures in SAP HANA? There are 2 correct answers to this question. SQLScript L JavaScript R.
You have a view with two tables joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join? Please choose the correct answer. Change the join to a text join. Change the join to a right outer join. Keep the left outer join. Change the join to a referential join.
When creating a system connection in SAP HANA Studio, which of these is essential information? There are 3 correct answers to this question. Host URL A valid user and password Instance.
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 only the dimension calculation view, the build is successful. When you build the HDB module, the build fails. When you build the HDB module, the build is successful.
Identify the principles that you need to follow during modeling. There are 2 correct answers to this question. You should push data processing to the client as much as possible. You should create joins on key columns. You should perform calculations before aggregation. You should reduce data transfer between the views by applying filters as low down as possible.
Using SAP Analysis for Microsoft Office, your calculation view on SAP application data returns data from two clients. In SAP Web IDE, you have identified the column to be used as the client column. Which of the following approaches will return data from only one client? Please choose the correct answer. Create a Context for each client. Assign the relevant Context to each user. Filter one source on client 001 and the other source on client 002. Create a Union node with two sources. Set the default client property of the Semantic node to Session Client Set the preferred client in the user settings of SAP HANA.
What do we implement to restrict access to specific data rows of a calculation view? Please choose the correct answer. HANA Database Authorisation object Procedure SQL permission Analytic privilege.
You're working with a currency measure. What is decimal shift used for? Please choose the correct answer. To undo the decimal adjustment for ABAP To increase the accuracy of the currency conversion To avoid rounding errors during the conversion For currencies with more than two decimal places.
From where does the Extract Semantics feature get the definition of hierarchies? Please choose the correct answer. From the SQL view data sources From the underlying dimension views From the current calculation view From the table data sources.
What is the default node for a calculation view of type cube? Please choose the correct answer. Star join node Join node Aggregation node Projection node.
What is normally used to build SAP HANA XSC applications inside SAP HANA? There are 2 correct answers to this question. JavaScript SAPUI5 ABAP Java.
In which SAP HANA solution do you eliminate stored data, such as year to date figures? Please choose the correct answer. SAP CRM on SAP HANA SAP HANA Enterprise Cloud SAP BW on SAP HANA SAP S/4HANA.
A column in your table will be used for text search. Why do you define the column as a text type instead of a string type? Please choose the correct answer. To enable lower memory consumption To enable the full set of SQL operations To allow processing of multiple languages To enable a linguistic analysis.
While converting currencies, which parameter is as important as source and target currencies? Please choose the correct answer. Location Season Money Time.
Why would you create a procedure? There are 2 correct answers to this question. If you need to define a calculated column expression If you need to insert records into a table If you need to provide a data source to a graphical calculation view If you need a mixture of scalar and tabular output parameters.
Which of the following features of an XS Advanced application are provided by an HDB module? There are 2 correct answers to this question. Virtual data modeling Persistence layer User interface Business logic.
How many processing tiers do you usually find in a native SAP HANA application stack? Please choose the correct answer. 3 4 1 2.
You're creating a currency conversion. What options do you have for the Target Currency field? There are 3 correct answers to this question. Use the Derived from Table option. Select a fixed currency. Select a column. Use an input parameter.
What performance technique should you implement to improve the performance of SAP HANA information views? Please choose the correct answer. Output as many fields as possible. Build single large views. Supply reporting tools with all the data in one transfer. Implement union pruning conditions.
In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? There are 2 correct answers to this question. Task Procedure Container Function.
Where will you find the Data Distribution Optimizer? Please choose the correct answer. SAP S4/HANA Dictionary SAP HANA Studio SAP HANA Data Warehousing foundation SAP BW/4HANA.
You're given an old government paper form with lines, blocks, and fields. You're asked to create a report that looks like this form. Which business intelligence tools do you use? Please choose the correct answer. SAP BusinessObjects Web Intelligence SAP Lumira, designer edition SAP Crystal Reports for Enterprise SAP Lumira, discovery edition.
Why do you build a calculation view of type DEFAULT? Please choose the correct answer. To provide a leaner model when only attributes are required. To provide a data source that is only consumed by other calculation views. To ensure all reporting tools can consume the calculation view. To support optimized multidimensional reporting.
Which views in SAP S/4HANA embedded analytics may you extend? Please choose the correct answer. Consumption views Query views Composite views Interface views.
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##.
What must be installed for PAL to work? Please choose the correct answer. SAP HANA AFM SAP HANA BFL SAP HANA AFL SAP HANA SINA.
|
