HA300- LEARNING Flashcards

1
Q

Valid partition types

A

HASH , RANGE, ROUND ROBIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Table Type

A
  1. Row
  2. Col
  3. History
  4. Global temp
  5. Local temp
  6. Virtual
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Multi Join

A
  1. > 2.0
  2. Inside Out
  3. Outside In.
  4. Central Table
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Partition

A
  1. Hash
  2. Round Robin
  3. Range
    - > No Need not to drop a table
    - > Can not Partition on Row Store.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Full Outer Join

A
  1. Supported by Calculation view only

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Union Node Pruning

A

Union Node Pruning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

SDA (Smart Data Access) can be used for?

A

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?
1
Not at all
2
3
4
5
Perfectly
8
Q

What technology uses log based real time replication?

A

SRS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which Data Provisioning technologies use batch replication?

A

) SDI

2) SDQ
3) DS
4) DXC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is loaded into memory when tables are accessed?

A

Only columns and partitions required by the application.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

1) Customer brings the licensed Software

2) SAP Manages the Infrastructure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Modeling Best Practice. Pt. 1

A

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?
1
Not at all
2
3
4
5
Perfectly
13
Q

Modeling Best Practice. Pt. 2

A

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?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the different SAP HANA Cloud Managed Services?

A

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?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is transparent Filter used for?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What must I create to develop a predictive model?

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

A

Answer is b) Flowgraph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

b. Improved data reading performance

c. Improved compression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

b. reuse views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

a. number of records returned in each step

c. time taken for each step

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

a. from the join nodes up to the semantic node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q
  1. 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.

A

d. you can loop through records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

a. it offers a simplified landscape

d. there is no data movement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

a. ESRI Shapefiles

d. Well- Known Text (WKT)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

d. insert- only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

a. aggregation note

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

d. In- memory technology and multicore CPUs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

d. ST_MultiPoint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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

A

c. Self- Join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

A

b. SAP Web IDE for SAP HANA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

c. Lazy Load

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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

a. R

b. SQL Script

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

a. Store green as an attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

a. column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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

A

b) In a Projection node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

b) Shared hierarchies in a star join view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

A

c) An analytic privilege on both calculation views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

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

A

d) Temporal Join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

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

A

d) SAP HANA AFL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

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.

A

b. the function must be of the type scalar

d. the generated value can be overwritten at run time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

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.

A

c. to identify the longest running SQL statements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

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)

A

c. Data Distribution Optimizer (DDO)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

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

a) From the underlying dimension views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

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

A

b) Multi-target application

c) SAP HANA database module

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

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

A

b. in a projection node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

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

A

b. SAP HANA as a reporting server

c. SAP HANA as a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q
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)
A

c. managed cloud as a service (MCaaS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q
  1. 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.
A

c) When referential integrity is assured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q
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
A

b. calculation views
c. procedures
d. analytic privileges

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q
  1. 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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q
  1. 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

a) SAP Analysis for Microsoft Office

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q
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
A

b) Delta storage

d) Main storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q
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
A

c. a flowgraph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q
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

a) SDA

c) SDI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q
  1. 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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q
  1. 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.
A

b. They are static values

d. They are based on the ABAP Data Dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q
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

a) ABAP CDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q
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
A

b. in the semantics node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q
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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q
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

a) SAP Enterprise Architecture Designer

d) Core Data Services (CDS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q
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

a) Core Data Services

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q
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

a) Procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
66
Q
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
A

c) SCORE()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
67
Q
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
A

d) Extended storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
68
Q
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
A

b. in the SAP HANA database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
69
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
70
Q
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
A

b) Virtual data modeling

d) Persistence layer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
71
Q
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
A

b) Apache Spark

d) Apache Hadoop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
72
Q

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

A

c) To access data from a classic database schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
73
Q

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

A

d) Calculation views of data category cube without star join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
74
Q
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

a) Referential joins

c) Spatial joins

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
75
Q

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.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
76
Q

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

A

d) In the semantic layer of the calculation view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
77
Q
What paradigm describes the SQL language?
Please choose the answer.
a) Application-focused
b) Object-oriented
c) Set-oriented
d) Procedural
A

c) Set-oriented

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
78
Q
What are components of SAP HANA EIM?
There are 2 answers to this question.
a) SDI
b) SDQ
c) SDA
d) SDS
A

a) SDI

b) SDQ

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
79
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
80
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
81
Q
What statement is allowed in a user-defined function?
Please choose the answer.
a) INSERT
b) JOIN
c) EXEC
d) COMMIT
A

b) JOIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
82
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
83
Q
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

a) Cypher Query Language

b) GraphScript

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
84
Q
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
A

b) Union node

d) Projection node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
85
Q

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

a) Use of standby servers in the event of hardware failure.

b) Use of multiple servers to spread processing and improve performance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
86
Q
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
A

d) Consumption views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
87
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
88
Q

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

A

c) Enable drilldown in a value help list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
89
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
90
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
91
Q
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

a) Variable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
92
Q
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
A

c. SAP HANA Live Browser

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
93
Q

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

a. Repository of ready-made predictive algorithms

c. Repository of ready-made business functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
94
Q
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
A

c. measures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
95
Q
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
A

b) SAP Lumira, designer edition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
96
Q
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

a) It’s a column in the result set.

c) It’s created in the output area.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
97
Q
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
A

d) Synonym

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
98
Q
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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
99
Q

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.

A

c. Create a filter expression

d. Create a restricted column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
100
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
101
Q
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
A

c) SAP Business Suite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
102
Q
To what subset of SQL does the SELECT statement belong?
Please choose the answer.
a) DCL
b) DQL
c) DML
d) DDL
A

b) DQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
103
Q
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
A

d) Apriori

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
104
Q

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

A

b) The build of the entire HDB module is successful

c) The build of Model A is successful

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
105
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
106
Q
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

a. SAP HANA Live

c. SAP HANA as a platform

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
107
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
108
Q

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

A

d. BW models combined with native SAP HANA models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
109
Q
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

a) SAP Lumira, discovery edition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
110
Q
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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
111
Q
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
A

b. development

d. database explorer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
112
Q
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) A view with a restricted column

d) A SQL analytic privilege

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
113
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
114
Q

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

A

b) Select a space for running the project

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
115
Q
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

a) Data volume

c) Log area

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
116
Q
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
A

c) Multicore processors

d) Larger and cheaper memory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
117
Q

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

A

b) TEXT ANALYSIS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
118
Q

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.

A

b) Use a spatial join to find the distance between clinics.

Use an aggregation with the maximum option.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
119
Q

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

A

b) Calculation view of type cube

c) Calculation view of type cube with star join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
120
Q
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

a) Level hierarchy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
121
Q

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.

A

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

122
Q
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

a. EXEC

c. SELECT

123
Q
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

a) Scalar function

124
Q

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

A

c) SAP Crystal Reports for Enterprise

125
Q
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

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

126
Q

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

A

b. to implement micro- services architecture

c. to move to Cloud Foundry architecture to allow flexible application deployment options

127
Q

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

A

c) To increase parallelization opportunities

d) To improve code readability

128
Q
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
A

b) Procedure

129
Q
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
A

b. data loading performance

c. reporting performance

130
Q
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
A

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

131
Q
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
A

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

132
Q
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

a. read- optimized

133
Q
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
A

c) Range

134
Q

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

a) SAP Vora
b) SDA
d) SDI

135
Q

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

a) Always as the bottom (leaf) node

136
Q

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

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

137
Q

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

A

b) Set the Empty Union Behavior property.

138
Q

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

A

c. real-time

d. duplicate data

139
Q
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
A

b) SDQ

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

b) GROUP BY

141
Q
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

a) Transactional

c) OLTP

142
Q
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
A

c) Union node

143
Q
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
A

c. data preparation functions

d. predictive algorithms

144
Q
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
A

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

145
Q
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

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

146
Q

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

A

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

147
Q
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
A

b) .hdbflowgraph

148
Q
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
A

c) Multitenant Database Containers (MDC)

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

a) Procedure

150
Q
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
A

b) Value help
c) Input parameters
e) Variables

151
Q
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
A

c. Transaction Manager

d. Synchronous

152
Q
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

a) 2

153
Q
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
A

c) Union

154
Q
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.
A

c) They can use imperative logic.

155
Q
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
A

d) Text analysis

156
Q

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

A

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

157
Q
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
A

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

158
Q

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

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.

159
Q

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

A

c) Calculation view of type cube with star join

160
Q
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
A

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

161
Q

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

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

162
Q
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
A

c. trace and log files

d. SQL Plan Cache

163
Q

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

A

b) CONTAINS

164
Q

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

A

b) Rank node

165
Q

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

A

c. if you need to insert records into a table

d. if you need a mixture of scalar and tabular output parameters

