Exam PL-300 topic 2 question 20 discussion

Answer is Correct

Hide & 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

correct answer

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.

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.

This was on the exam

Answer is correct. You need Employeeid for creating relations.

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.

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

given answer is correct

Answer is correct!!

Hiding does not help for optimizing, but Sort helps.

Sort Delete