Question 81

You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.

View2 contains the columns shown in the following table.

Question 82

You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Question 83

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
* Access a published Power BI app
* Modify reports in an app workspace
* Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 84

You have a Power Bl workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
  • Question 85

    You are creating an analytics report that will consume data from the tables shown in the following table.

    There is a relationship between the tables.
    There are no reporting requirements on employeejd and employee_photo.
    You need to optimize the data model
    What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.