Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 20 discussion

Actual exam question from Microsoft's PL-300

Question #: 20
Topic #: 2

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:

Show Suggested Answer

Suggested Answer:

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

by VeroF at Sept. 19, 2022, 12:26 p.m.

Comments

Submit Cancel

VeroF

Highly Voted 2 years, 11 months ago

Answer is Correct

upvoted 59 times

...

Namenick10

Highly Voted 2 years, 10 months ago

Hide & Delete

upvoted 16 times

...

jaume

Most Recent 9 months ago

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...

upvoted 1 times

...

rcaliandro

12 months ago

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

upvoted 1 times

...

Kiran37

1 year ago

correct answer

upvoted 1 times

...

MayurV19

1 year, 7 months ago

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.

upvoted 7 times

...

bingomutant

1 year, 10 months ago

yes answer correct. Photo not needed so delete. Employee ID is the common key between these tables so hide.

upvoted 5 times

...

Igetmyrole

1 year, 11 months ago

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.

upvoted 5 times

...

IVO999

2 years ago

The answer is correct, and the question was on the exam.

upvoted 3 times

...

MoxieTT

2 years, 1 month ago

This was on the exam

upvoted 8 times

...

vine1089

2 years, 1 month ago

Answer is correct. You need Employeeid for creating relations.

upvoted 2 times

...

sergeyitaly

2 years, 2 months ago

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.

upvoted 3 times

...

NAZAOG

2 years, 2 months ago

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

upvoted 1 times