Prep Questions

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

What are the key steps to implement currency conversion in a calculation view?

- Assign semantic type - Enable the measure for conversion - Choose client, source, and target currencies - Choose conversion date and rate type

You have created attribute views and analytic views in the SAP HANA 1.0 XS Classic Environment using SAP HANA Studio. You want to migrate them to the new XS Advanced environment of SAP HANA 2.0 SPS05. What is the sequence of these activities?

- Convert attribute views and analytic views to calculation views - Migrate calculation views using the migration assistant - Import the .zip file into the SAP Web IDE workspace

You want to star schema using calculating view. The measures are based on columns from two transaction tables and dimension calculation views provide the attributes. What is the correct approach?

1. Combine the transaction table using a join node in a calculation view of cube with star join 2. Use a star join node to join the dimensions to the fact table

What do we implement to restrict access to specific data rows of a calculation view? A. Analytic privilege B. Authorization object C. HANA Database Procedure D. SQL permission

A. Analytic privilege

Which of the following tasks are required to get the database objects created in the HDI container? (There are 2 correct answers.) A. Assign the project to a space to which you have developer authorizations. B. Create at least one namespace in the HDB module. C. Explicitly build the HDB module instead of the MTA project. D. Build the MTA project.

A. Assign the project to a space to which you have developer authorizations. C. Explicitly build the HDB module instead of the MTA project.

What conditions must be met to ensure the Dynamic join feature works properly? (There are 2 correct answers.) A. At least one joined column must be specified in the query B. The join must be defined on key columns C. Multiple columns must be defined in the join D. Cardinality must be set

A. At least one joined column must be specified in the query C. Multiple columns must be defined in the join

SAP HANA security services include which of the following? (There are 4 correct answers.) A. Authorization B. Antivirus Protection C. Encryption D. Audit Logging E. Authentication

A. Authorization C. Encryption D. Audit Logging E. Authentication

What are features of SDA? (There are 2 correct answers.) A. Automatic data type translation B. Evaluation and execution of push down possibilities to remote sources C. Data cleansing D. Merging data from multiple sources

A. Automatic data type translation B. Evaluation and execution of push down possibilities to remote sources

What does SAP HANA provide to support native application development? (There are 3 correct answers.) A. Choice of development language B. Tools for code creation and debugging C. Full stack development D. Incident tracking tools E. Tools to support automated regression testing

A. Choice of development language B. Tools for code creation and debugging C. Full stack development

What are valid types of calculation view? (There are 3 correct answers.) A. Cube B. Cube with star schema C. Dimension D. Dimension with star schema

A. Cube B. Cube with star schema C. Dimension

What are the two storage components used to restore the database in case of power failure? (There are 2 correct answers.) A. Data volume B. Memory C. Log area D. Delta store

A. Data volume C. Log area

What are the four SAP HANA platform services? (There are 4 correct answers.) A. Database services B. Processing services C. Security services D. Application services E. Integration services

A. Database services B. Processing services D. Application services E. Integration services

Which technologies does SAP HANA use to load more data into memory? (There are 3 correct answers.) A. Eliminate indices B. Use multistore CPU parallelism C. Use ZIP compression D. Use dictionary compression E. Store data in column tables

A. Eliminate indices D. Use dictionary compression E. Store data in column tables

Which of the following are capabilities of SAP HANA smart data access? (There are 2 correct answers.) A. Exposure of real-time data from remote tables B. Push-down of queries to remote data sources C. Replication of remote data D. Cleansing and harmonization of data from disparate sources

A. Exposure of real-time data from remote tables B. Push-down of queries to remote data sources

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval? A. Horizontal aggregation B. Horizontal disaggregation C. Vertical disaggregation D. Vertical aggregation

A. Horizontal aggregation

Which of the following are no longer required in the architecture of SAP S/4HANA? (There are 2 correct answers.) A. Indexes B. Aggregates C. Column tables D. Synonyms

A. Indexes B. Aggregates

Which of the following is required to use predictive modeling in SAP HANA 2? (There are 2 correct answers.) A. Installation of the Application Function Library B. Installation of the Business Function Library C. Authorizations for calling Predictive Analysis Library procedures D. Deployment of a data provisioning agent

A. Installation of the Application Function Library C. Authorizations for calling Predictive Analysis Library procedures

What are the database query languages used by SAP HANA? (There are 2 correct answers.) A. MDX B. ODBC C. ABAP D. SQL E. JDBC

A. MDX D. SQL

To maintain good read performance in a constantly changing database, which two components are used? (There are 2 correct answers.) A. Main storage B. Memory store C. Column store D. Delta storage

