Welcome to your POWER BI MCQ
1.
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
2.
What is the minimum number of datasets and storage modes required to support the reports?
3.
You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee count and predicts trends during the next six months. Which type of visualization should you use?
4.
You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows.The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals.Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend?
5.
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
6.
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
7.
Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North.You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?
8.
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
9.
You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do?
10.
You need to update the Power BI model to ensure that the analysts can quickly build drilldowns from business unit to product in a visual. What should you create?
