Power BI

Overview

Rewards

FAQs

Overview

Power BI is a business analytics service provided by Microsoft that allows users to visualize and analyze data from a variety of sources, including Excel spreadsheets, cloud-based and on-premises data sources, and third-party applications. Power BI provides a suite of tools for creating interactive visualizations, dashboards, and reports that can be shared with others in the organization.

Take this assessment to know how much you are familiar with Power BI basics.

Click the Rewards tab for eligibility requirements.

Read the FAQs tab carefully for Instructions before beginning the assessment.

Rewards

NYXPoints are used to generate the Leaderboard (coming soon). They are awarded for achieving a certain score.

200 nyxpoints for a passing score of 80% or more
300 nyxpoints for a perfect score of 100%
Didn’t pass? You still get 30 nyxpoints for attempting the assesment

FAQs

IMPORTANT instructions for taking the Assessment

The timer starts when you click Start Assessment
DO NOT refresh/reload the page or use the back button to navigate away from the page.
Navigating away from the assessment page DOES NOT stop/pause the timer and the will restart the assessment when you come back to it. The answers are NOT saved.

General

There are NO pre-requisites to take this assessment. Take this assessment even if you are completely new to Linux.
The assessment is completely FREE.
Preferably take it in a closed book mode.
DO NOT copy/paste, share or upload questions elsewhere.

Eligible Rewards

300 NyxCoins*

* NyxCoins vary on score

Questions

Minutes

1 %

Passing Score

Time limit: 0

Assessment Summary

0 of 30 Questions completed

Questions:

Information

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

Assessment is loading…

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

You must first complete the following:

Results

Assessment complete. Results are being recorded.

Results

0 of 30 Questions answered correctly

Your time:

Time has elapsed

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

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Average score
Your score

Categories

Not categorized 0%

Current
Review
Answered
Correct
Incorrect

Question 1 of 30

1. Question
Which of the following is/are the elements of Power BI?
- Power BI Report Builder
- Power BI Service
- Power BI Report Server
- All of the above
Correct

Incorrect
Question 2 of 30

2. Question
Which of the following role allows you to administer Power BI for your organization? (Multiple Choice)
- Power Platform Administrator
- Power BI Administrator
- User Administrator
- None of the above
Correct

Incorrect
Question 3 of 30

3. Question
How an Office 365 user administrator can assign users to the Power BI administrator or Power Platform administrator roles?
- Using Microsoft 365 admin centre
- Using a PowerShell script
- Both (a) and (b)
- Neither (a) nor (b)
Correct

Incorrect
Question 4 of 30

4. Question
Users in Power BI administrator roles have ______ over organization wide Power BI setting, except for ________.
- full control; licensing
- limited control; user management
- no control; licensing
- limited control; licensing
Correct

Incorrect
Question 5 of 30

5. Question
Which of the below role is required to access the audit logs?
- Power BI Administrator
- Power Platform Administrator
- Microsoft 365 Admin
- All of the above
Correct

Incorrect
Question 6 of 30

6. Question
Select the correct step to remove Power BI for users who already signed up.
- Admin Centre -> Active Users -> Edit -> Turn off the user
- Admin Centre -> License -> Edit -> Set Power BI to Off
- Admin Centre -> User Groups -> User -> Delete the user
- Admin Centre -> Users -> Active Users -> Edit Product License -> Set Power BI to Off
Correct

Incorrect
Question 7 of 30

7. Question
How will you find the default region where your Power BI data is stored for your organization?
- Help & Support -> About Power BI
- Settings -> Manage Personal Storage
- Settings -> Admin Portal
- None of the above
Correct

Incorrect
Question 8 of 30

8. Question
Which of the following Power BI plan provides Multi-Geo support feature?
- Power BI Free plan
- Power BI Base plan
- Power BI Premium plan
- Power BI doesn’t support this feature
Correct

Incorrect
Question 9 of 30

9. Question
What is Power Pivot?
- It is an add-on for Microsoft Excel which helps in powerful data analysis.
- It is a software by Power BI.
- It is a CLI by Power BI.
- It is tool which allows you to import data from various data sources.
Correct

Incorrect
Question 10 of 30

10. Question
What is the data storage limit in free version of Power BI?
- 2 GB
- 5 GB
- 10 GB
- 50 GB
Correct

Incorrect
Question 11 of 30

11. Question
Which of the following are the types of data gateway?
- On-premises data gateway
- On-premises data gateway (personal mode)
- Virtual network data gateway
- All of the above
Correct