A. Main storage D. Delta storage

For what type of data are SAP HANA calculation views of type dimension used? A. Master data B. Materialized cube data C. Transactional data D. Calculated data

A. Master data

What can you determine using the hierarchy function in a calculation view? (There are 3 correct answers to this question.) A. Number of siblings for a hierarchy node B. Hierarchy nodes that have no parent C. Time interval of hierarchy nodes D. Source attributes of a composite hierarchy node E. Distance between root and each hierarchy node

A. Number of siblings for a hierarchy node D. Source attributes of a composite hierarchy node E. Distance between root and each hierarchy node

What phrase describes the main table area in the delta merge scenario? A. Read-optimized B. Row store C. Unsorted inserts D. Write-optimized

A. Read-optimized

Which of the following data operations can you perform with SDA? (There are 3 correct answers) A. Real-time replication B. Physical data warehouse C. Data federation D. Logical data warehouse

A. Real-time replication C. Data federation D. Logical data warehouse

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

A. Repository of ready-made predictive algorithms C. Repository of ready-made business functions

What development tool is available for creating SAP HANA XSA and HDI information models? A. SAP Web IDE for SAP HANA B. SAP HANA Studio C. Database Explorer D. SAP HANA Web-Based Development Workbench

A. SAP Web IDE for SAP HANA

What can you used to limit the number of records produced by a calculation view? (There are 3 correct answers.) A. SAP client restrictions B. Generated columns C. Domain fix values D. Filter expressions E. Restricted columns

A. SAP client restrictions C. Domain fix values D. Filter expressions

For which data types does SAP HANA automatically create full-text indexes? (There are 3 correct answers.) A. SHORTTEXT B. TEXT C. NVARCHAR D. BINTEXT E. CLOB

A. SHORTTEXT B. TEXT D. BINTEXT

Identify the join that checks the From and To column on the left table. A. Temporal join B. Left outer join C. Full outer join D. Right outer join E. Text join

A. Temporal join

Which text feature do you use to find sentiment in textual data? A. Text analysis B. Text mining C. Full-text index D. Fuzzy text search

A. Text analysis

You define a hierarchy in a calculation view. You went to expose the hierarchy to SQL. Which of the following conditions must be met? (There are 2 correct answers.) A. The hierarchy must be exposed by a calculation view of type CUBE with star join B. The hierarchy must be a local hierarchy C. The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY D. The hierarchy must be a shared hierarchy

A. The hierarchy must be exposed by a calculation view of type CUBE with star join D. The hierarchy must be a shared hierarchy

What is the role of core modeling in SAP HANA? (There are 2 correct answers.) A. To develop reuseable data processing logic in the database B. To push data-intensive processing up to the application to obtain the best performance C. To develop more secure user authentication D. To simplify applications

A. To develop reuseable data processing logic in the database D. To simplify applications

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? A. To enable lower memory consumption B. To enable a linguistic analysis C. To enable the full set of SQL operations D. To allow processing of multiple languages

A. To enable lower memory consumption

Which of the following terms are associated with an operational system? (There are 2 correct answers.) A. Transactional B. OLAP C. OLTP D. Data warehouse

A. Transactional C. OLTP

What performance techniques should you implement to improve join performance? (There are 3 correct answers.) A. Use left outer joins instead of right outer joins. B. Use unions instead of joins for combining large datasets. C. Always specify the cardinality of a join. D. Join as many tables as possible in a star join view's data foundation. E. Always mark joins as dynamic to improve performance.

A. Use left outer joins instead of right outer joins. B. Use unions instead of joins for combining large datasets. C. Always specify the cardinality of a join.

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? A. You CANNOT update records using a table function B. You did NOT define a valid table type C. You do NOT create synonyms for the tables D. You do NOT have write permissions to the personnel table

A. You CANNOT update records using a table function

What do you create to find the number of unique items sold per shop? A. A calculation view with a counter in a Projection node B. A calculation view with a counter in an Aggregation node C. An analytic view with a calculated column in a Star Join node D. A calculation view with a restricted column in an Aggregation node

B. A calculation view with a counter in an Aggregation node

What is SQLScript? A. A subset of standard SQL that is exposed to HANA database procedures. B. An extension to standard SQL that provides additional expressions, functions, and datatypes. C. A simplified query language aimed at business users that generates SQL. D. A subset of standard SQL that is exposed to HANA modelers.

B. An extension to standard SQL that provides additional expressions, functions, and datatypes.

What do you use to build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars? A. An input parameter from an Aggregation node B. An input parameter from the Semantics node C. A variable from the Semantics node D. A variable from a Projection node

B. An input parameter from the Semantics node