166
Q

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

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

167
Q

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

A

c) A native, lightweight application server

168
Q
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
A

d) Kerberos authentication

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

d) Multistore tables

170
Q
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
A

b) SAP S/4HANA

171
Q
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

a) SAP HANA Studio development perspective

c) Web IDE for SAP HANA

172
Q

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

A

c. roles to roles

d. roles to users

173
Q

What does the C in ACID-compliant stand for?

a) Complete
b) Consistency
c) Complexity
d) Constant

A

b) Consistency

174
Q

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.

A

b) You did NOT enable the Keep Flag.

175
Q

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

A

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

176
Q

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

A

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

177
Q

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. 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

178
Q

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

A

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

179
Q

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

A

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

180
Q

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

A

c) Point

181
Q

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

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

182
Q

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

A

c) Star join node

183
Q

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

A

d. a tool to support the build logical data model

184
Q

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

A

b. MDX
d. BICS
e. ODBO

185
Q

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)

A

c. : (colon)

186
Q

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

a) Analytic Privilege
b) Calculation View
d) Flowgraph

187
Q

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

a) Value help views

d) Query views

188
Q

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

A

d. using SAP Business Objects Enterprise platform web service

189
Q

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

A

c. you can dynamically change your data sources

d. it could be used for SQL injection

190
Q

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.

A

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

191
Q

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

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

192
Q

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

a. hash
b. round- robin
e. range

193
Q

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.

A

b. it acts based on combinations of events

194
Q

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

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

195
Q

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

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

196
Q

Where is SDI used?

There are 2 answers to this question.

a) Data loading
b) Data transformation
c) Data streaming
d) Data cleaning

A

a. data loading

b. data transformation

197
Q

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

A

d. SAP HANA Data Warehousing foundation

198
Q
  1. 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
A

c) Aggregation Function: Row

Result Set Type: Percentage

199
Q
  1. 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.
A

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

200
Q
  1. 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

A

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

201
Q
  1. 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

A

c) To enable lower memory consumption

202
Q
  1. 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

A

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

203
Q

AFL (Application Function Library) include what?

A

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

204
Q

Deployment Scenarios for SAP HANA Live

A

Side-by-side (side car) and Integrated

205
Q

What are the properties of the Delta Store?

A

Write Optimized with Unsorted Data.

206
Q

What are the properties of the Main Store?

A

Read Optimized and Unsorted Data.

207
Q

What are the available Cloud versions for SAP HANA?

A

1) HEC (HANA Enterprise Cloud)

2) HCP (HANA Cloud Platform)

208
Q

What is the Tailored Data Integration choice of deployment?

A

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

209
Q

How do you activate someone else’s Calculation View?

A

REPO_WORK_IN_FOREIGN_WORKSPACE

210
Q

What can you convert using the Migrate Utility?

A

Classical Analytical Privileges to SQL Analytical Privileges.

211
Q

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

A

1

212
Q

Analytical Privileges are applicable to what type of views?

A

Calculation Views

213
Q

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

A

Table Type

214
Q

What are some procedure languages?

A

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

215
Q

What are the properties of a Table Function?

A

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

216
Q

What can Table Types be used for?

A

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

217
Q

What information could be found in Performance Analysis mode?

A

1) Number of Rows

2) Partitions

218
Q

What information could be found in Explain Plan?

A

1) Estimated Execution Time

2) Engines Used

219
Q

What could improve SQL performance?

A

Using Multi-level Aggregation whenever possible.

2) Use variables to use parallelization so SQL steps are run independently.

220
Q

When processing Variables what is recommended?

A

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

221
Q

What is the purpose of the Delta Store column table?

A

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

222
Q

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

A

Tables and Graphical Calculation Views.

223
Q

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

A

Schema Mapping.

224
Q

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

A

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

225
Q

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

A

Pruning.

226
Q

How much memory does a Fuzzy Search require?

A

10%

227
Q

Which PAL Algorithm could be used for determining delayed flights?

A

Classification

228
Q

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

A

) Point

2) Line
3) Polygon

229
Q

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

A

Decision Tree

230
Q

What does the Fuzziness Threshold do

A

It allows you to create search parameters.

231
Q

What is Fuzzy Search scoring?

A

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

232
Q

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

A

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

233
Q

What formats are supported for Geospatial data?

A

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

234
Q

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

A

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

235
Q

What input parameters would you use for currency?

A

VARCAHR (Variable Character)

236
Q

