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

Exam DP-500 All Questions

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

Exam DP-500 topic 1 question 45 discussion

Actual exam question from Microsoft's DP-500
Question #: 45
Topic #: 1
[All DP-500 Questions]

DRAG DROP -
You have an Azure Synapse Analytics serverless SQL pool.
You need to return a list of files and the number of rows in each file.
How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by nbagchi at Dec. 13, 2022, 3:57 p.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
bad_atitude
Highly Voted 2 years, 4 months ago
Count Big OpenRowSet
upvoted 10 times
...
MaryemSB
Most Recent 1 year, 6 months ago
COUNT_BIG OPENROWSET
upvoted 1 times
...
SamuComqi
1 year, 10 months ago
I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - COUNT_BIG - OPENROWSET
upvoted 2 times
...
Eltooth
1 year, 11 months ago
Count_Big OpenRowSet
upvoted 1 times
...
DarioReymago
2 years, 2 months ago
COUNT_BIG use *, https://learn.microsoft.com/en-us/sql/t-sql/functions/count-big-transact-sql?view=sql-server-ver16 and OpenRowSet
upvoted 3 times
...
Madiba_kaka
2 years, 4 months ago
Since parquet file can be very big, the APPROX_COUNT_DISTINCT makes sense because it's designed for use in big data scenarios. Also, APPROX_COUNT_DISTINCT requires less memory than an exhaustive COUNT DISTINCT operation. With very big file an approximate row count will suffice as opposed to an exact count. https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-count-distinct-transact-sql?view=sql-server-ver16
upvoted 3 times
reemprive
1 year, 5 months ago
If this was true, group by would not have been used.
upvoted 1 times
...
...
moreinva43
2 years, 5 months ago
I can find no example of using approx_count_distinct with an asterisk, while I know it can be used with count_big.
upvoted 4 times
ivanb94
2 years, 5 months ago
Not only that but the count_big actually counts rows (check here https://learn.microsoft.com/en-us/sql/t-sql/functions/count-big-transact-sql?view=sql-server-ver16) which is what the Q asks us to do instead of counting non-null values that can repeat across multiple rows (check here https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-count-distinct-transact-sql?view=sql-server-ver16) making approx_count_distinct the wrong answer. Not to mention the approximation element of it all that has no place in the given question.
upvoted 8 times
Ngol
2 years, 5 months ago
Your comment makes sense from the links provided
upvoted 3 times
...
...
...
nbagchi
2 years, 6 months ago
Correct
upvoted 3 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