Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAP > HANA300 Training Questions > Flashcards

HANA300 Training Questions Flashcards

1
Q

In a level hierarchy, how are levels defined?
* By choosing a parent node followed by a sequence of child nodes to create a drill down order
* By defining an explicit sort sequence of specific values chosen from a single column
* By specifying the columns in a hierarchy table that should be available for drill down
* By selecting at least two columns that are available in the semantic node and placing them in the desired drill down sequence

A
  • By selecting at least two columns that are available in the semantic node and placing them in the desired drill down sequence
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a parent child hierarchy?
* A continual hierarchy formed by linking multiple hierarchies
* A hierarchy formed by selecting two columns and assigning them to the role of parent or child
* A hierarchy that is formed by selecting specific the values of a column and assigning the values to the role of parent or child
* The assignment of hierarchy nodes to the roles of parent or child

A
  • A hierarchy formed by selecting two columns and assigning them to the role of parent or child
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

When defining a new restricted column based on the attributes from two separate columns, what is the logic used for the two columns?
* AND
* OR

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

Which are valid methods for filtering data in a calculation view?
* Create a filter expression on a table column
* Mark columns as hidden in the semantic layer
* Define a variable
* Create a lookup table and use an inner join to select valid values

A
  • Create a filter expression on a table column
  • Define a variable
  • Create a lookup table and use an inner join to select valid values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which statements are true regarding Input Parameters?
* They are always bound to a single attribute of a calculation view
* They can be used in expressions
* Value help lists can be assigned to prompt for valid values
* Technically they result in a WHERE clause in the generated SQL

A
  • They can be used in expressions
  • Value help lists can be assigned to prompt for valid values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which statements are true regarding variables?
* A variable is used to filter the data set by attribute values
* A variable value cannot be empty, a user must always provide an input
* A variable can be assigned to multiple attributes
* Variables can be used in calculated column expression
* A variable generates a WHERE clause in SQL

A
  • A variable is used to filter the data set by attribute values
  • A variable can be assigned to multiple attributes
  • A variable generates a WHERE clause in SQL
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Why do I map my variables?
* To push down filters to lower calculation views in the stack
* So it is easy to identify in which calculation views they are used
* So a value entered in one variable can be used to restrict values available in the next variable

A
  • To push down filters to lower calculation views in the stack
  • So a value entered in one variable can be used to restrict values available in the next variable
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Why do I implement a hierarchy function?
* To drill down hierarchically using a reporting tool
* To calculate all ancestors in a hierarchy
* To identify nodes that have no parent

A
  • To calculate all ancestors in a hierarchy
  • To identify nodes that have no parent
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following are types of calculation views?
Choose the correct answers.
A Cube
B Composite
C Cube with star join
D Dimension

A

A Cube
C Cube with star join
D Dimension

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

A dimension can have attributes and measures.
Determine whether this statement is true or false.

True

False

A

False

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

Which are true statements relating to calculation views of the type SQL access only?
Choose the correct answers.
A They do not expose their meta data to reporting tools
B They are mainly used for reusing inside other calculation views
C They must include at least one measure
D They include a star join node

A

A They do not expose their meta data to reporting tools
B They are mainly used for reusing inside other calculation views

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

Which are supported data sources for calculation view consumption?
Choose the correct answers.
A Calculation views
B Flat files
C Virtual tables
D Column tables
E Row tables

A

A Calculation views
C Virtual tables
D Column tables
E Row tables

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

What does SAP recommend you use to check your calculation view produces correct result?
Choose the correct answer.
A Excel pivot tables
B Custom SQL queries using SQL Console
C Data preview function in the SAP Web IDE for SAP HANA

A

B Custom SQL queries using SQL Console

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

In a calculation view, which are valid output column types?
Choose the correct answers.
A Measure
B Attribute
C Dimension
D Cube

A

A Measure
B Attribute

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

Why do you hide columns in a dimension calculation view?
Choose the correct answer.
A When you want to hide a column that is not required or allowed for client consumption.
B When you do not want to expose a sensitive column to a consuming calculation view.
C To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.

A

A When you want to hide a column that is not required or allowed for client consumption.

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

What is the purpose of the Projection node?
Choose the correct answers.
A To apply filters on the data
B To extract only the required columns from a data source
C To aggregate measures
D To join data sources

A

A To apply filters on the data
B To extract only the required columns from a data source

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

Why do you use a Referential Join?
Choose the correct answer.
A To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.
B When you need to display only facts that have associated master data attributes.
C When you want to display facts even when the associated master data attributes are missing.

A

A To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.

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

A Text Join is a Right Outer Join used to join a text table containing multi-language descriptions, to an attribute in a dimension.
Determine whether this statement is true or false.

True

False

A

