Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 4 question 3 discussion

Actual exam question from Microsoft's DA-100

Question #: 3
Topic #: 4

HOTSPOT -
You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: 9 -
9 distinct CSV files.

Box 2: 10 -
10 distinct dates.

by Rahhal at Oct. 6, 2020, 10:16 p.m.

Comments

Submit Cancel

Ard

Highly Voted 4 years, 8 months ago

answer is correct

upvoted 176 times

Goooglegen

3 years, 6 months ago

For 2nd Question remove duplicates: https://docs.microsoft.com/en-us/power-query/working-with-duplicates#remove-duplicates-from-a-single-column

upvoted 1 times

...

SaeedJei

3 years, 8 months ago

how is it possible to have 90 rows by 9 files?

upvoted 2 times

SaeedJei

3 years, 8 months ago

Unless they are appended

upvoted 1 times

...

snna4

3 years, 8 months ago

Filenames have spaces at the beginning (see Source.Name column).

upvoted 1 times

...

VeroF

2 years, 10 months ago

you have right, the correct answer is 9, 10. For first area the answer is 9 because we need to look at the column Source.Name and we can see 9 distinct, 0 unique. For second area the answer is 10 because it is selected <Column Profile> for column Date (View meniu) and also we can identify the same answer with <Column Distribution>.

upvoted 1 times

...

mirzotti

3 years, 6 months ago

This is not correct. The 'Count' is showing 90 rows (meaning csv files). 'Distinct' shows 10. So the answer is: 90 & 10.

upvoted 9 times

Matreshka

2 years, 12 months ago

90 rows are shown for Date column, not for csv files. See the highlighted column

upvoted 1 times

...

walkerzjs

3 years, 5 months ago

The source.name has 9 distinct values. That's why I think there are 9 files.

upvoted 4 times

...

chakri007

Highly Voted 4 years, 8 months ago

I think the answer should be Box1:90 and Box2:10. Each row in the table is one CSV file. The answer for Box1 is about the number of rows(which includes duplicates), not the distinct values of a column. This Count can be found under the Column stats below the table as COUNT 90. The second box is distinct count based on the Date Column which is 10.

upvoted 67 times

ZVV

4 years, 8 months ago

Column stats is shown for Date column, not file name

upvoted 2 times

...

slalithp

4 years, 7 months ago

yup, even the date column count says 90

upvoted 1 times

...

stokazz

4 years, 4 months ago

I think this is wrong. The correct one is the answer above by Morti42

upvoted 3 times

...

VesperKiw

4 years, 6 months ago

But those 90 are ROWs not FILEs. It states in the question they are coming from a folder. You can't have two files with the same name in a folder, so its 9. I personally agree with the answer.

upvoted 24 times

...

jokstogo

Most Recent 2 years, 9 months ago

The answer is 90. How can you get 90 rows from a folder if there are only 9 files? doesnt make sense. It could be that the files are from different subfolders, but they have the same name. regardless, they are still separate files, with same name, on different folders.

upvoted 1 times

...

QWERTYman

2 years, 10 months ago

Answer 1. 9 files 2. 10 rows

upvoted 1 times

...

claudeaboki

3 years ago

The answer is correct

upvoted 1 times

...

BLUE_BUBBLES

3 years, 1 month ago

There can't be 9 CSV files for the simple fact that the date is a refresh date happening at different intervals. So every refresh will generate another CSV file. The answer is 90.

upvoted 3 times

...

Ashley090521

3 years, 3 months ago

on exam 3/1/2022

upvoted 1 times

...

missmanou

3 years, 3 months ago

So what's the correct answer here ? Is it 90 and 10 or 9 and 10 distinctive dates ?

upvoted 1 times

...

Shan

3 years, 5 months ago

In exam 30/12/21

upvoted 2 times

...

Siva2104

3 years, 6 months ago

9 & 10

upvoted 3 times

...

Siva2104

3 years, 6 months ago

My Answer is 10 & 90:: 1) For each day / date two file (8am & 6pm) - for 5 days min is 2018-01-01 8:00:00AM & max is 2018-05-01 6:00:00 PM (Observe the bar in the columns profile) - each file contains the 9 transactions 2) Date columns (Data type - date/Time) - this filed doesn't have duplicate values - if you use the option to remove duplicate against this columns will not Impact the count Tested

upvoted 1 times

...

testbbb

3 years, 6 months ago

the answer is wrong for box 1. I think it should be 90

upvoted 2 times

...

DIPARJ

3 years, 7 months ago

Since the total count is 90 and as per value distribution it is uniform for all dates so answer would be 90/10= 9 and removing duplicates would result in 10 distinct values

upvoted 3 times

...