Exam DA-100 topic 4 question 3 discussion

answer is correct

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.

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.

Answer 1. 9 files 2. 10 rows

The answer is correct

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.

on exam 3/1/2022

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

In exam 30/12/21

9 & 10

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

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

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

on exam - Nov 11, 2021. my answers: 9 10

perhpas the csv files are located in a subfolder inside a folder in which case they can have the same name

why not 10 files as there are 10 distinct id

Correct asnwer is 90 and 10