Power BI Interview Preparation

Quiz Summary

0 of 30 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 30 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 30

1. Question
BI stands for
- Business Information
- Business Intelligence
- Business Insider
- Business Initiation
Correct

Incorrect
Question 2 of 30

2. Question
The principal arrival of Power BI depended on the
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Microsoft Outlook
Correct

Incorrect
Question 3 of 30

3. Question
The Power BI portable application is accessible for all these with the exception of.
- IOS
- Android
- BlackBerry
- Windows Phone
Correct

Incorrect
Question 4 of 30

4. Question
What area do you go to change and reshape data in Power BI?
- Data Transformation
- Data Editing
- Question Editor
- Data Modelling
Correct

Incorrect
Question 5 of 30

5. Question
Which isn’t a data compose in Power BI?
- General
- Decimal Number
- Date
- Double
Correct

Incorrect
Question 6 of 30

6. Question
What do you use to consolidate inquiries in Power BI?
- Join Queries
- Union Queries
- There is no alternative
- None of these
Correct

Incorrect
Question 7 of 30

7. Question
In the recipe Total Cost = Sum(‘Fact'[Cost]), what kind of computation should Total Cost be according to best practice?
- Ascertained section
- Measure
- Variable
- None of these
Correct

Incorrect
Question 8 of 30

8. Question
What visual would you use to show a solitary esteem?
- Framework
- Disseminate Plot
- Card
- Table
Correct

Incorrect
Question 9 of 30

9. Question
What is the common flow of activity in Power BI?
- Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.
- Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
- Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.
- Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.
Correct

Incorrect
Question 10 of 30

10. Question
What are the three basic elements of Power BI?
- Power BI Desktop, Power BI Report Server, Power BI Service
- Power BI Desktop, Power BI Service, Power BI Mobile
- Power BI Service, Power BI Mobile, Power BI Report Builder
- Power BI Report Server, Power BI Report Builder, Power BI Service
Correct

Incorrect
Question 11 of 30

11. Question
Sometimes when analyzing data we may use our dimensions as a measure to understand values like no. of instances, average pricing or maximum price
- False
- True
- Insufficient data
- None of these
Correct

Incorrect
Question 12 of 30

12. Question
The MAP chart is a useful visualization to show locations of cities and countries with bubbles to indicate the size of the data points.
- False
- True
- Insufficient data
- None of these
Correct

Incorrect
Question 13 of 30

13. Question
The selected view in the image is where we edit the relationships between tables
- False
- True
- Insufficient data
- None of these
Correct

Incorrect
Question 14 of 30

14. Question
A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be
- Many to One
- One to Many
- Many to Many
- One to One
Correct

Incorrect
Question 15 of 30

15. Question
To enable two tables to be joined. A unique key between the 2 tables is required. For example between the customer table and the sales table. The key would be customer ID.
- True
- False
- Insufficient data
- None of these
Correct

Incorrect
Question 16 of 30

16. Question
Which of the following illustrates a Many to One relationship?
- 1 banana tree having many bananas on the tree
- Many banana trees planted in more than 1 garden
- Many banana trees planted in a garden
- Many gardens having no banana trees
Correct

Incorrect
Question 17 of 30

17. Question
In the data view, we are able to view the tables that we have imported. Each table shown is from a specific excel worksheet.
- True
- False
- Insufficient data
- None of these
Correct

Incorrect
Question 18 of 30

18. Question
A function that can only work on numeric fields is
- AND
- ISNUMBER
- AVERAGE
- CONCATENATE
Correct

Incorrect
Question 19 of 30

19. Question
What are the different views in Power BI Desktop?
- Report View, Data View, Relationship View
- Data View, Draft View, Canvas View
- Data view, Relationship View, Canvas View
- Report View, Relationship View, Draft View
Correct

Incorrect
Question 20 of 30

20. Question
What are the group of data sources can Power BI connect to?
- Files, SQL, Azure
- Files, Content Packs, Connectors
- Databases, SQL, Azure
- Content Packs, Connectors, SQL
Correct

Incorrect
Question 21 of 30

21. Question
Visual-level filter applies to
- One Page
- All Pages
- One Visualization
- Multiple Visualization in same page
Correct

Incorrect
Question 22 of 30

22. Question
Contains reference data such as descriptive attributes
- Dimension Table
- Fact Table
- Query Table
- Power BI Table
Correct

Incorrect
Question 23 of 30

23. Question
What is the Power Bi file Format?
- .pbix
- .pbi
- .xlsx
- .xls
Correct

Incorrect
Question 24 of 30

24. Question
A collection of data that you import or connect to
- Datasets
- Dashboards
- Reports
- All of the above
Correct

Incorrect
Question 25 of 30

25. Question
A single page, often called a canvas, that tells a story through visualizations
- Datasets
- Reports
- Dashboards
- All of the above
Correct

Incorrect
Question 26 of 30

26. Question
A multi-perspective view into a dataset, with visuals that represent different findings and insights from that dataset
- Datasets
- Dashboards
- Reports
- All of the above
Correct

Incorrect
Question 27 of 30

27. Question
Which is used to calculate the data in each row
- Counting
- Calculated Row
- Measure
- Calculated Column
Correct

Incorrect
Question 28 of 30

28. Question
What is not a built in Power BI visual?
- POWER KPI
- ArcGIS map
- Funnel chart
- Waterfall chart
Correct

Incorrect
Question 29 of 30

29. Question
Which of the following is true?
- You must refresh the data manually after publishing to the web.
- You cannot refresh data after publishing to the web, the visuals are static.
- The user does not have the appropriate row level security permissions.
- It takes up to an hour for data to refresh.
Correct

Incorrect
Question 30 of 30

30. Question
Contains transactional data or facts of a business process
- Dimension table
- Fact table
Correct

Incorrect

Power BI Interview Preparation

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

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question

26. Question

27. Question

28. Question

29. Question

30. Question

Leave a Comment Cancel reply