1. Row 2. Col 3. History 4. Global temp 5. Local temp 6. Virtual

1. >2.0 2. Inside Out 3. Outside In. 4. Central Table

1. Hash 2. Round Robin 3. Range - > No Need not to drop a table - > Can not Partition on Row Store.

1. Supported by Calculation view only 2. Star Join can have only 1 Dim cal view.

HA300- LEARNING Flashcards by Ritik Raj

Valid partition types

HASH , RANGE, ROUND ROBIN

How well did you know this?

Not at all

Perfectly

Table Type

Row
Col
History
Global temp
Local temp
Virtual

How well did you know this?

Not at all

Perfectly

Multi Join

> 2.0
Inside Out
Outside In.
Central Table

How well did you know this?

Not at all

Perfectly

Partition

Hash
Round Robin
Range
- > No Need not to drop a table
- > Can not Partition on Row Store.

How well did you know this?

Not at all

Perfectly

Full Outer Join

Supported by Calculation view only

2. Star Join can have only 1 Dim cal view.

How well did you know this?

Not at all

Perfectly

Union Node Pruning

How well did you know this?

Not at all

Perfectly

SDA (Smart Data Access) can be used for?

Pushing down queries to remote DB, expose data to VT (Virtual Tables) in HANA, and Transform data in remote sources.

How well did you know this?

Not at all

Perfectly

What technology uses log based real time replication?

SRS

How well did you know this?

Not at all

Perfectly

Which Data Provisioning technologies use batch replication?

) SDI

2) SDQ
3) DS
4) DXC

How well did you know this?

Not at all

Perfectly

What is loaded into memory when tables are accessed?

Only columns and partitions required by the application.

How well did you know this?

Not at all

Perfectly

What is the role of the customer in SAP HEC (HANA Enterprise Cloud)?

1) Customer brings the licensed Software

2) SAP Manages the Infrastructure

How well did you know this?

Not at all

Perfectly

Modeling Best Practice. Pt. 1

1) Avoid transfer of large amounts of data result sets between the SAP HANA DB and the Client Application.
2) Do calculations after Aggregation.
3) Avoid Complex expressions and instead push down into the model.
4) Aggregate data records (group by)

How well did you know this?

Not at all

Perfectly

Modeling Best Practice. Pt. 2

1) Join on Key Columns because they become indexed.
2) Avoid Calculations before aggregations on line item levels.
3) Replace sequential cursor looping with set processing
4) Filter data amount as early as possible in the lower layers.

How well did you know this?

Not at all

Perfectly

What are the different SAP HANA Cloud Managed Services?

1) IaaS (Infrastructure as a Service)
2) MCaaS (Managed Cloud as a Service)
3) PaaS (Platform as a Service)
4) DBaaS (Database as a Service)
5) SaaS (Software as a Service)

How well did you know this?

Not at all

Perfectly

What is transparent Filter used for?

It allows you to add distinct measures from LOWER level Calculation Views to UPPER Calculation views

How well did you know this?

Not at all

Perfectly

What must I create to develop a predictive model?

a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View

Answer is b) Flowgraph

How well did you know this?

Not at all

Perfectly

What are the advantages of columnar storage?

There are 2 answers to this question.

a) Improved performance when all fields are selected
b) Improved data reading performance
c) Improved compression
d) Improved data writing performance

b. Improved data reading performance

c. Improved compression

How well did you know this?

Not at all

Perfectly

Which of the following views can you extend with the SAP HANA Live Extension Assistant?

Please choose the answer.

a) Your own custom views
b) Reuse views
c) All SAP-delivered views
d) Query views with a union

b. reuse views

How well did you know this?

Not at all

Perfectly

What information can you find in the Plan Graph?

There are 2 answers to this question.

a) Number of records returned in each step
b) Execution engines used
c) Time taken for each step
d) SQL Plan Cache

a. number of records returned in each step

c. time taken for each step

How well did you know this?

Not at all

Perfectly

In which direction do you build calculation views when including the source tables in Join nodes?

Please choose the answer.

a) From the Join nodes up to the semantics node
b) From the Semantics node up to the default node
c) From the Semantics node down to the Join nodes
d) From the Join node down to the default node

a. from the join nodes up to the semantic node

How well did you know this?

Not at all

Perfectly

What should you keep in mind when using imperative logic in SQLScript?

Please choose the answer.

a) It matches SQL’s set-oriented paradigm.
b) You can only use if-then logic.
c) It delivers the best possible performance.
d) You can loop through records.

d. you can loop through records

How well did you know this?

Not at all

Perfectly

Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?

There are 2 answers to this question.

a) It offers a simplified landscape.
b) It provides a quick start for customers using Business Suite on non HANA databases.
c) Data is available in real time using SLT.
d) There is no data movement.

a. it offers a simplified landscape

d. there is no data movement

How well did you know this?

Not at all

Perfectly

Which spatial data formats can you import into SAP HANA?

There are 2 answers to this question.

a) ESRI shapefiles
b) GeoJSON
c) Scalable Vector Graphic (SVG)
d) Well-Known Text (WKT)

a. ESRI Shapefiles

d. Well- Known Text (WKT)

How well did you know this?

Not at all

Perfectly

What technique is used to convert record updates into insert statements in the delta buffer?

Please choose the answer.

a) Sorted inserts
b) Parallelism
c) Unsorted inserts
d) Insert-only

d. insert- only

How well did you know this?

Not at all

Perfectly

What is the default node for a calculation view of type cube? Please choose the answer. a) Aggregation node b) Star join node c) Projection node d) Join node

a. aggregation note

What combination enabled real-time computing? Please choose the answer. a) Multicore CPUs with large level 1 caches b) In-memory technology with solid-state disks c) Multicore CPUs and solid-state disks d) In-memory technology and multicore CPUs

d. In- memory technology and multicore CPUs

What spatial data type would you use to store multiple shop locations? Please choose the answer. a) ST_Polygon b) ST_MultiLineString c) ST_Point d) ST_MultiPoint

d. ST_MultiPoint

You have to build a parent-child hierarchy. What type of join do you expect to use? Please choose the answer. a) Temporal join b) Relational join c) Self-join d) Dynamic join

c. Self- Join

What development tool is available for creating SAP HANA XSA and HDI information models? Please choose the answer. a) SAP HANA Web-Based Development Workbench b) SAP Web IDE for SAP HANA c) SAP HANA Studio d) Database Explorer

b. SAP Web IDE for SAP HANA

What type of load does SAP HANA perform when starting up? Please choose the answer. a) Log load b) Complete load c) Lazy load d) Fast load

c. Lazy Load

In which programming languages can you create procedures in SAP HANA? There are 2 answers to this question. a) R b) SQLScript c) L d) JavaScript

a. R | b. SQL Script

If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green? Please choose the answer. a) Store green as an attribute. b) Store green as a spatial data type. c) Store green as a measure. d) Store green as a CDS view.

a. Store green as an attribute

What type of input parameters do you use to choose the data from a field in the current table? Please choose the answer. a) Column b) Value help c) Derived from table d) Direct

a. column

SAP HANA security services include which of the following? There are 4 answers to this question. a) Audit logging b) Antivirus Protection c) Encryption d) Authorization e) Authentication

