HOTSPOT -
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 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:
Box 1: Hide -
Need in the relation, so cannot delete it.
Box 2: Delete -
Reference:
https://community.powerbi.com/t5/Desktop/How-to-Hide-a-Column-in-power-Bi/m-p/414470
Answer is Correct
Hide & Delete
Was at the exam on February 12th 2024
This was on the exam
Corect answer. Employee_id: Hide We should not delete this as it appears to be the primary key of the Employee table. employee_photo: Delete AS mentioned in the question, since there is no reporting requiremtns on it, the column can be deleted.
yes answer correct. Photo not needed so delete. Employee ID is the common key between these tables so hide.
This was on my exam 2/2024.
one doubt that while attempting exam it will ask for ever module like, How much level you are in like beginner, intermediate, expert, professional right. which options we'll get these questions? can anyone let me know
+1 EVEN I HAVE THIS QUESTION
21-feb- 2024, Scored 920 My answer was Hide and Delete
This question was on the exam on 02/02/2024
Hide and Delete are the correct answers. Hide: We should hide the "employee_id" column if there are no reporting requirements on it. This means it won't be visible in the report, but it will still be available for any potential relationships or calculations with the model. Delete: Since there are no reporting requirements on the "employee_photo" column, we should delete it from the data model to reduce unnecessary storage and improve performance. This means that the "employee_photo" data is not needed for any calculations or relationships within the model.
The answer is correct, and the question was on the exam.
For employee_id: Hide: This option should be selected to hide the employee_id column. Since there are no reporting requirements on it, hiding the column can help declutter the report and improve the user experience. For employee_photo: Delete: This option should be selected to delete the employee_photo column. If there are no reporting requirements for it and it is not needed for any analysis or visualization, removing the column altogether can help reduce the storage space and optimize the data model.
28-Mar-24 - This Q came up. Blitzed all 266 Q's on Exam Topics and Scored 813/1000. Only 1 question out of the 50 wasn't on exam topics exactly.
is there anyway you could share those Qs?
Answer is correct. You need Employeeid for creating relations.
I think it should be change date type and delete because changing the date type of employees ID to VARCHAR will prevent summation of the column and deleting unwanted column, both scenarios will optimize the report
VARCHAR is less efficient than integer
given answer is correct
Answer is correct!!