Incorrect
Question 12 of 30

12. Question
Select the correct step to use a gateway?
- Download and install gateway -> Configure the gateway -> Add gateway admins -> Use the gateway -> Troubleshoot
- Login into gateway -> Connect to the gateway -> Add gateway admins -> Troubleshoot
- Install gateway -> Add gateway admins -> Use the gateway -> Collect the data -> Troubleshoot
- None of the above
Correct

Incorrect
Question 13 of 30

13. Question
Which of the below are major building blocks of Power BI?
- Dashboards
- Reports
- Workbooks
- All of the above
Correct

Incorrect
Question 14 of 30

14. Question
Which of the below statement best describes Power BI Desktop?
- It is a free application to sync all your data.
- It is a paid application which allows you to connect to multiple sources of data and combine them into data model.
- It is a free application which can be installed on your local computer and lets you connect to, transform, and visualize your data.
- It is a paid application to create reports from different data sources.
Correct

Incorrect
Question 15 of 30

15. Question
What are the different views available in Power BI Desktop? (Multiple Choice)
- Report
- Source
- Data
- Model
Correct

Incorrect
Question 16 of 30

16. Question
What are Capacities?
- They are a set of resources used to host and deliver your Power BI content.
- They are the set of storage attached to Power BI.
- They are containers for Dashboards.
- None of the above.
Correct

Incorrect
Question 17 of 30

17. Question
What are Workspaces?
- They are a type of Capacities.
- They are containers for dashboards, reports, workbooks, datasets, and dataflows.
- Both (a) and (b)
- Neither (a) nor (b)
Correct

Incorrect
Question 18 of 30

18. Question
How many types of Workspaces available in Power BI?
- 5
- 4
- 3
- 2
Correct

Incorrect
Question 19 of 30

19. Question
What is dataflow?
- It is movement of data from one source to another.
- It is a flowchart by Power BI.
- It is a collection of tables that are created and managed in workspaces.
- All of the above
Correct

Incorrect
Question 20 of 30

20. Question
What are the different modes to view and interact with reports?
- Reading View
- Editing View
- Both (a) and (b)
- Neither (a) nor (b)
Correct

Incorrect
Question 21 of 30

21. Question
Select the most suitable statement for Power BI Report Server.
- It is an on-premise report server with a web portal in which you display and manages reports.
- It is a cloud server which helps you to generate different reports.
- It is an on-premise server to store various reports.
- It is a Power BI cloud server which helps to generate and displays reports in different dashboards.
Correct

Incorrect
Question 22 of 30

22. Question
What is the extension of Power BI reports?
- .pbx
- .pbix
- .pbsx
- .pbxi
Correct

Incorrect
Question 23 of 30

23. Question
What is the extension of Paginated reports in Power BI?
- .rdal
- .pbdl
- .pbil
- .rdl
Correct

Incorrect
Question 24 of 30

24. Question
Where the Power BI apps are created?
- They are created in Capacities.
- They are created in Workspaces.
- They are created in Dashboards.
- They are created in Workspaces and Capacities both.
Correct

Incorrect
Question 25 of 30

25. Question
What are the different stages of Deployment Pipelines in Power BI?
- Development
- Test
- Production
- All of the above
Correct

Incorrect
Question 26 of 30

26. Question
In Power BI, BI stands for ________.
- Business Intelligence
- Business Information
- Business Intellectuals
- Business Initiation
Correct

Incorrect
Question 27 of 30

27. Question
Which option would you choose to reshape and change the data in Power BI?
- Data Modelling
- Data Editing
- Data Visualization
- Data Transformation
Correct

Incorrect
Question 28 of 30

28. Question
Select the correct data transformation language of Power Query.
- Go Language
- Python
- M Language
- None of the above
Correct

Incorrect
Question 29 of 30

29. Question
What are the different visualizations which can be added to Power BI reports?
- Doughnut charts
- Funnel charts
- Gauge charts
- All of the above
Correct

Incorrect
Question 30 of 30

30. Question
Dashboards are created and copied using ____________ and can be viewed in __________. (Multiple Choice)
- Power BI Service; Power BI Mobile
- Power BI Desktop; Power BI Embedded
- Power BI Desktop; Power BI Service
- Power BI Service; Power BI Embedded
Correct

Incorrect

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Power BI

Eligible Rewards

300 NyxCoins*

Assessment 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