a. Audit Logging c. Encryption d. Authorization e. Authentication

Where can you create a filter expression? Please choose the answer. a) In a Data Foundation node b) In a Projection node c) In an Aggregation node d) In the Semantics node

b) In a Projection node

Which hierarchies can you enable for SQL access? Please choose the answer. a) Time-dependent hierarchies in a dimension view b) Shared hierarchies in a star join view c) Level hierarchies in a calculation view of type cube d) Local hierarchies in a star join view

b) Shared hierarchies in a star join view

You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information. The INDIA calculation view is built on top of the WORLD calculation view and shows information for Indian products. What privilege must you assign to see your department's specific data in a report built on the INDIA calculation view? Please choose the answer. a) An analytic privilege on the WORLD calculation view b) An object privilege on the WORLD calculation view c) An analytic privilege on both calculation views d) An analytic privilege on the INDIA calculation view

c) An analytic privilege on both calculation views

Identify the join that checks the From and To column on the left table.*** i think there is supposed to be a picture with this one but there wasnt a screenshot in the word document** Please choose the answer. a) Right Outer Join b) Full Outer Join c) Text Join d) Temporal Join e) Left Outer Join

d) Temporal Join

What must be installed for PAL to work? Please choose the answer. a) SAP HANA AFM b) SAP HANA SINA c) SAP HANA BFL d) SAP HANA AFL

d) SAP HANA AFL

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

b. the function must be of the type scalar | d. the generated value can be overwritten at run time

When do you use the SQL Analyzer? Please choose the answer. a) To investigate the generated SQL for each node in my calculation view. b) To highlight syntax errors in my SQL code. c) To identify the longest running SQL statements. d) To hide the syntax errors in my SQL code.

c. to identify the longest running SQL statements

Which component of the SAP SQL Data Warehousing do you use to move tables with data that are used together often to the same node to enhance query performance? Please choose the answer. a) Data Warehouse Scheduler (DWS) b) Data Warehouse Monitor (DWM) c) Data Distribution Optimizer (DDO) d) Data Lifecycle Manager (DLM)

c. Data Distribution Optimizer (DDO)

Why do we still need a persistent layer? There are 2 answers to this question. a) To hold the delta store for newly arrived records b) To store data that is frequently used c) To enable full database recovery if we have a power failure d) To store data that has been unloaded from memory

c. to enable full database recover if we have a power failure d. to store data that has been unloaded from memory

What is a role of the SAP HANA Cockpit? Please choose the answer. a) To provide key system performance information for one or more HANA instances b) To provide KPIs to help focus on business performance c) To secure the SAP HANA Database d) To provide an application developer collaboration hub

a. to provide key system performance information for one or more HANA instances

From where does the Extract Semantics feature get the definition of hierar- chies? Please choose the answer. a) From the underlying dimension views b) From the table data sources c) From the SQL view data sources d) From the current calculation view

a) From the underlying dimension views

You imported the following objects. Which of them always require an activity from you before they can be built? There are 2 answers to this question. a) Synonyms definition b) Multi-target application c) SAP HANA database module d) Logical schema definition

b) Multi-target application | c) SAP HANA database module

Where can you create a filter expression? Please choose the answer. a) In a Data Foundation node b) In a Projection node c) In an Aggregation node d) In the Semantics node

b. in a projection node

Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system? There are 2 answers to this question. a) SAP HANA as a platform with an SAP HANA XS application b) SAP HANA as a reporting server c) SAP HANA as a database d) SAP HANA as a side-by-side accelerator

b. SAP HANA as a reporting server | c. SAP HANA as a database

What performance techniques should you implement to improve the performance of SAP HANA information views? There are 3 answers to this question. a) Push down aggregations to SAP HANA. b) Minimize the transfer of data between the execution engines. c) Investigate partitioning of large tables. d) Perform calculation before aggregation in your analytic views. e) Apply filters as late as possible.

a. push down aggregations to SAP HANA b. Minimize the transfer of data between the execution engines c. investigate partitioning of large tables

``` 41. Which type of cloud solution is SAP HANA Enterprise Cloud an example of? Please choose the answer. a) Infrastructure as a service (IaaS) b) Software as a service (SaaS) c) Managed cloud as a service (MCaaS) d) Platform as a service (PaaS) ```

c. managed cloud as a service (MCaaS)

42. When can you use the referential join? Please choose the answer. a) When you have to report on all posted facts b) When you have to report on facts with matching dimensions c) When referential integrity is assured d) When you have to report on all dimensions to confirm if there are matching facts or not.

c) When referential integrity is assured

``` 43. In SAP HANA Studio, what would you find in a Package? There are 3 answers to this question. a) Tables b) Calculation Views c) Procedures d) Analytic Privileges ```

b. calculation views c. procedures d. analytic privileges

44. You have copied a design-time file from a source folder to a target folder that has the same namespace setting. In which of the following scenarios will a build of the copy design-time file be successful? There are 2 answers to this question. a) The source design-time file has never been built. b) The build of the copy design-time file will always be successful c) The source design-time file has been deleted from the source folder in the meantime. d) The source design-time file has been built once but the built has failed.

a) The source design-time file has never been built. | d) The source design-time file has been built once but the built has failed.

45. Which business intelligence tool can publish storyboards? Please choose the answer. a) SAP Analysis for Microsoft Office b) SAP Lumira, designer edition c) SAP BusinessObjects Analysis, edition for Microsoft Office d) SAP BusinessObjects Web Intelligence

a) SAP Analysis for Microsoft Office

``` 46. To maintain good read performance in a constantly changing database, which two components are used? There are 2 answers to this question. a) Memory store b) Delta storage c) Column store d) Main storage ```

b) Delta storage | d) Main storage

``` 47. Which of the following would you create to build a predictive model? Please choose the answer. a) A function b) A decision tree c) A flowgraph d) A procedure ```

c. a flowgraph

``` 48. Which data provisioning tools can use SAP HANA adapters? There are 2 answers to this question. a) SDA b) SAP HANA streaming analytics c) SDI d) SAP Replication Server ```

a) SDA | c) SDI

49. The company asks you to get data from IoT sensors. Which SAP tools could you use? There are 3 answers to this question. a) SAP HANA Remote Data Sync (RDSync) b) SAP Landscape Transformation Replication Server c) SAP HANA streaming analytics d) SAP SQL Anywhere e) SAP HANA smart data access (SDA)

a) SAP HANA Remote Data Sync (RDSync) c) SAP HANA streaming analytics d) SAP SQL Anywhere

50. What are properties of domain fix values? There are 2 answers to this question. a) They are based on SQLScript functions. b) They are static values. c) They ask end users for input at runtime. d) They are based on the ABAP Data Dictionary.

b. They are static values | d. They are based on the ABAP Data Dictionary

``` 51. The virtual data model for SAP S/4HANA is based on which of these? Please choose the answer. a) ABAP CDS b) SAP HANA Live c) SAP HANA CDS d) Universe ```

a) ABAP CDS

``` 52. Where do you create a variable? Please choose the answer. a) In the work area of an Aggregate node b) In the Semantics node c) In the context menu of a workspace d) In the output area of a Join node ```

b. in the semantics node

