SAP HANA – Variables And Restricted Measures
Test your SAP HANA skills.
Good Luck !
Questions and Answers
- 1.
Variable are created and defined in the area named ________
- A.
Data Foundation
- B.
Output
- C.
Navigator
- D.
Quick Launch
Correct Answer
B. OutputExplanation
Variables are created and defined in the area named "Output". This area is where the final result or outcome of a program or function is displayed or stored. It is the section where the values of variables are printed or written to a file for further use or analysis.Rate this question:
-
- 2.
Filters are applied in ______
- A.
Output window
- B.
Navigator window
- C.
Quick Launch
- D.
Logical View
Correct Answer
D. Logical ViewExplanation
Filters are applied in the Logical View. The Logical View is a representation of the project structure that allows users to organize and navigate through the different components of the project. Filters can be applied to the Logical View to display only specific components based on certain criteria. This helps in managing large projects by allowing users to focus on relevant components and hide unnecessary ones.Rate this question:
-
- 3.
When defining variables, which of the following details are asked by the SAP HANA SP04 system ? (3 correct answers)
- A.
Variable name
- B.
Data type, lengths and scale
- C.
Attribute
- D.
Selection Type and default value
Correct Answer(s)
A. Variable name
C. Attribute
D. Selection Type and default valueExplanation
When defining variables in the SAP HANA SP04 system, the following details are asked: variable name, attribute, selection type, and default value. The variable name is necessary to identify the variable, while the attribute specifies the characteristics or properties of the variable. The selection type determines how the variable can be selected or filtered, and the default value is the initial value assigned to the variable if no other value is specified.Rate this question:
-
- 4.
When defining variables, which of the following details are asked by the SAP HANA SP02 system ? (3 correct answers)
- A.
Package name
- B.
Variable name
- C.
Data type, lengths and scale
- D.
Selection type without default value
Correct Answer(s)
B. Variable name
C. Data type, lengths and scale
D. Selection type without default valueExplanation
When defining variables in the SAP HANA SP02 system, the system asks for the variable name, data type, lengths and scale, and the selection type without default value. These details are necessary to properly define and use variables in the system. The package name is not mentioned as one of the details asked by the system, so it is not one of the correct answers.Rate this question:
-
- 5.
When defining Restricted Measure, which of the following details are asked by the system ? (2 correct answers)
- A.
Measure
- B.
Restrictions
- C.
Server name
- D.
Package name
Correct Answer(s)
A. Measure
B. RestrictionsExplanation
The system asks for the details of Measure and Restrictions when defining Restricted Measure. The Measure refers to the specific metric or parameter that needs to be measured or restricted, while Restrictions refer to the specific limitations or conditions that need to be applied to the Measure. The system requires this information in order to accurately define and implement the Restricted Measure.Rate this question:
-
- 6.
1. In SAP HANA SP04 when saving and activating a view, a new window named “Activate” opens and we can select multiple views from the left box to move to the right box and activate. 2. This is same in SAP HANA SP02 as well.
- A.
The first statement is correct and not the second
- B.
The second statement is correct and not the first
- C.
Both statements are correct
- D.
Both statements are wrong
Correct Answer
A. The first statement is correct and not the secondExplanation
The explanation for the given correct answer is that the first statement is correct and not the second because it states that in SAP HANA SP04, when saving and activating a view, a new window named "Activate" opens and allows the selection of multiple views to be moved to the right box and activated. The second statement contradicts this by stating that the same feature is available in SAP HANA SP02, which is incorrect. Therefore, only the first statement is correct.Rate this question:
-
- 7.
Which of the following statement is correct ?
- A.
Restricted measures can be used to restrict the output based on a fact.
- B.
The screen used to define Restricted Measures in not the same in SAP HANA SP02 and SP04.
- C.
Restricted measures can be used to restrict the output based on an attribute.
- D.
We cannot add restrictions while defining the Restricted Measures.
Correct Answer
C. Restricted measures can be used to restrict the output based on an attribute.Explanation
The correct answer is "Restricted measures can be used to restrict the output based on an attribute." This statement accurately describes the functionality of restricted measures in SAP HANA. Restricted measures allow users to apply restrictions or filters on the output based on specific attributes or conditions. This helps in narrowing down the data and focusing on specific subsets of information.Rate this question:
-
- 8.
Which of the following statement is correct ?
- A.
Restricted Measures can be created for Attribute Views.
- B.
Restricted Measures can be created for Analytic Views.
- C.
Restricted Measures can be created for tables.
- D.
All of the above are correct.
Correct Answer
B. Restricted Measures can be created for Analytic Views.Explanation
Restricted Measures can be created for Analytic Views. This means that in SAP HANA, it is possible to define restricted measures, which are calculated measures based on specific conditions or filters, within an analytic view. These restricted measures allow for more advanced and customized calculations to be performed on the data within the analytic view.Rate this question:
-
- 9.
Restricted Measures, once created cannot be changed.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Restricted Measures can be changed after they are created. Restricted Measures are a feature in certain software or systems that allow administrators to set limitations or restrictions on certain actions or behaviors. These restrictions can be modified or updated as needed by the administrators. Therefore, the statement that Restricted Measures cannot be changed is false.Rate this question:
-
- 10.
We can create Restricted Views in the Quick Launch Window.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Restricted Views cannot be created in the Quick Launch Window. The Quick Launch Window is used to display links to lists, libraries, and other content within a SharePoint site. It does not have the capability to create restricted views, which are typically used to limit access or filter data within a list or library. Therefore, the correct answer is False.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 13, 2012Quiz Created by
Uwinpro
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top