Learn how to optimize your data model in Power BI by configuring employee_id and employee_photo columns. Improve report performance and user experience.
Table of Contents
Question
You are creating an analytics report that will consume data from the tables shown in the following table.
| Table name | Column name | Data type |
|---|---|---|
| Sales | sales_id | Integer |
| sales_date | Datetime | |
| Customer_id | Integer | |
| sales_amount | Floating | |
| employee_id | Integer | |
| sales_ship_date | Datetime | |
| store_id | Varchar(100) | |
| Employee | employee_id | Integer |
| first_name | Varchar(100) | |
| last_name | Varchar(100) | |
| employee_photo | Binary |
There is a relationship between the tables.
There are no reporting requirements on employee_id and employee_photo.
You need to optimize the data model.
What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Employee_id:
- Change Type
- Delete
- Hide
- Sort
Employee_photo:
- Change Type
- Delete
- Hide
- Sort
Answer
Employee_id: Hide
Employee_photo: Delete
Explanation
To optimize the data model for the analytics report, you should configure employee_id and employee_photo as follows:
Employee_id:
– Hide
Since there are no reporting requirements on employee_id, you should hide this column in the data model. Hiding unnecessary columns improves the user experience by decluttering the field list and makes the data model more efficient. The relationship between the Sales and Employee tables will still be maintained even with employee_id hidden.
Employee_photo:
– Delete
The employee_photo column contains binary data which is not needed for the analytics report. Deleting this column will reduce the size of the data model and improve query performance. Binary data like images are typically stored separately and retrieved only when necessary, rather than being embedded directly in the data model.
In summary, to optimize the data model, hide the employee_id column since it is not required for reporting, and delete the employee_photo column to remove unnecessary binary data. This will result in a more efficient and user-friendly data model for your analytics report in Power BI.
Microsoft PL-300 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.