DP-700 Exam - Question 62

Question

HOTSPOT -You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following tables and columns. You need to denormalize the tables and include the ContractType and StartDate columns in the Employee table. The solution must meet the following requirements:Ensure that the StartDate column is of the date data type. Ensure that all the rows from the Employee table are preserved and include any matching rows from the Contract table. Ensure that the result set displays the total number of employees per contract type for all the contract types that have more than two employees. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Examice · Accepted Answer

.

werfragt · Answer

First part is CONVERT and not CAST

Blue_MSBI · Answer

CONVERT, LEFT OUTER, HAVING

8d6881f · Answer

CAST(c.StartDate as date)
vs 
CONVERT(date, c.StartDate)

2e6975f · Answer

CONVERT
LEFT OUTER JOIN
HAVING

giraf · Answer

convert, inner, having
Convert: No doubt.
inner: You only need contracttypes with more than 2 employees. So, why use left join? Inner join already filters out contracts and employees you won't need for aggregation.
having: No doubt

LasAnsias · Answer

CONVERT
LEFT (Ensure that all the rows from the Employee table are preserved and include any matching rows from the Contract table.)
HAVING

MultiCloudIronMan · Answer

Right outer join and cast

vish9 · Answer

Syntaxt for Cast is different. It does not fit here.
CONVERT(DATE, c.startdate) AS startdate
CAST(c.startdate AS DATE) AS startdate

nicknamealready · Answer

CONVERT,
LEFT OUTER, HAVING

DP-700 Exam - Question 62

Discussion