A traditional cube is represented by which SAP HANA view type? A. SQL view B. Calculation view of type cube with star join C. Calculation view of type dimension D. CDS view

B. Calculation view of type cube with star join

What is the function of the Aggregation node in a graphical calculation view? A. Combine the result sets B. Control the aggregation C. Map the sources to the target D. Combine the source target with result sets.

B. Control the aggregation

In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? (There are 2 correct answers.) A. Superior data quality B. Data loading performance C. Tighter security D. Reporting performance

B. Data loading performance D. Reporting performance

What are typical characteristics of SAP HANA data replication? (There are 2 correct answers.) A. Virtualization B. Duplicate data C. Real-time D. Streaming

B. Duplicate data C. Real-time

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources. How do you check if pruning occurs? (There are 2 correct answers.) A. Preview the data results in the calculation view B. Enable Debug Query mode to identify the columns used C. Explore the number of used columns in the Performance Analysis mode D. Use the SQL Analyzer to identify the tables used

B. Enable Debug Query mode to identify the columns used C. Explore the number of used columns in the Performance Analysis mode

Which of the following are features associated with SAP HANA Live? (There are 2 correct answers) A. A new data warehouse B. Hundreds of pre-developed views C. Web-based tools D. Pre-calculated aggregates stored in cubes

B. Hundreds of pre-developed views C. Web-based tools

What are the advantages of columnar storage? (There are 2 answers.) A. Improved data writing performance B. Improved data reading performance C. Improved compression D. Improved performance when all fields are selected

B. Improved data reading performance C. Improved compression

In SAP BW, when we refer to mixed modeling, what do we mean? A. Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views B. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation Views C. Integration of models from BW on non-HANA databases combined with SAP HANA optimized BW models D. Integration of SAP NetWeaver Components into complex SAP HANA BW models

B. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation Views

Which are features of a calculated column? (There are 2 correct answers.) A. It's created in the Semantics node. B. It's a column in the result set. C. Its calculations are persisted. D. It's created in the output area.

B. It's a column in the result set. D. It's created in the output area.

Which of these does SAP HANA use to connect to BI tools? (There are 3 correct answers.) A. IDOC B. JDBC C. ODBO D. ODBC

B. JDBC C. ODBO D. ODBC

Which types of tables require extended storage? A. Row tables B. Multistore tables C. In-memory tables D. Column tables

B. Multistore tables

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 intelligence tools do you use? A. SAP Lumira, discovery edition B. SAP Crystal Reports for Enterprise C. SAP BusinessObjects Web Intelligence D. SAP Lumira, designer edition

B. SAP Crystal Reports for Enterprise

Which are components of SAP HANA Cloud? (There are 3 correct answers) A. SAP Analytics Cloud B. SAP HANA in-memory database C. SAP Data Warehouse Cloud D. Native Storage Extension E. SAP HANA Cloud data lake

B. SAP HANA in-memory database D. Native Storage Extension E. SAP HANA Cloud data lake

With which statement can you call a table function? (There are 2 correct answers.) A. CALL B. SELECT C. EXEC D. INSERT INTO

B. SELECT C. EXEC

What information can you find in the SAP HANA Cockpit? (There are 2 correct answers.) A. List of operators B. SQL Plan Cache C. Trace and log files D. SQL generated in each step

B. SQL Plan Cache C. Trace and log files

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? A. Create a variable on the client column in the properties of the Star join node. Set flexible default values set for each user. B. Set the default client property of the Semantic node to Session Client Set the preferred client in the user settings of SAP HANA. C. Create a Context for each client. Assign the relevant Context to each user. D. Create a Union node with two sources. Filter one source on client 001 and the other source on client 002.

B. Set the default client property of the Semantic node to Session Client Set the preferred client in the user settings of SAP HANA.

When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas? A. Alias B. Synonym C. Virtual Table D. Association

B. Synonym

You have Model B that is based on Model A. You have successfully built both models. You delete Model B. What happens during the build? (There are 2 correct answers.) A. You get a build error when you build Model A B. The build of Model A is successful C. You get an error when you build the entire HDB module D. The build of the entire HDB module is successful E. Model B gets deleted from the HDI container

B. The build of Model A is successful D. The build of the entire HDB module is successful

Which types of calculation views can you create? (There are 2 correct answers.) A. Derived B. Time-based C. Materialized D. Standard

B. Time-based D. Standard

For what tasks would you use the Where-Used feature in SAP HANA? A. To find all places where a developer updated information models B. To find all places where an information model is used C. To find all places where translations exist D. To find all places where an information model has been deployed

B. To find all places where an information model is used

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