False - A Text Join is a Left Outer Join used to join a text table containing multi-language descriptions, to an attribute in a dimension.

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

Identify the type of join that ensures records are only selected if they fit within a specified date range.
Choose the correct answer.
A Left Outer Join
B Right Outer Join
C Temporal Join
D Full Outer Join

A

C Temporal Join

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

In a union, you do not have to select all source columns and the source columns do not have to have the same name.
Determine whether this statement is true or false.

True

False

A

True

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

You have customers who appear in table A and sometimes they also appear in table B. You want to select the customers that appear ONLY in table A. Which node type do you use?
Choose the correct answer.
A Intersect
B Minus
C Union

A

B Minus

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

In an Aggregation node, a calculated column is always computed before the aggregate function.
Determine whether this statement is true or false.

True

False

A

False - In an Aggregation node, a calculated column is always computed after the aggregate function.

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

Which flags are relevant to the control of the aggregation behavior?
Choose the correct answers.
A Keep Flag
B Transparent filter
C Dynamic join

A

A Keep Flag
B Transparent filter

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

In a Star Join node, what do you join to the central entity (fact table)?
Choose the correct answer.
A CUBE calculation views
B Column tables
C DIMENSION calculation views

A

C DIMENSION calculation views

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

Which are three valid aggregation functions for a rank node?
Choose the correct answers.
A Row
B Rank
C Sum
D Sort

A

A Row
B Rank
C Sum

26
Q

A restricted column provides a subset of the original column filtered by attribute values.
Determine whether this statement is true or false.

True

False

A

True

27
Q

When is the filter expression applied in a calculation view?
Choose the correct answers.
A Before a query on the calculation view begins to execute
B On the final result of a query, similar to a ‘where’ clause
C Before any joins are executed within the calculation view

A

A Before a query on the calculation view begins to execute
C Before any joins are executed within the calculation view

28
Q

When the Default Client property of a calculation view is set to Session Client, the data is filtered dynamically based on the CLIENT assigned to the user.
Determine whether this statement is true or false.

True

False

A

True

29
Q

Why do you use a variable?
Choose the correct answer.
A To provide a missing value to a formula
B To filter results

A

B To filter results

30
Q

In a hierarchy, what is an orphan node?
Choose the correct answer.
A A node that has no parent node
B A node that has no child nodes
C A node that contains only one member

A

A A node that has no parent node

31
Q

What are two types of modeled hierarchy you can create using calculation views?
Choose the correct answers.
A Parent-Child
B Referential
C Level

A

A Parent-Child
C Level

32
Q

While converting currencies, in addition to source and target currencies, which is also needed?
Choose the correct answer.
A Date
B Country
C VAT rate

A

A Date

33
Q

What is a time-based dimension calculation view?
Choose the correct answer.
A A view that is only accessible by users for a limited time
B A view that stores the values of attributes across time

A

B A view that stores the values of attributes across time

34
Q

Why is knowledge of SQL important to an SAP HANA modeler?
Choose the correct answers.
A So that they can choose to create calculation views using only SQL language
B So that they can understand how to implement a function or procedure and consume this within a calculation view
C So that they can extend the capabilities of a calculation view using SQL expressions

A

B So that they can understand how to implement a function or procedure and consume this within a calculation view
C So that they can extend the capabilities of a calculation view using SQL expressions

35
Q

You are using the SQL console of the Web IDE. When are schema references not required in your SQL?
Choose the correct answer.
A When writing SQL against a database connection of the type HDI Container
B When writing SQL against a database connection of the type SAP HANA Database.

A

A When writing SQL against a database connection of the type HDI Container

36
Q

Why should I define my SAP HANA tables using source files rather than using the SQL statement ‘CREATE TABLE’ in the SQL Console of Web IDE?
Choose the correct answer.
A The syntax is simpler
B Performance of the table is better.
C The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together.

A

C The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together.

37
Q

Which are valid source file types used to define the persistence layer of SAP HANA?
Choose the correct answers.
A.hdbtable
B.sqltable
C.hdbdropcreatetable

A

A.hdbtable
C.hdbdropcreatetable

38
Q

What types of user-defined SQL functions can you include as a data source in a calculation view?
Choose the correct answers.
A Table Functions
B Column Engine Functions
C Scalar Functions

A

A Table Functions

39
Q

Why would you use SQL functions when modeling in calculation views?
Choose the correct answer.
A As an alternative to developing a graphical calculation view when you prefer to use script
B When you need to write results back to a table from a calculation view
C When you need to define custom data processing logic that the graphical calculation view cannot provide

A

C When you need to define custom data processing logic that the graphical calculation view cannot provide

40
Q

SAP recommends always create tables using SQL statements in the SQL console.
Determine whether this statement is true or false.

True

False

A

