Which option do you use if you want to create a brand new project? Clone from Git Import Start from Template.
When you need to collaborate with others on large projects, which is the best option for bringing development content into your workspace? Clone from Git Import Upload from File.
In SAP HANA Cloud, which tool is recommended for data modeling? SAP Business Application Studio Web IDE Database Explorer.
Which extension is essential to include in your development space in order to begin modeling? SAP HANA Calculation View Editor CDS Graphical Editor Flowgraph Editor.
What can you do in the Explorer view of SAP Business Application Studio? There are two correct Manage SAP HANA artifacts deployment. List files and folders Create a project from a template.
Which are benefits of calculation views? there are two correct They adapt automatically to the requesting query They can be defined using any database language They calculate live data on-the-fly.
Which is the default top-view node for a dimension calculation view? Aggregation Projection Star Join.
What is the role of a dimension calculation view? To generate a view of master data from one or more tables To combine dimensions with a cube to form a star schema To aggregate measures by one or more attributes.
Why do you create a time-based dimension calculation view? To define a calculation view that is valid for a specific period of time To generate historical views of master data To automatically generate time-related attributes from a base date.
What is the role of the cube calculation view? To project master data into a harmonized view To aggregate measures without the need for dimensions To develop a star schema for ad-hoc analysis.
What is the name of the tool that is launched with Data Preview of a calculation view? SAP HANA Database Explorer SAP Business Application Studio SAP HANA Cloud Cockpit.
Why do you hide columns in a calculation view? 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. When you want to hide a column that is used in a calculation but is not required to display in a report. When you want to hide some of a calculation view data based on attribute values.
Which of the following are supported data source types for calculation view consumption? there are four correct Row tables Calculation views Virtual tables Flat files Column tables.
What is the purpose of the Projection node? there are two correct To extract only the required columns from a data source To join data sources To apply filters on the data To aggregate measures.
When is the calculated column computed in an aggregation node? After aggregation Before aggregation.
When do you implement a non-equi join? When you want to match on different data types When your data sources are in different source systems When your match is not on an exact value of a column.
What is the primary objective of join pruning? To simplify the design of a calculation view for easier maintenance To improve the performance of a calculation view.
What can you achieve by mapping a filter defined on a join node? there are two correct Pruning one of the joined data sources Make sure the two data sources contain the same number of rows after filtering Data consistency in the result set Better performance of join execution.
What do you implement to allow data analysis at different levels of granularity with the same calculation view? Dynamic join Referential join Non-equi join.
How does a referential join type improve performance? By filtering the data By combining similar joins By pruning joins.
Which are options for specifying the multi-join order? there are two correct Outside-In Left-to-Right Inside-Out Right-to-Left.
Which of the following are union pruning approaches? there are three correct Cache-based pruning Explicit pruning using constants Column-based pruning Implicit pruning with a configuration table.
Which of the following statements are correct with reference to the union node? there are two correct Selected columns to union must have the same source name You do not have to select all source columns You can provide a constant value when a source does not provide a column.
Why do you implement a minus node? To select the rows from one data source that also appear in another data source. To select rows that appear in one data source but not another data source.
Why might you implement a rank node? there are two correct To order the sales amount by country and product each year. To identify the training courses that represent the bottom 10%, based on bookings per year. To sort the sales amounts by product in decreasing order. To identify the best selling products in each region for each of the last 5 years.
Why might you create a restricted column? To define rules for a measure that must be protected from unauthorized viewing To generate a filtered column to simplify the creation of calculated columns.
Filters can be defined on attributes but not measures - true or false? FALSE TRUE.
A calculated column can generate an attribute or a measure? FALSE TRUE.
Why should you implement currency conversion in an SAP HANA Cloud calculation view instead of in reporting tools? there are tow correct Performance is usually better Ensure consistency of results across reports Easier for business users to adjust the conversion settings.
Why might you create an input parameter instead of a variable? there are two correct To pass a dynamic value to an expression in a calculated column To filter data by attributes To filter data by measures.
Variables can be defined on attributes and measures - true or false? FALSE TRUE.
What are two types of modeled hierarchy that you can create using calculation views? There are two correct Parent-Child Referential Level Temporal.
How does SQLScript extend standard SQL? There are Two correct By providing table variables to break up larger statements in to smaller ones By providing conditional statements such as IF..THEN..ELSE By allowing JavaScript language to be used.
Why should I define a table using a source file rather than using the SQL statement ‘CREATE TABLE’ in the SQL Console? The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together. Performance of the table is better. The syntax is simpler.
What types of user-defined SQL functions can you include as a data source in a calculation view node? Table Functions Scalar Functions Column Engine Functions.
Why is knowledge of SQL important to an SAP HANA modeler? there are two correct So that they can extend the capabilities of a calculation view using SQL expressions So that they can develop calculation views using SQL instead of using the graphical editor So that they can develop custom logic using an SQL function and consume this within a calculation view.
In which type of calculation view do you create a hierarchy so that it can be read by SQL? Cube Dimension.
In a calculation view, why might you implement SQL code? there are three correct To define a calculated column To create a level hierarchy To define filter conditions for restricted columns To generate values for input parameters.
It is best practice to avoid stacking calculation views, and instead, try to include all logic within one calculation view - true or false? FALSE TRUE.
What are the best practices for Calculated columns ? there are two correct Use Column Engine expressions. Move calculations to the highest node possible. Move calculations to the lowest node possible. Use SQL expressions.
Which of the following steps is required before you can visualize a query plan file from the SAP HANA Database Explorer embedded in SAP Business Application Studio? there are two correct Generate an SQL Analyzer plan file Download the SQL query plan file Execute an SQL query Write an SQL query.
What can you check with Performance Analysis Mode? there are two correct Table partitioning need Join definition optimization SQL expressions performance Calculation view results accuracy.
To work with calculation view Debug Query Mode, you first need to deploy the calculation view? FALSE TRUE.
How many parallelization blocks can you have in a calculation view? 3 5 1.
Which limitation can you overcome by using table partitioning ? The number of rows in a column-store table The number of columns in a row-store table The number of rows in a row-store table The number of columns in a column-store table.
What is the benefit of configuring static cache? Collect calculation view usage statistics. Improve calculation view performance. Capture SQL execution steps for debugging.
Why would you use a snapshot? there are two correct To store intermediate results when executing a query on the calculation view. To improve performance while executing the calculation view. To improve performance when querying historical data. To store the results of a query on the calculation view.
Which of the following tools is used to analyze dependencies between models? there are two correct Column lineage Impact analysis Outline Data lineage.
Which type of semantics can you extract using the option Extract Semantics? there are two correct Calculated Columns Column Labels Hierarchies.
A runtime object in a container must always have a corresponding source file? FALSE TRUE.
In a project structure, which of these appears directly beneath the project? Module Group Folder.
Why do you set the deprecate flag in a calculation view? To provide a warning to the developer suggesting they shouldn't use the calculation view. To prevent developers from consuming the calculation view. To prevent business users from accessing the calculation view. To provide a warning to the business user suggesting they shouldn't use the calculation view.
What is the type of file that is generated when you deploy a complete application? .tar .mtar .zip.
Which database artifact do you define to access external schema objects? User-provided service Calculation view Synonym.
The name of the schema that corresponds to a container is generated and can't be changed. FALSE TRUE.
Git is used to automate the deployment of runtime objects in SAP HANA Cloud? FALSE TRUE.
What is data masking? Removing complete rows of data that should not be seen by users. 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's name with their team name.
Which approach is recommended to create roles that grant privileges to access local objects generated in your container? Design-time Roles Catalog Roles.
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.
Smart data access, smart data integration, and smart data quality are data provisioning technologies of SAP HANA TRUE FALSE.
Which development tool do you use with SAP HANA Cloud? Web IDE for SAP HANA Business Application Studio SAP HANA Studio Eclipse.
Which are typical characteristics of data replication? there are two correct Real-time Persistence Virtualization Data transformation.
SAP HANA smart data integration is available with SAP HANA Cloud and SAP HANA on-premise. True False.
How do you create a remote source? there are two correct Create a source file in your project folder and define the settings Execute aCREATE REMOTE SOURCE SQL statement, including the settings, in the SQL console Enter the settings in the user-interface that is accessed from the catalog of the SAP HANA Database Explorer Generate the remote source using a flowgraph node.
To query a remote table using SQL without first creating virtual tables, you use the linked database feature. TRUE FALSE.
Data Virtualization is supported by smart data access (SDA) and smart data integration (SDI) TRUE FALSE.
A virtual table is created on the system where the remote table is located TRUE FALSE.
Why might you implement a replica table? To improve performance when accessing data from a virtual table To maintain a backup of replicated data To reconcile data between a table in a source and target database To provide a template to speed-up the creation of a new replication scenario.
SAP recommends setting up replication using SQL statements. TRUE FALSE.
SAP HANA replication services can be used to replicate data from SAP HANA Cloud to SAP HANA on-premise. TRUE FALSE.
Why might you consider using .hdbreptask source files to set up data replication instead of SQL statements? there are two correct Replication can be automatically generated from OData services. It is required to enable the collection of run-time statistics. It supports simple maintenance using a form-based editor. It is easy to transport from development to production system environments.
Why might you choose a replication approach to data provisioning? There are Two correct To improve data access performance To access data whilst avoiding persistence To migrate data from one system to another To cleanse data before loading to SAP HANA.
What are choices for data target? there are three correct table type table synonym table function calculation view.
Which of the following nodes can be processed in real time? there are three correct Union Aggregation Pivot Join Lookup.
In your data flow, you want to apply a filter on the country column, but the choice of country will only be known at the time of flowgraph execution. What do you create? Variable Function Placeholder Parameter.
A data target node must always follow a case node? TRUE FALSE.
Which aggregation behaviors are supported by the aggregation node? threre are three correct sum rank count max median.
You want to transform data before loading it to a target. What do you define? Calculation View Data Flow Transformation Flowgraph.
Which operation do you choose when you want to enrich a record with additional columns from a second data source? Join Union Case Projection.
|
