Data Modelling Quiz-4 Copy

Is it possible to hide a field and use it in the visualization?

Yes
No

Fields are hidden in the

Report tab
Data tab
Model tab
All the tabs

True
False

What option in the visual tab allows the user to store measures, columns calculated columns at one place?

Display folder
Synonym
Fields
Data category

What will allow the user to navigate through the data in powerbi?

Inheritance
Hierarchy
Filtering
Modelling

How to navigate general view of data to specific specific view in a visual?

Select the parameter on the visual and click drill down
Select the parameter on the visual and click drill through
Double click on the parameter
Right click the parameter and select click level up

Drillthrough feature

Navigates from lower levels of hierarchy to the higher levels of hierarchy
Navigates from one report to another while analysing the same set of data
Navigates from higher levels of hierarchy to the lower levels of hierarchy
Creates a report visual for all the tables present in the field menu

To view only the first level data in the hierarchial visual

Delete the hierarchy and create the visual for the first level data
Remove the next levels of the hierarchy from the axis tab
Right click the visual and select ignore hierarchy
Delete the next levels of the hierarchy from the fields section

Measure can be viewed in

Report tab
Model tab
Data tab
All the above

Which of the following is not a data model in power bi?

Entity relationship model
Network model
Hierarchical model
Inheritance model

How many views are there in the powerbi?

4
3
5
2

Measure provides aggregate values for multiple rows of the table?

True
False

How many types of tables are there in power bi?

3
2
4
5

Hierarchy can only be created from a single table

True
False

RELATED() function

Returns a value from the another table and this table need not be related to the present table
Returns a value from the another table and this table should be related to the present table
Can be used to fetch a column across limited relationship
None of these

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question