ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 2 question 7 discussion

Actual exam question from Microsoft's DP-700
Question #: 7
Topic #: 2
[All DP-700 Questions]

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 Hide Answer
Suggested Answer:
by werfragt at Jan. 17, 2025, 9:23 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
werfragt
Highly Voted 3 months ago
First part is CONVERT and not CAST
upvoted 17 times
doctordodge
2 months, 3 weeks ago
Agreed, based on the syntax of (<data type>, <column name>).
upvoted 3 times
...
...
Blue_MSBI
Highly Voted 1 month, 3 weeks ago
CONVERT, LEFT OUTER, HAVING
upvoted 8 times
...
LasAnsias
Most Recent 3 days, 6 hours ago
CONVERT LEFT (Ensure that all the rows from the Employee table are preserved and include any matching rows from the Contract table.) HAVING
upvoted 1 times
...
vish9
1 month, 1 week ago
Syntaxt for Cast is different. It does not fit here. CONVERT(DATE, c.startdate) AS startdate CAST(c.startdate AS DATE) AS startdate
upvoted 1 times
...
giraf
2 months 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 2 times
...
2e6975f
2 months ago
CONVERT LEFT OUTER JOIN HAVING
upvoted 3 times
...
MultiCloudIronMan
2 months ago
Right outer join and cast
upvoted 1 times
...
8d6881f
2 months, 2 weeks ago
CAST(c.StartDate as date) vs CONVERT(date, c.StartDate)
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago