Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - Employee_id: Hide - Employee_photo: Delete * Explanation: Employee_id - There is a relationship between tables, so employee_id must remain in the model to maintain that relationship. - It is not needed in reports, so the best option is: Hide Employee_photo - There are no reporting requirements for this column, and it does not affect relationships. - To optimize the model, remove it entirely: Delete
Agree with the proposed answer (Hide Employee_ID and Delete Employee_Photo) although it's not clear to me how hiding the Employee_Id is optimizing the data model. This is just making that field not visible to users but it's still available in our data model (so no improvement in size) and it's not affecting the way the relationship is set...
Since there are no requirements on emp_id and emp_photo, we can 1 - hide the emp_id 2 - delete the emp_photo So, the answer is correct