What is the outcome of activating a decision table?

A

A procedure is created

237
Q

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

A

Direct input type

238
Q

Which semantic types could you use with direct input parameters?

A

Date and Unit of Measure

239
Q

Which of the following is used to handle Orphan nodes?

A

Error, Ignore and Step Parent.

240
Q

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

A

Loading and Reporting Performance.

241
Q

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

A

1) SLT
2) SRS
3) SDS

242
Q

SDA (Smart Data Access) can be used for?

A

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

243
Q

What technology uses trigger based real-time replication?

A

SLT

244
Q

What technology uses log based real time replication?

A

SRS

245
Q

Which adaptors are available for RT (Real-time)

A

Twitter, ECC (ERP) and Log Reader

246
Q

Which Data Provisioning technologies use batch replication?

A

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

247
Q

What is loaded into memory when tables are accessed?

A

Only columns and partitions required by the application.

248
Q

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

A

1) Customer brings the licensed Software

2) SAP Manages the Infrastructure

249
Q

Modeling Best Practice. Pt. 1

A

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)

250
Q

Modeling Best Practice. Pt. 2

A

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.

251
Q

What is _SYS_REPO?

A

_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.

252
Q

What is _SYS_BIC?

A

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.

253
Q

What are the different SAP HANA Cloud Managed Services?

A

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)

254
Q

What is transparent Filter used for?

A

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

255
Q
  1. 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
A

c) SAP Data Services

d) SAP HANA smart data integration

256
Q
  1. 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
A

b) Underlying calculation views and tables

257
Q
  1. 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.
A

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

258
Q
  1. 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
A

c) To enable lower memory consumption

259
Q
  1. 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
A

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

260
Q

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

A

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

261
Q

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

A

B. Spatial

D. Predictive

262
Q

Analyse Dependencies

A

Data Lineage

Impact analysis

263
Q

Story Boards

A

SAP analysis for Office.

264
Q

You can not enable a hierarchy for time dependency

A

Reason is Hierarchy is level type

265
Q

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

A

Build is sucessfull but table is not present.

266
Q

SAP hANA live views

A

/sap/hba

267
Q

hierarchy having SQL access

A

shared with Star join view

268
Q

SQL analyser

A

long running query

269
Q

load more memory

  1. eliminate indices
  2. ZIP compression
  3. dictionary compression
  4. Col tables
  5. Multicore CPU parallelism
A
  1. eliminate indices
  2. dictionary compression
  3. Col tables
270
Q

PAL necessarily needs

A

SAP HANA AFL

271
Q

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
A
  1. Build the project-> Build the HDB modu
272
Q

SAP HANA 2.0 Security

A
  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.
273
Q

WEB IDE interaction with DB

A

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

274
Q

XSA user can have

A
  1. Organisation

2. SPACE->Manager , Auditor, Develper.

275
Q

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

A

SAP Space.

276
Q

Can assign role to a user directly

A

Yes, but not a good practice.

277
Q

Can explictly deny privileges

A

No

278
Q

Catalogue Role

A

Transport-No
Verson Management- No
Owner- Creator

279
Q

Design Time role

A

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

280
Q

Use Case of Catalog role

A

When SAP HANA DB is managed by some other tool

281
Q

XSA modelling

A

Design Time roles are recommeded

282
Q

Types of Privileges

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

Not used in XSA

A

System

Application privileges.

284
Q

Analytical Privileges

A

Classical - XML based - Not supportedby XSA

SQL based- XSA-

285
Q

Create SQL based Analytical Privilege

A
  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.
286
Q

Restriction in Analytical privileges

A
  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).
287
Q

Dynamic restriction

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

Possible error with building HANA view or Priveleges

A
  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.
289
Q

CDS view with analytical priviliges

A

@withstructuredprivilegecheck: true.

290
Q

Object level Privileges

Hierarchy Node with Attribute restriction

A

Only available with

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

Object level Privileges

A

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

292
Q

Analytics priveleges

A

All level of hierarchy.

Generally on query level view.

293
Q

Design type Roles types

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

HDBroleconfigfile.

A

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

295
Q

With Grant Option

A

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

296
Q

Masking can be applied to

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

Allowed datatypes for col masking

A
  1. Varchar.
  2. Nvarchar.
    3 Char
  3. Short text.
298
Q

Masked Privilege

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

Limitation on Masking

A

1 . Nesting of the cal views

2. Calculated col use unmaked data.

300
Q

Anon methods in HANA

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