False - You should avoid creating tables using SQL statements and instead define the tables using source files as part of your development project.

41
Q

Which is the source file type that you use to load a table?
Choose the correct answer.
A.hdbtable
B.hdbdropcreatetable
C.hdbtabledata

A

C.hdbtabledata

42
Q

Virtual tables usually provide superior performance compared to standard tables.
Determine whether this statement is true or false.

True

False

A

False - Compared to standard tables, virtual tables are not expected to perform as well due to source the data being located outside of SAP HANA database.

43
Q

Why would you define a pruning configuration table?
Choose the correct answer.
A To define the conditions that determine when a complete data source can be pruned from a union.
B To define the optimal path that should be used to prune data sources from a union .

A

A To define the conditions that determine when a complete data source can be pruned from a union.

44
Q

Which type of node is used to end the parallelization of a data flow?
Choose the correct answer.
A Projection
B Union
C Aggregation

A

B Union

45
Q

To work with calculation view debug query, you first need to build the calculation view?
Determine whether this statement is true or false.

True

False

A

True

46
Q

What is the purpose of the SQL Analyzer?
Choose the correct answers.
A To identify the longest running SQL statements.
B To investigate the generated SQL for each node in my calculation view.
C To highlight syntax errors in my SQL code.

A

A To identify the longest running SQL statements.

47
Q

Which are valid table partition types in SAP HANA?
Choose the correct answers.
A Range
B Hash
C Round Robin
D Column

A

A Range
B Hash
C Round Robin

48
Q

To which storage tier does Native Store Extension (NSE) belong?
Choose the correct answer.
A Cold
B Hot
C Warm

A

C Warm

49
Q

Which of the following tools is used to analyze dependencies between models?
Choose the correct answers.
A Data lineage
B Column lineage
C Impact analysis

A

A Data lineage
C Impact analysis

50
Q

In a full stack application development project using Web IDE XS Advanced, which are provided by an HDB module?
Choose the correct answers.
A Persistence layer
B User interface
C Business logic
D Data modeling layer

A

A Persistence layer
D Data modeling layer

51
Q

An XS Advanced project can contain multiple HDB modules.
Determine whether this statement is true or false.

True

False

A

True

52
Q

The database objects defined in design-time files located in the same project folder can have different namespaces.
Determine whether this statement is true or false.

True

False

A

False - The rules defining namespaces are defined at the folder level (at any level of the folder structure). This means all database objects created within a folder always inherit the same namespace provided by the folder.

53
Q

A HDB module always corresponds to a physical database schema.
Determine whether this statement is true or false.

True

False

A

True

54
Q

You have successfully built a project that you imported into the SAP Web IDE workspace, but you cannot see the corresponding runtime database objects in the Database Explorer. What could be the reason?
Choose the correct answer.
A The project is not assigned to a Space.
B Building a project does not generate the database objects defined in its HDB modules.
C You do not have the Developer role in the assigned Space.

A

B Building a project does not generate the database objects defined in its HDB modules.

55
Q

A calculation view CV1 has been created in your project folder but has never been built. Your perform a build of another calculation view CV2 that consumes CV1. The CV1 file will be included in the build of CV2.
Determine whether this statement is true or false.

True

False

A

False - A design-time file that has never been built is ignored by the dependency check performed by the HDI builder if it is not part of the build scope.

56
Q

Which database artifact do you use to access external data that is outside your project?
Choose the correct answer.
A Calculation view
B Synonym
C Logical schema
D User-provided service

A

B Synonym

57
Q

The Git architecture relies on a central server that stores a unique version of your source code and includes a check-out process that prevents several users from modifying the same source file at the same time.
Determine whether this statement is true or false.

True

False

A

False - The Git architecture is not centralized but distributed, which means that several contributors to a project can have the complete project code on their own computer. There is no check-in / check-out process, compared with other types of control-version systems.

58
Q

What is a dynamic analytic privilege?
Choose the correct answer.
A A reusable analytic privilege that can be used for several users who need to access different data.
B An analytic privilege that takes its filter values from variables defined in the calculation view
C A temporary analytic privilege that has a defined time validity set for its use

A

A A reusable analytic privilege that can be used for several users who need to access different data.

59
Q

What is data masking?
Choose the correct answer.
A Obscuring column values by hiding some or all characters with replacement characters
B Replacing column values with a higher level group such as replacing a person id with team name
C Removing complete rows of data that should not be seen by users

A

A Obscuring column values by hiding some or all characters with replacement characters

60
Q

Why do you implement data anonymization?
Choose the correct answer.
A To hide sensitive data using alternative characters such as ‘XXXXX’.
B To hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed.
C To remove complete records so that they cannot be seen by unauthorized users

A

B To hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed.

SAP (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions