Exam DP-700 topic 2 question 7 discussion

Actual exam question from Microsoft's DP-700

Question #: 7
Topic #: 2

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.

Show Suggested Answer

Suggested Answer:

by werfragt at Jan. 17, 2025, 9:23 a.m.

Comments

Submit Cancel

werfragt

Highly Voted 1 month ago

First part is CONVERT and not CAST

upvoted 10 times

doctordodge

3 weeks, 6 days ago

Agreed, based on the syntax of (<data type>, <column name>).

upvoted 3 times

...

giraf

Most Recent 4 days, 21 hours ago

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

upvoted 1 times

...

2e6975f

6 days, 13 hours ago

CONVERT LEFT OUTER JOIN HAVING

upvoted 2 times

...

MultiCloudIronMan

6 days, 20 hours ago

Right outer join and cast

upvoted 1 times

...

8d6881f

3 weeks, 2 days ago

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