``` 53. When creating a system connection in SAP HANA Studio, which of these is essential information? There are 3 answers to this question. a) Instance b) URL c) A valid user and password d) Host ```

a. Instance c. A valid user and password d. host

``` 54. What should you use to create tables in an HDI container? There are 2 answers to this question. a) SAP Enterprise Architecture Designer b) Database Explorer c) SQL Console d) Core Data Services (CDS) ```

a) SAP Enterprise Architecture Designer | d) Core Data Services (CDS)

``` What is the recommended way to create full-text indexes? Please choose the answer. a) Core Data Services b) Procedures c) User-defined functions d) SQL statements in the SQL console ```

a) Core Data Services

``` If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use? Please choose the answer. a) Procedure b) Function c) None of these d) Both Procedure and Function ```

a) Procedure

``` What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the answer. a) RANK() b) SORT BY c) SCORE() d) TOP ```

c) SCORE()

``` Which storage is required if you implement multistore tables for SAP HANA? Please choose the answer. a) Nearline storage b) Delta storage c) Remote storage d) Extended storage ```

d) Extended storage

``` Where is SAP HANA Live installed? Please choose the answer. a) On the SAP ERP application server b) In the SAP HANA database c) On SAP Landscape Transformation Replication Server d) In the reporting tool ```

b. in the SAP HANA database

What is SQLScript? Please choose the answer. a) A simplified query language aimed at business users that generates SQL. b) A subset of standard SQL that is exposed to HANA database procedures. c) An extension to standard SQL that provides additional expressions, functions and datatypes. d) A subset of standard SQL that is exposed to HANA modelers.

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

``` Which of the following features of an XS Advanced application are provided by an HDB module? There are 2 answers to this question. a) User interface b) Virtual data modeling c) Business logic d) Persistence layer ```

b) Virtual data modeling | d) Persistence layer

``` What is needed in an SAP Vora deployment? There are 2 answers to this question. a) SAP HANA data warehousing foundation b) Apache Spark c) SAP Data Services d) Apache Hadoop ```

b) Apache Spark | d) Apache Hadoop

Why might you want to reference a user-provided service in a project? Please choose the answer. a) To access data from your project container b) To access data from another container c) To access data from a classic database schema

c) To access data from a classic database schema

The relational model of SAP HANA Live is built using which type of views? Please choose the answer. a) Analytic views and attribute views b) Calculation views of data category cube with star join c) Scripted calculation views d) Calculation views of data category cube without star join

d) Calculation views of data category cube without star join

``` Which join types are available in a Join node of a calculation view? There are 2 answers to this question. a) Referential joins b) Cross joins c) Spatial joins d) Temporal joins ```

a) Referential joins | c) Spatial joins

Identify the principles that you need to follow during modeling. There are 2 answers to this question. 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.

Where can you set the default value for the SAP client for the entire calculation view? Please choose the answer. a) In the default node of the calculation view b) In the Preferences option of the Tools menu c) In the Join node of the calculation view d) In the semantic layer of the calculation view

d) In the semantic layer of the calculation view

``` What paradigm describes the SQL language? Please choose the answer. a) Application-focused b) Object-oriented c) Set-oriented d) Procedural ```

c) Set-oriented

``` What are components of SAP HANA EIM? There are 2 answers to this question. a) SDI b) SDQ c) SDA d) SDS ```

a) SDI | b) SDQ

When would you use a function? Please choose the answer. a) To break SQL into smaller statements. b) When you need to define complex data sources for my calculation view that require conditional logic. c) When you need to write results back to a table. d) To develop a calculation view with the best possible performance.

b) When you need to define complex data sources for my calculation view that require conditional logic.

In SAP HANA Text Analysis, why would you use the 'Voice of Customer' dictionary? Please choose the answer. a) To identify close matches in words and expressions, to catch misspellings b) To extract the sentiment from customer feedback on social media c) To identify the problem which customers are facing d) To extract common entities such as company, country, currencies, and so on, found in documents

b. to extract the sentiment from customer feedback on social media

``` What statement is allowed in a user-defined function? Please choose the answer. a) INSERT b) JOIN c) EXEC d) COMMIT ```

b) JOIN

For what tasks would you use the Where-Used feature in SAP HANA? Please choose the answer. a) To find all places where an information model is used b) To find all places where translations exist c) To find all places where an information model has been deployed d) To find all places where a developer updated information models

a. to find all places where an information model is used

``` Which are of the following languages supported by SAP HANA Graph are optimized for graph processing? There are 2 answers to this question. a) Cypher Query Language b) GraphScript c) SQL Script d) SQL ```

a) Cypher Query Language | b) GraphScript

``` In which type of node can you create calculated columns? There are 2 answers to this question. a) Rank node b) Union node c) Graph node d) Projection node ```

b) Union node | d) Projection node

What is scale-out? There are 2 answers to this question. a) Use of standby servers in the event of hardware failure. b) Use of multiple servers to spread processing and improve performance. c) Use of commodity servers that are used in high volume steaming applications. d) Use of remote servers to store archived data that is rarely used.

a) Use of standby servers in the event of hardware failure. | b) Use of multiple servers to spread processing and improve performance.

``` Which views in SAP S/4HANA embedded analytics may you extend? Please choose the answer. a) Query views b) Composite views c) Interface views d) Consumption views ```

d) Consumption views

A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails. Which of the following are possible reasons for the failure? There are 2 answers to this question. a) The geometry is an ST_POLYGON where the last defined point is not the same as the first one. b) The geometry is an ST_MULTIPOLYGON that specifies only one polygon. c) The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one. d) The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.

a) The geometry is an ST_POLYGON where the last defined point is not the same as the first one. c) The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one.

Which of the following can a level hierarchy do? Please choose the answer. a) Have time-dependency b) Be used for a bill of materials (BOM) structure c) Enable drilldown in a value help list d) Show variable deepness in the data

c) Enable drilldown in a value help list

Why do you assign semantic types to measures or attributes in calculation views? Please choose the answer. a) To provide meaningful value help when using variables b) To allow client applications to present data in appropriate formats c) To enable the activation of the calculation view d) To ensure consistency across calculation views

b) To allow client applications to present data in appropriate formats

Which recent trends have triggered the need for a next generation data processing platform? There are 3 answers to this question. a) Increase in use of mobile devices b) Massive growth in data volume c) Increasing connectivity of people and devices d) Move transactional processing and analysis to separate servers for better scalability

a. increase in use of mobile devices b. massive growth in data volume c. increasing connectivity of people and devices

``` Identify the object that adds a WHERE clause to the query. Please choose the answer. a) Variable b) Attributes c) Modeler d) Input parameter ```

a) Variable

``` What tool generates files to help configure SAP Landscape Transformation Replication Server table replication? Please choose the answer. a) SAP HANA Studio b) Authorization Assistant c) SAP HANA Live Browser d) SAP HANA Live Extension Assistant ```

c. SAP HANA Live Browser

What is the SAP HANA Application Function Library (AFL)? There are 2 answers to this question. a) Repository of ready-made predictive algorithms b) Repository of connections that can be used by business functions c) Repository of ready-made business functions d) Repository of ready-to-run applications that are powered by SAP HANA

a. Repository of ready-made predictive algorithms | c. Repository of ready-made business functions

``` What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the answer. a) Characteristics b) Facets c) Measures d) Key figures ```

c. measures

``` You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required. Which tool do you recommend? Please choose the answer. a) SAP Crystal Reports for Enterprise b) SAP Lumira, designer edition c) SAP Lumira, discovery edition d) SAP BusinessObjects Web Intelligence ```

b) SAP Lumira, designer edition

``` Which are features of a calculated column? There are 2 answers to this question. a) It's a column in the result set. b) Its calculations are persisted. c) It's created in the output area. d) It's created in the Semantics node. ```

a) It's a column in the result set. | c) It's created in the output area.

``` Which database artifact do you use to access external data from an XS Advanced project? Please choose the answer. a) User-provided service b) Logical schema c) Calculation view d) Synonym ```

d) Synonym

``` What are the four SAP HANA platform services? There are 4 answers to this question. a) Application Services b) Database Services c) Processing Services d) Security Services e) Integration Services ```

a) Application Services b) Database Services c) Processing Services e) Integration Services

You have logs from a website. How do you show the total number of website visitors that used a mobile phone? There are 2 answers to this question. a) Create a rank column. b) Create a hierarchy expression parameter. c) Create a filter expression. d) Create a restricted column.

c. Create a filter expression | d. Create a restricted column

Which deployment scenario can you use to accelerate reporting from an old SAP R/3 system? Please choose the answer. a) SAP HANA as a platform b) SAP HANA Multitenant Database Containers (MDC) c) SAP HANA as a side-by-side accelerator d) SAP HANA as a databas

c) SAP HANA as a side-by-side accelerator

``` Which SAP solution does SAP HANA Live support? Please choose the answer. a) SAP BW/4HANA b) SAP Ariba c) SAP Business Suite d) SAP S/4HANA ```

c) SAP Business Suite

``` To what subset of SQL does the SELECT statement belong? Please choose the answer. a) DCL b) DQL c) DML d) DDL ```

b) DQL

``` What PAL algorithm would you use to analyze shopping baskets? Please choose the answer. a) Decision tree b) Link prediction c) K-means d) Apriori ```

d) Apriori

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 answers to this question. a) You get an error when you build the entire HDB module b) The build of the entire HDB module is successful c) The build of Model A is successful d) Model B gets deleted from the HDI container e) You get a build error when you build Model A

b) The build of the entire HDB module is successful | c) The build of Model A is successful

What do you create to find the number of unique items sold per shop? Please choose the answer. a) An analytic view with a calculated column in a Star Join node b) A calculation view with a counter in a Projection node c) A calculation view with a counter in an Aggregation node d) A calculation view with a restricted column in an Aggregation node

c. a calculation view with a counter in a Projection node

``` n which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system? There are 2 answers to this question. a) SAP HANA Live b) SAP S/4HANA c) SAP HANA as a platform d) SAP BW powered by SAP HANA ```

a. SAP HANA Live | c. SAP HANA as a platform

What are advantages of column store tables? There are 3 answers to this question. a) Only the columns required are actually loaded to memory b) Data footprint is automatically reduced through compression c) They are optimized for high-volume read / write transactional processing d) Columns can be partitioned

a. only the columns required are actually loaded to memory b. data footprint is automatically reduced through compression d. columns can be partitioned

When we refer to mixed modeling, what do we mean? Please choose the answer. a) Models from BW on any DB combined with models from BW on HANA b) Classic BW models combined with SAP HANA optimized BW models c) NetWeaver models combined with native SAP HANA models d) BW models combined with native SAP HANA models

d. BW models combined with native SAP HANA models

``` You want to publish your business intelligence content directly to SAP Analytics Cloud. Which tool do you use? Please choose the answer. a) SAP Lumira, discovery edition b) SAP Analysis for Microsoft Office c) SAP Crystal Reports for Enterprise ```

a) SAP Lumira, discovery edition

``` What are key features of SAP HANA? There are 3 answers to this question. a) In-memory database b) Removes the need for cache c) Combined OLTP and OLAP processing on one platform d) Automatic compression of data ```

a) In-memory database c) Combined OLTP and OLAP processing on one platform d) Automatic compression of data

``` What are the two views in the Web IDE for SAP HANA? There are 2 answers to this question. a) Catalog b) Development c) Database Functions d) Database Explorer ```

b. development | d. database explorer

``` What can you use to limit users to see only 2018 data? There are 2 answers to this question. a) A view with a restricted column b) An object privilege c) A view with a filter d) A SQL analytic privilege ```

a) A view with a restricted column | d) A SQL analytic privilege

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 answers to this question. a) When you build only the dimension calculation view, the build is successful. b) When you build the HDB module, the build fails. c) When you build only the dimension calculation view, the build fails. d) When you build the HDB module, the build is successful.

c. when you build only the dimension calculation view, the build fails d. when you build the HDB module, the build is successful

What do you need to do after creating a new project with an HDB module? Please choose the answer. a) Convert the new module to an HDB module b) Select a space for running the project c) Create an .hdinamespace file

b) Select a space for running the project

``` What are the two storage components used to restore the database in case of power failure? There are 2 answers to this question. a) Data volume b) Memory c) Log area d) Delta store ```

a) Data volume | c) Log area

``` Which recent technology advances have made SAP HANA possible? There are 2 answers to this question. a) Faster internet speeds b) Faster disk speeds c) Multicore processors d) Larger and cheaper memory ```

c) Multicore processors | d) Larger and cheaper memory

You create a full-text index. For what text feature clause do you need to specify a configuration? a) TEXT MINING b) TEXT ANALYSIS c) FUZZY SEARCH INDEX d) SEARCH ONLY

b) TEXT ANALYSIS

You have a list of map locations for clinics. The government wants to build a new clinic where there is the greatest need. You need to find the largest distance between any two clinics.With your current knowledge, how do you do this? Please choose the answer. a) Use a temporal join to find the distance between clinics. Use a union with constant values to "pivot" the values. b) Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option. c) Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown. d) Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.

b) Use a spatial join to find the distance between clinics. | Use an aggregation with the maximum option.

In which SAP HANA views will you find measures? There are 2 answers to this question. a) Calculation view of type dimension b) Calculation view of type cube c) Calculation view of type cube with star join d) Database views

b) Calculation view of type cube | c) Calculation view of type cube with star join

``` You want to build a hierarchy on a time-based data structure, such as year, month, and day. What type of hierarchy do you use? Please choose the answer. a) Level hierarchy b) Parent-child hierarchy c) Unbalanced hierarchy d) Ragged hierarchy ```

a) Level hierarchy

You're writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous games. How do you use the data of the player information and the scores? Please choose the answer. a) The player information is used as transactional data, and the scores are used as master data. b) Both the player information and the scores are used as transactional data. c) The player information is used as master data, and the scores are used as transactional data. d) Both the player information and the scores are used as master data.

c. the player information is used as master data, and the scores are used as transactional data

``` With which statement can you call a table function? There are 2 answers to this question. a) EXEC b) INSERT INTO c) SELECT d) CALL ```

a. EXEC | c. SELECT

``` You created a user-defined function with a return type of BIGINT. What type of function have you created? Please choose the answer. a) Scalar function b) Table function c) Window function d) SQL function ```