B. To find the shortest path between supplier and consumer D. To identify the strongly connected members of a social media group

Why would you implement SAP HANA spatial services? (There are 2 correct answers.) A. To forecast movements of elements B. To identify unions and intersections of elements C. To calculate distances between elements D. To map all possible relationships in a network of elements

B. To identify unions and intersections of elements C. To calculate distances between elements

What node uses a special configuration table to optimize performance? A. Aggregation node B. Union node C. Projection node D. Join node

B. Union node

What does a graph neighborhood reveal? A. Strongly connected Vertices B. Vertices that are closely connected C. Shortest path between vertices D. Vertices that contain the same attributes

B. Vertices that are closely connected

How many processing tiers do you usually find in a native SAP HANA application stack? A. 1 B. 4 C. 2 D. 3

C. 2

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

C. A table that can distribute its partitions across memory and extended storage tiers

What is SAP Enterprise Architecture Designer? A. A tool used to define a data loading job B. A tool used to simulate different HANA hardware configurations C. A tool to support the build of a logical data model D. A tool to support sizing of an SAP HANA solution

C. A tool to support the build of a logical data model

Where in a calculation view can you add a Graph node? A. Only as the top node B. Anywhere from the bottom (leaf) node to the default node C. Always as the bottom (leaf) node

C. Always as the bottom (leaf) node

What can you determine using the hierarchy function in a calculation view? (There are 3 correct answers.) A. Hierarchy nodes that have no parent B. Time interval of hierarchy nodes C. Distance between root and each hierarchy node D. Source attributes of a composite hierarchy node E. Number of siblings for a hierarchy node

C. Distance between root and each hierarchy node D. Source attributes of a composite hierarchy node E. Number of siblings for a hierarchy node

From where does the Extract Semantics feature get the definition of hierarchies? A. From the table data sources B. From the current calculation view C. From the underlying dimension views D. From the SQL view data sources

C. From the underlying dimension views

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? A. Full outer joins are NOT available in the star join node. B. Full outer joins CANNOT be mixed on the same star join node with other join types. C. Full outer joins restricted to one dimension in a star join node. D. Full outer joins require to be set

C. Full outer joins restricted to one dimension in a star join node.

Refactoring is used with which of the following actions? A. Deployment B. Documenting C. Improving your modeling design D. Translating

C. Improving your modeling design

A partitioned column table is present 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? A. All the partitions but ONLY the required columns B. ONLY the required partitions and all the columns C. ONLY the required columns and the required partitions

C. ONLY the required columns and the required partitions

What is the SQL keyword used to process input parameters defined in a calculation view? A. Hint B. Set C. Placeholder D. Where

C. Placeholder

Which business intelligence tool does NOT use BICS connectivity to SAP HANA? (There are 2 correct answers.) A. SAP Lumira, designer edition B. SAP Lumira, discovery edition C. SAP Analysis for Microsoft Office D. Microsoft Excel

C. SAP Analysis for Microsoft Office D. Microsoft Excel

For which deployment scenario does SAP deliver prebuilt data models? A. SAP HANA as a side-by-side accelerator B. SAP HANA on the cloud C. SAP HANA as an SQL Data Warehouse D. SAP HANA as platform

C. SAP HANA as an SQL Data Warehouse

What paradigm describes the SQL language? A. Procedural B. Application-focused C. Set-oriented D. Object-oriented

C. Set-oriented

Why would you use the XS Advanced migration Assistant? (There are 2 correct answers.) A. To convert attribute views to CDS VIEWS B. To move HDI-developed calculation views to repository packages C. TO convert analytic views to calculation views D. To convert studio-developed objects for use with Web IDE FOR SAP HANA

C. TO convert analytic views to calculation views D. To convert studio-developed objects for use with Web IDE FOR SAP HANA

In SAP Web IDE for SAP HANA, you created an SQL analytic privilege that secures your calculation view. You build the analytic privilege, but the build faults. What could be the reason? A. You did NOT assign the analytic privilege to a role B. The Data Category property of your calculation view was NOT set correctly C. The Apply Privileges property of your calculation view was NOT defined correctly D. Calculation views CANNOT be assigned to an analytic privilege

C. The Apply Privileges property of your calculation view was NOT defined correctly

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

C. There is no data movement D. It offers a simplified landscape

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

C. To enable a full linguistic search

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? A. To enable a linguistic analysis B. To allow processing of multiple languages C. To enable lower memory consumption D. To enable the full set of SQL operations

C. To enable lower memory consumption

Why would you implement a hierarchy function node in a calculation view? A. To enable a hierarchical drill-down in reporting tools B. To display value help using hierarchies C. To generate a list of descendants for a hierarchy node D. To assist the developer by visualizing hierarchies

C. To generate a list of descendants for a hierarchy node

In your rank node, why do you set the dynamic partition element flag? A. To determine the ranking threshold value base on an input parameter B. To determine the partitioning logic using an SQL expression C. To generate the ranking partition based on the column selected in the query D. To define time dependency on a partition

C. To generate the ranking partition based on the column selected in the query

When do you use the SQL Analyzer? A. To highlight syntax errors in my SQL code B. To hide the syntax errors in my SQL code C. To identify the longest running SQL statements D. To investigate the generated SQL for each node in my calculation view

C. To identify the longest running SQL statements

Why should you use variables in SQL Script? (There are 2 correct answers.) A. To support processing push-down B. To implement flow control logic C. To improve code readability D. To increase parallelization opportunities

C. To improve code readability D. To increase parallelization opportunities

Why do you build a calculation view of type DEFAULT? A. To ensure all reporting tools can consume the calculation view B. To support optimized multidimensional reporting C. To provide a data source that is only consumed by other calculation views D. To provide a leaner model when only attributes are required

C. To provide a data source that is only consumed by other calculation views

Why would you build a calculation view of type SQL Access Only? A. To enable SQL access to your hierarchies B. To provide a data source that can only be consumed by a function or procedure C. To provide a data source that is only consumed by other calculation views D. To provide a high performance model when only attributes are required

C. To provide a data source that is only consumed by other calculation views

What can you use SAP HANA smart data access for? A. To load harmonize data from disparate sources B. To replicate remote data sources C. To push down queries to data sources D. To expose data from remote tables

C. To push down queries to data sources D. To expose data from remote tables

Why would you implement active/active read-enabled mode? A. To enhance security for data access B. To provide offline access to data C. To synchronize query results with operational data D. To improve query performance

C. To synchronize query results with operational data

What information can you find in Performance Analysis Mode when you view the analysis for a Join node? (There are 2 correct answers.) A. Suggested filter for the tables in the Join node B. Time taken by the join C. Total number of records returned by the node D. Tables used by the join in the node

C. Total number of records returned by the node D. Tables used by the join in the node

What are the components of a graph workspace? (There are 2 correct answers.) A. Space B. Partition C. Vertex D. Edge

C. Vertex D. Edge

Identify the principles that you need to follow during modeling. (There are 2 correct answers.) A. You should push data processing to the client as much as possible. B. You should perform calculations before aggregation. C. You should reduce data transfer between the views by applying filters as low down as possible. D. You should create joins on key columns.

C. You should reduce data transfer between the views by applying filters as low down as possible. D. You should create joins on key columns.

What PAL algorithm would you use to analyze shopping baskets? A. K-means B. Link prediction C. Decision tree D. Apriori

D. Apriori

You're working with a currency measure. What is decimal shift used for? A. To avoid rounding errors during the conversion B. To increase the accuracy of the currency conversion C. To undo the decimal adjustment for ABAP D. For currencies with more than two decimal places

D. For currencies with more than two decimal places

What technique is used to convert record updates into insert statements in the delta buffer? A. Sorted inserts B. Parallelism C. Unsorted inserts D. Insert-only

D. Insert-only

You need to return multiple result sets using SQL Script. What do you use? A. Table function B. Scalar function C. Scripted calculation view D. Procedure

D. Procedure

What do you use in a SQL query to sort fuzzy text search results by relevance? A. RANK() B. TOP C. SORT BY D. SCORE()

D. SCORE()

What should you keep in mind about user-defined functions? A. They can use dynamic SQL. B. They can commit transactions. C. They can call procedures. D. They can use imperative logic.

D. They can use imperative logic.

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

D. To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis

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

D. To generate additional Meta data that can be used for analysis of a hierarchy structure

In which of the following scenarios would you benefit from enabling table portioning in SAP HANA? A. Your stacked model consists of multiple calculation views. B. You have a large row store table that is consumed in view with a variable on COUNTRY column. C. you have a larger column store table that is consumed in a view with a variable on COUNTRY column. D. Your column tables' delta store is frequently larger than its main store.

D. Your column tables' delta store is frequently larger than its main store.


Kaugnay na mga set ng pag-aaral

4: exponential and log functions

View Set

Exam Prep Sales Agent Attempt #3 - TREBS 2021

View Set

Chapter 3 Notes Business Essentials

View Set

Enzymes and Biochemical Reactions

View Set

Placement Grammar practice (British)

View Set

FINC Sirmans Final Quizzes and Menti Questions

View Set

psychiatric disorders in childhood & adolescence

View Set