a) Scalar function

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 answer. a) SAP Lumira, designer edition b) SAP BusinessObjects Web Intelligence c) SAP Crystal Reports for Enterprise d) SAP Lumira, discovery edition

c) SAP Crystal Reports for Enterprise

``` You use parallelism to calculate a year-to-date value quickly, and you eliminate a table from the database. What are some of the implications of this action? There are 3 answers to this question. a) Less code b) Better user interfaces c) Faster inserts into the database d) Smaller database backups e) Faster response times ```

a) Less code d) Smaller database backups e) Faster response times

Why did SAP move from XS to XSA? There are 2 answers to this question. a) To provide better source code management tools inside SAP HANA b) To implement micro-services architecture c) To move to Cloud Foundry architecture to allow flexible application deployment options d) To include ABAP as a key development language for native SAP HANA applications

b. to implement micro- services architecture | c. to move to Cloud Foundry architecture to allow flexible application deployment options

Why should you use variables in SQL Script? There are 2 answers to this question. a) To implement flow control logic b) To support processing push-down c) To increase parallelization opportunities d) To improve code readability

c) To increase parallelization opportunities | d) To improve code readability

``` You need to return multiple result sets using SQL Script. What do you use? Please choose the answer. a) Scripted calculation view b) Procedure c) Table function d) Scalar function ```

b) Procedure

``` In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? There are 2 answers to this question. a) Tighter security b) Data loading performance c) Reporting performance d) Superior data quality ```

b. data loading performance | c. reporting performance

``` Which technologies does SAP HANA use to load more data into memory? There are 3 answers to this question. a) Use multicore CPU parallelism b) Use dictionary compression c) Store data in column tables d) Eliminate indices e) Use ZIP compression ```

b. use dictionary compression c. store data in column tables d. eliminate indices

``` What does SAP HANA load when starting up and before indicating that it's ready? There are 3 answers to this question. a) All partitions b) All row tables c) Some column tables d) All system tables e) Some row tables ```

b. all row tables c. some column tables d. all system tables

``` What phrase describes the main table area in the delta merge scenario? Please choose the answer. a) Read-optimized b) Row store c) Write-optimized d) Unsorted inserts ```

a. read- optimized

``` Which variable type would you define if you want to use operators such as Greater Than or Less Than? Please choose the answer. a) Interval b) Expression c) Range d) Multiple Entries ```

c) Range

Which SAP tools can work with data from Hadoop? There are 3 answers to this question. a) SAP Vora b) SDA c) SAP Landscape Transformation Replication Server d) SDI e) RDSync

a) SAP Vora b) SDA d) SDI

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

a) Always as the bottom (leaf) node

Which of the following node types can you use to build a dimension view? There are 3 answers to this question. a) Semantic Node b) Aggregation node c) Data foundation node d) Star join node e) Union node

a. semantic node b. aggregation node e. union node

You want to see in a Union node which data sources return no results for a query. How do you achieve this? a) Create a union pruning configuration table. b) Set the Empty Union Behavior property. c) Set the is Null property in the Manage Mapping dialog d) Create a standard union

b) Set the Empty Union Behavior property.

What are typical characteristics of SAP HANA data replication? There are 2 answers to this question. a) Streaming b) Virtualization c) Real-time d) Duplicate data

c. real-time | d. duplicate data

``` Which SAP tool can you use to include geospatial and predictive processing as part of the data transformation process? Please choose the answer. a) SAP Data Services b) SDQ c) SDI d) SDA ```

b) SDQ

``` For what SQL keyword is the Aggregation node the equivalent? Please choose the answer. a) DISTINCT b) GROUP BY c) UNIQUE d) ORDER BY ```

b) GROUP BY

``` Which of the following terms are associated with an operational system? There are 2 answers to this question. a) Transactional b) OLAP c) OLTP d) Data warehouse ```

a) Transactional | c) OLTP

``` What node uses a special configuration table to optimize performance? Please choose the answer. a) Join node b) Projection node c) Union node d) Aggregation node ```

c) Union node

``` What is included with the Predictive Analysis Library (PAL)? There are 2 answers to this question. a) Flowgraphs b) Text mining functions c) Data preparation functions d) Predictive algorithms ```

c. data preparation functions | d. predictive algorithms

``` BI tools connect to the SAP HANA database using which of these? There are 4 answers to this question. a) TRFC b) ODBC c) JDBC d) ODBO e) BICS ```

b. ODBC c. JDBC d. ODBO e. BICS

``` Which of the following data operations can you perform with SDA? There are 3 answers to this question. a) Data federation b) Real-time replication c) Physical data warehouse d) Logical data warehouse ```

a) Data federation b) Real-time replication d) Logical data warehouse

Why would you use SAP HANA Vora? Please choose the answer. a) To provide a high-performance warm data store for data that is accessed infrequently b) To ensure consistent HANA performance by offloading workloads when CPU usage is high c) To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis d) To provide secure cloud integration with any HANA application

c. to combineunstructured data stored on Hadoop with structured enterprise data for OLAP analysis

``` What type of file would you create in the SAP Web IDE for SAP HANA to do data cleaning? Please choose the answer. a) .hdbcds b) .hdbflowgraph c) .hdbgraphworkspace d) .hdbtabledata ```

b) .hdbflowgraph

``` What SAP HANA feature do you use to host multiple applications for different companies in single SAP HANA landscape while ensuring isolation? Please choose the answer. a) Extended storage b) Active/Active (read-enabled) mode c) Multitenant Database Containers (MDC) d) SAP HANA as a distributed database ```

c) Multitenant Database Containers (MDC)

``` What can be used to return multiple result sets? Please choose the answer. a) Procedure b) View c) Table function d) Scalar function ```

a) Procedure

``` You want to show a male and female option to end users. What feature do you use? There are 3 answers to this question. a) Expressions b) Value help c) Input parameters d) Domain fix values e) Variables ```

b) Value help c) Input parameters e) Variables

``` Which words are associated with the log volume? There are 2 answers to this question. a) Savepoint b) Page manager c) Transaction manager d) Synchronous ```

c. Transaction Manager | d. Synchronous

``` How many processing tiers do you usually find in a native SAP HANA application stack? Please choose the answer. a) 2 b) 1 c) 3 d) 4 ```

a) 2

``` What type of node is recommended to combine two data sources that have a similar set of dimensions? Please choose the answer. a) Inner join b) Star join c) Union d) Join ```

c) Union

``` What should you keep in mind about user-defined functions? Please choose the answer. a) They can call procedures. b) They can use dynamic SQL. c) They can use imperative logic. d) They can commit transactions. ```

c) They can use imperative logic.

``` Which text feature do you use to find sentiment in textual data? Please choose the answer. a) Full-text index b) Fuzzy text search c) Text mining d) Text analysis ```

d) Text analysis

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

d. to implement an SQL- driven approach to data warehousing

``` What does SQLScript provide in SAP HANA? There are 3 answers to this question. a) Powerful client-side processing b) Flow control logic c) Aggregation functions such as AVG() d) Creation of column tables e) Variables to break up complex statements ```

b) Flow control logic d) Creation of column tables e) Variables to break up complex statements

Identify the features and benefits of a calculation view. There are 3 answers to this question. a) It supports you to include more advanced calculations. b) It can contain calculated attributes. c) It can be defined as a graphical view or a scripted view. d) It is not possible to join several fact tables in a calculation view.

a) It supports you to include more advanced calculations. b) It can contain calculated attributes. c) It can be defined as a graphical view or a scripted view.

A traditional cube is represented by which SAP HANA view type? Please choose the answer. a) SQL view b) CDS view c) Calculation view of type cube with star join d) Calculation view of type dimension

c) Calculation view of type cube with star join

``` Which of the following are valid types of privileges in SAP HANA? There are 3 answers to this question. a) Attribute privileges b) System privileges c) Package privileges d) Data privileges e) Application privileges ```

b) System privileges c) Package privileges e) Application privileges

What are the features of dynamic analytic privileges? There are 2 answers to this question. a) Reuse the same analytic privilege for several users who need to access different data b) Change the filter condition in the underlying tables and views c) Filter the condition based on a variable entered by the user when they query the view d) Filter the data based on a variable entered by the user when they query the view

a. reuse the same analytic privilege for several users who need to access different data b. change the filter condition in the underlying tables and views

``` What information can you find in the SAP HANA Cockpit? There are 2 answers to this question. a) List of operators b) SQL generated in each step c) Trace and log files d) SQL Plan Cache ```

c. trace and log files | d. SQL Plan Cache

What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement? Please choose the answer. a) ANY b) CONTAINS c) IN d) LIKE

b) CONTAINS

What node can you use for sorting results, for example, to show the top 100? Please choose the answer. a) Union node b) Rank node c) Projection node d) Aggregation node

b) Rank node

Why would you create a procedure? There are 2 answers to this question. a) If you need to provide a data source to a graphical calculation view b) If you need to define a calculated column expression c) If you need to insert records into a table d) If you need a mixture of scalar and tabular output parameters

c. if you need to insert records into a table | d. if you need a mixture of scalar and tabular output parameters

Which of the following are capabilities of SAP HANA Live Browser? There are 3 answers to this question. a) You can launch the views using SAP Analysis Edition for Microsoft Excel. b) You can graphically illustrate the dependencies between SAP HANA Live views. c) You can develop personal lists of frequently used query views. d) You can adjust the views by adding additional columns.

a. you can launch the views using SAP Analysis Edition for Microsoft Excel b. you can graphically illustrate the dependencies between SAP HANA Live views c. you can develop personal lists of frequently used query views

What is XS? Please choose the answer. a) An optional engine to handle excessive data loads b) A user interface c) A native, lightweight application server d) A data cleansing engine

c) A native, lightweight application server

``` What do you have to assign to users to allow Single Sign-On (SSO)? Please choose the answer. a) SQL analytic privileges b) Application privileges c) TRUST ADMIN system privilege d) Kerberos authentication ```

d) Kerberos authentication

``` Which type of tables required extended storage? Please choose the answer. a) In-memory tables b) Column tables c) Row tables d) Multistore tables ```

d) Multistore tables

``` In which SAP HANA solution do you eliminate stored data, such as year-todate figures? Please choose the answer. a) SAP BW on SAP HANA b) SAP S/4HANA c) SAP HANA Enterprise Cloud d) SAP CRM on SAP HANA ```

b) SAP S/4HANA

``` Where do you build a flowgraph? There are 2 answers to this question. a) SAP HANA Studio development perspective b) Web-based development workbench c) Web IDE for SAP HANA d) SAP HANA Studio modeler perspective ```

a) SAP HANA Studio development perspective | c) Web IDE for SAP HANA

Which are the recommended assignments in SAP HANA There are 2 answers to this question. a) Roles to privileges b) Privileges to users c) Roles to roles d) Roles to users

c. roles to roles | d. roles to users

What does the C in ACID-compliant stand for? a) Complete b) Consistency c) Complexity d) Constant

b) Consistency

You created a calculated column in a star join view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong results. What could be the problem? Please choose the correct answer. a) You mistyped the calculated column expression. b) You did NOT enable the Keep Flag. c) You did NOT enable the currency conversion. d) You chose the SQL expression syntax.

b) You did NOT enable the Keep Flag.

How should you create a procedure? Please choose the correct answer. a) Create a runtime object in a HANA project b) Create a runtime object in the SQL console c) Create a design-time object in a SQL console d) Create a design-time object in a HANA project

d) Create a design-time object in a HANA project

What enables the delta buffer technique to speed up both reads and inserts in SAP HANA? Please choose the correct answer. a) Using row-based tables only b) Using only the insert-only technique c) Using column-based tables only d) Using both row-based and column-based tables

d. using both row- based and column-based tables

What are the features of a parent-child hierarchy? There are 3 answers to this question. a) A single dedicated column is used to store the parent of each record of the table b) Parent and child field have the same data type. c) Recursive data structure defines the hierarchy d) Heterogeneous fields are combined in a hierarchy

a. a single dedicated column is used to store the parent of each record of the table b. parent and child field have the same data type c. recursive data structure defines the hierarchy

Which of the following SAP data provisioning tools can provide real-time data provisioning? There are 3 answers to this question. a) SDQ b) SAP Landscape Transformation Replication Server c) SAP Replication Server d) SAP Data Services e) SDI

b. SAP landscape transformation replication server c. ASP Replication server e. SDI

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

b. a table that can distribute its partitions across memory and extended storage tiers

How would you most likely represent the location of an ATM in a visual application that uses SAP HANA spatial processing? a) Multipolygon b) Polygon c) Point d) Line

c) Point

What are features of SDA? There are 2 answers to this question. a) Evaluation and execution of push down possibilities to remote sources b) Merging data from multiple sources c) Automatic data type translation d) Data cleansing

a. evaluation and execution of push down possibilities to remote sources c. automatic data type translation

What node is used to link dimension views to a data foundation (fact tables)? a) Join node b) Projection node c) Star join node d) Union node

c) Star join node

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 sizing of an SAP HANA solution d) A tool to support the build of logical data model

d. a tool to support the build logical data model

Which of the following database terms are used when providing OLAP data with hierarchies? There are 3 answers to this question. a) ODBC b) MDX c) JDBC d) BICS e) ODBO

b. MDX d. BICS e. ODBO

What character is prepended to a SQLScript variable when it's used as an input variable? a) _ (underscore) b) ! (exclamation mark) c) : (colon) d) & (ampersand)

c. : (colon)

In Web IDE for SAP HANA, what can I create in a HDB module? There are 3 answers to this question. a) Analytic Privilege b) Calculation View c) HTML file d) Flowgraph

a) Analytic Privilege b) Calculation View d) Flowgraph

Which of the following VDM views can be called by applications and reports? There are 2 answers to this question. a) Value help views b) Private views c) Reuse views d) Query views

a) Value help views | d) Query views

How can you connect SAP Analysis for Microsoft Office to SAP HANA? a) Using Direct Access Mode b) Using an SAP HANA Live data connection c) Using an ODBO connection d) Using an SAP BusinessObjects Enterprise platform web service

d. using SAP Business Objects Enterprise platform web service

What should you keep in mind when using dynamic SQL? There are 2 answers to this question. a) It delivers the best possible performance. b) It's always bad for security. c) You can dynamically change your data sources d) It could be used for SQL injection

c. you can dynamically change your data sources | d. it could be used for SQL injection

Which of the following benefits characterize the use of a design time filter? There are 3 answers to this question. a) It is defined on the runtime in the SQL query. b) The filter is applied on the table before the query is executed. c) It reduces the result set of data. d) The filter is applied on the result set of a query. e) It is applied before a table join is executed.

b. the filter is applied on the table before the query is executed c. it reduces the result set of data e. it is applied before a table join is executed

Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 answers to this question. a) The database administrator should not get those privileges in the production system. b) The database administrator might type the name wrong c) The focus is on the database administration requirements d) The focus is on the business requirements

a. the database administrator should not get those privileges in the production system d. the focus is on the business requirements

Which table partitioning type does SAP HANA support? There are 3 answers to this question. a) Hash b) Round-robin c) Cluster d) Composite e) Range

a. hash b. round- robin e. range

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

b. it acts based on combinations of events

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 answers to this question. a) Make use of a user-provided service b) Create a synonym c) Use an explicit reference to the schema d) Assign the provided ::access role to your container's technical user e) Make use of the built-in HDI service

a. make use of a user- provided service b. create a synonym d. assign the provided access role to your containers technical user

Which of the following are features of a data warehouse? There are 3 answers to this question. a) Consolidation b) Data governance c) Real-time reporting d) A full transactional history e) Both OLTP and OLAP in one system

a. consolidation b. data governance d. a full transactional history

Where is SDI used? There are 2 answers to this question. a) Data loading b) Data transformation c) Data streaming d) Data cleaning

a. data loading | b. data transformation

Where will you find the Data Distribution Optimizer? a) SAP BW/4HANA b) SAP HANA Studio c) SAP S4/HANA Dictionary d) SAP HANA Data Warehousing foundation

d. SAP HANA Data Warehousing foundation

01. 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 the correct answer. ``` a) Aggregation Function: Sum Result Set Type: Absolute b) Aggregation Function: Rank Result Set Type: Absolute c) Aggregation Function: Row Result Set Type: Percentage d) Aggregation Function: Sum Result Set Type: Percentage ```

c) Aggregation Function: Row | Result Set Type: Percentage

02. 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. a) Build the MTA project. b) Explicitly build the HDB module instead of the MTA project. c) Create at least one namespace in the HDB module. d) Assign the project to a space to which you have developer authorizations.

b) Explicitly build the HDB module instead of the MTA project. d) Assign the project to a space to which you have developer authorizations.

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

d) The object you collect data against, such as house, building, or town

04. 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. a) To allow processing of multiple languages b) To enable a linguistic analysis c) To enable lower memory consumption d) To enable the full set of SQL operations

c) To enable lower memory consumption

05. What does SQLScript provide to extend standard SQL? There are 2 correct answers to this question. a) Integrated source code version management b) Support for ABAP syntax c) Additional data types for the definition of text and spatial data d) Features to push processing to the database

c) Additional data types for the definition of text and spatial data d) Features to push processing to the database

AFL (Application Function Library) include what?

BFL (Business Function Library) and PAL (Predictive Analysis Library).

Deployment Scenarios for SAP HANA Live

Side-by-side (side car) and Integrated

What are the properties of the Delta Store?

Write Optimized with Unsorted Data.

What are the properties of the Main Store?

Read Optimized and Unsorted Data.

What are the available Cloud versions for SAP HANA?

1) HEC (HANA Enterprise Cloud) | 2) HCP (HANA Cloud Platform)

What is the Tailored Data Integration choice of deployment?

The customer has their choice of Hardware from different vendors and SAP HANA is installed by SAP.

How do you activate someone else's Calculation View?

REPO_WORK_IN_FOREIGN_WORKSPACE

What can you convert using the Migrate Utility?

Classical Analytical Privileges to SQL Analytical Privileges.

A Dynamic Analytical Privilege is able to create how many procedures?

Analytical Privileges are applicable to what type of views?

Calculation Views

When procedures are created with table outputs, what option is selected for the output?

Table Type

What are some procedure languages?

1) SQL Script 2) R (Statistics) 3) L

What are the properties of a Table Function?

1) Source for Graphical Calculation Views 2) Read data from a table and loop the results 3) Can be both Scalar and Tubular

What can Table Types be used for?

They could be used as procedures when the input or output parameter is of Tubular Type.

What information could be found in Performance Analysis mode?

1) Number of Rows | 2) Partitions

What information could be found in Explain Plan?

1) Estimated Execution Time | 2) Engines Used

What could improve SQL performance?

Using Multi-level Aggregation whenever possible. | 2) Use variables to use parallelization so SQL steps are run independently.

When processing Variables what is recommended?

Use value help, which is directed to an external model.

What is the purpose of the Delta Store column table?

To store inserted records before they are merged to the Main store.

What sources in the Calculation views are recommended for best performance?

Tables and Graphical Calculation Views.

When the authoring a schema is different from the physical schema what needs to be done?

Schema Mapping.

What type of objects can be added to a Delivery Unit?

1) Packages 2) Analytical Privileges 3) Any models that have been changed

What could be done to speed up the running in the Union node?

Pruning.

How much memory does a Fuzzy Search require?

10%

Which PAL Algorithm could be used for determining delayed flights?

Classification

What are some types of Geospatial data types? And what would the be used for?

) Point 2) Line 3) Polygon

What would type of predictive model would you use for viewing delayed flights?

Decision Tree

What does the Fuzziness Threshold do

It allows you to create search parameters.

What is Fuzzy Search scoring?

It allows you to score search results from 0.0 to 1.0, with 1.0 being an exact match.

What are some reasons you would not have access to PAL?

1) The Script server is not started 2) AFL is not installed 3) Role AFL_SYS_AFL_AFLPAL_EXECUTE is not assigned

What formats are supported for Geospatial data?

1) WKT (Well Known Text) 2) WKB (Well Known Binary) 3) ESRI SHAPE FILES

What are the characteristics of VDM (Virtual Data Models) in Hana Live?

They are able to be extended, predominantly Calculation Views and that are used for Operational Reporting.

What input parameters would you use for currency?

VARCAHR (Variable Character)

What is the outcome of activating a decision table?

A procedure is created

How would you create an input parameter to enter a tax rate?

Direct input type

Which semantic types could you use with direct input parameters?

Date and Unit of Measure

Which of the following is used to handle Orphan nodes?

Error, Ignore and Step Parent.

What are improved when running BW (Business Warehouse) on SAP HANA?

Loading and Reporting Performance.

What type of Data Provisioning tools are used for RT (Real-time)?

1) SLT 2) SRS 3) SDS

SDA (Smart Data Access) can be used for?

Pushing down queries to remote DB, expose data to VT (Virtual Tables) in HANA, and Transform data in remote sources.

What technology uses trigger based real-time replication?

SLT

What technology uses log based real time replication?

SRS

Which adaptors are available for RT (Real-time)

Twitter, ECC (ERP) and Log Reader

Which Data Provisioning technologies use batch replication?

1) SDI 2) SDQ 3) DS 4) DXC

What is loaded into memory when tables are accessed?

Only columns and partitions required by the application.

What is the role of the customer in SAP HEC (HANA Enterprise Cloud)?

1) Customer brings the licensed Software | 2) SAP Manages the Infrastructure

Modeling Best Practice. Pt. 1

1) Avoid transfer of large amounts of data result sets between the SAP HANA DB and the Client Application. 2) Do calculations after Aggregation. 3) Avoid Complex expressions and instead push down into the model. 4) Aggregate data records (group by)

Modeling Best Practice. Pt. 2

1) Join on Key Columns because they become indexed. 2) Avoid Calculations before aggregations on line item levels. 3) Replace sequential cursor looping with set processing 4) Filter data amount as early as possible in the lower layers.

What is _SYS_REPO?

_SYS_REPO is a system user. Its schema is a system schema. Think of _SYS_REPO as "the activation guy". It takes your models and creates the necessary runtime objects from them.

What is _SYS_BIC?

Whenever we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. Whenever we create a model,_SYS_REPO user creates necessary runtime objects from them which get saved into _SYS_BIC schema.

What are the different SAP HANA Cloud Managed Services?

1) IaaS (Infrastructure as a Service) 2) MCaaS (Managed Cloud as a Service) 3) PaaS (Platform as a Service) 4) DBaaS (Database as a Service) 5) SaaS (Software as a Service)

What is transparent Filter used for?

It allows you to add distinct measures from LOWER level Calculation Views to UPPER Calculation views.

05. 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. a) SAP Landscape Transformation Replication Server b) SAP HANA smart data access c) SAP Data Services d) SAP HANA smart data integration

c) SAP Data Services | d) SAP HANA smart data integration

06. What can you discover using Data Lineage? Please choose the correct answer. a) Access statistics b) Underlying calculation views and tables c) Frequency of load d) Data changes since last refresh

b) Underlying calculation views and tables

08. You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic. Please choose the correct answer. a) Set the Keep Flag property for SHIRT_ID b) Set the Dynamic Partition property for SHIRT_ID and PROMO_LEVEL. c) Set the Calculate before Aggregation property. d) Set the Keep Flag property for SHIRT_ID and PROMO_LEVEL.

d) Set the Keep Flag property for SHIRT_ID and PROMO_LEVEL.

09. 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. a) To allow processing of multiple languages b) To enable a linguistic analysis c) To enable lower memory consumption d) To enable the full set of SQL operations

c) To enable lower memory consumption

10. What does SQLScript provide to extend standard SQL? There are 2 correct answers to this question. a) Integrated source code version management b) Support for ABAP syntax c) Additional data types for the definition of text and spatial data d) Features to push processing to the database

c) Additional data types for the definition of text and spatial data d) Features to push processing to the database

You have successfully built a project you imported in the Web IDE workspace, but you cannot see the corresponding runtime database objects. What could be the reason? Please choose the correct answer. Response: A. The project is not assigned to a space B. You have the Developer role in the assigned space C. Building a project does not generate the database content of its HDB modules

C. Building a project does not generate the database content of its HDB modules

Which modeling features can you use in flowgraphs? There are 2 correct answers to this question. Response: A. Graph B. Spatial C. Text D. Predictive

B. Spatial | D. Predictive

Analyse Dependencies

Data Lineage | Impact analysis

Story Boards

SAP analysis for Office.

You can not enable a hierarchy for time dependency

Reason is Hierarchy is level type

Created table using the SQL console using SQL console inside the HDI Container(HANA Deployement Infrastructure). You export and reimport it with different project

Build is sucessfull but table is not present.

SAP hANA live views

/sap/hba

hierarchy having SQL access

shared with Star join view

SQL analyser

long running query

load more memory 1. eliminate indices 2. ZIP compression 3. dictionary compression 4. Col tables 5. Multicore CPU parallelism

1. eliminate indices 3. dictionary compression 4. Col tables

PAL necessarily needs

SAP HANA AFL

Sequence of deployment 1. Export the HDB module-> export the project 2. Build the project-> Build the HDB module 3. activate the project-> build the hdb module 4. build the hdb module -> build the project

2. Build the project-> Build the HDB modu

SAP HANA 2.0 Security

1. XS Advanced Security for e.g XSA service checks if you have role for WEB IDE for HANA and which SPACE. 2. DB security via roles.

WEB IDE interaction with DB

Technical user( Owners of corresponding schema and DB objects).

XSA user can have

1. Organisation | 2. SPACE->Manager , Auditor, Develper.

XSA by default SPACE , where most of the services resides.

SAP Space.

Can assign role to a user directly

Yes, but not a good practice.

Can explictly deny privileges

Catalogue Role

Transport-No Verson Management- No Owner- Creator

Design Time role

Transport-Yes Verson Management- Yes Owner- Technical user who owns the Container's content. HDBrole file using WEB IDE.

Use Case of Catalog role

When SAP HANA DB is managed by some other tool

XSA modelling

Design Time roles are recommeded

Types of Privileges

1. Object ( Select, Update, Call) 2. System ( Admin tasks). 3. Analytical Privileges.( Row level auth).

Not used in XSA

System | Application privileges.

Analytical Privileges

Classical - XML based - Not supportedby XSA | SQL based- XSA-

Create SQL based Analytical Privilege

1. Analytical Privilege creation wizard. 2. Assign Cal view to this privileges'( necessary). 3. Add restrictions. 4. Set CAL view to check Analytical privilege.'( necessary). 5. Save Analytical privilege. 6. Assign to role 7. role to user.

Restriction in Analytical privileges

1. Attribute.( e.g region is EMEA) 2. SQL Expression( e.g region is emea and year is 2021) 3. Dynamic ( for e.g using Procedure).

Dynamic restriction

1. proc read only 2. security mode : Definer 3. no input parameter 4. scalar

Possible error with building HANA view or Priveleges

1. If build a view , after activating the check for Analytical privileges, but no analytical privileges is having this view. 2. If you try to build the privileges , but some of the runtime cal view does not have apply priveleges.. 3. Try to activating the view by deactivating secure property however Runtime priveleges have this view in their secure models.

CDS view with analytical priviliges

@withstructuredprivilegecheck: true.

Object level Privileges | Hierarchy Node with Attribute restriction

Only available with 1. Cube with Star Join. 2. Only Parent Child Hierarchies are supported.

Object level Privileges

No Need to grant Select privileges on underlying tables or views. Top view select is only required( always)

Analytics priveleges

All level of hierarchy. | Generally on query level view.

Design type Roles types

1. Global Roles. 2. Schema Roles. 3. System Privileges 4. Schema privileges. 5. Object privileges 6. Schema Analytic privilges.

HDBroleconfigfile.

Resolve name of external schemas that are ref in HDBrole file,

With Grant Option

should always end with #, else build will fail and error is reported in the log.

Masking can be applied to

1. Tables( Row and Col tables). 2. SQL views. 3. Graphical views.

Allowed datatypes for col masking

1. Varchar. 2. Nvarchar. 3 Char 4. Short text.

Masked Privilege

1. Schema level. 2. Object level Necessary to have Select privilege on top layer.

Limitation on Masking

1 . Nesting of the cal views | 2. Calculated col use unmaked data.

Anon methods in HANA

``` K anonymity( grouping the similar dataset and the aggre) differential privacy( adding noise). ```

HA300- LEARNING Flashcards

(300 cards)