Test DA0-001
Question 1:A data analyst needs to survey customers about their preferences for various types of soda. Which of the following sampling methods should the analyst use to collect the survey data?
A.
Simple random sampling
B.
Parameterization sampling
C.
Index sampling
D.
Single-stage sampling
Question 2:
A data analyst has been asked to find the mean, median, and mode of the distribution in the data shown below:
Which of the following is the correct answer?
A.
Mean: 5 -Median: 3 -Mode: 7 -
B.
Mean: 5 -Median: 7 -Mode: 7 -
C.
Mean: 6 -Median: 3 -Mode: 7 -
D.
Mean: 6 -Median: 7 -Mode: 7
Question 3:
A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?
A.
Mean
B.
Variance
C.
Correlation
D.
Confidence interval
Question 4:
An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the following data qualities does this present the GREATEST issue?
A.
Data completeness
B.
Data integrity
C.
Data consistency
D.
Data accuracy
Question 5:
A customer’s telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?
A.
Boolean
B.
Date
C.
Text
D.
Number
Question 6:
Which of the following is the BEST example of unstructured data?
A.
A JSON file
B.
A relational database
C.
A CSV file
D.
An audio file
Question 7:
Which of the following data formats are examples of unstructured data? (Choose two.)
A.
XML
B.
CSV
C.
XLS
D.
PNG
E.
JSON
F.
MP4
Question 8:
Which of the following is the correct extension for a tab-delimited spreadsheet file?
A.
.tap
B.
.tar
C.
.tsv
D.
.taz
Question 9:
A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day’s performance. Which of the following reports should the analyst provide?
A.
Tactical
B.
Ad hoc
C.
Dynamic
D.
Recurring
Question 10:
Given the following:
Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?
A.
Fill in the missing cost where it is null.
B.
Separate the table into two tables and create a primary key.
C.
Replace the extended cost field with a calculated field.
D.
Correct the dates so they have the same format.
Question 11:
Which of the following is a difference between a primary key and a unique key?
A.
A unique key cannot take null values, whereas a primary key can take null values.
B.
There can be only one primary key in a data set, whereas there can be multiple unique keys.
C.
A primary key can take a value more than once, whereas a unique key cannot take a value more than once.
D.
A primary key cannot be a date variable, whereas a unique key can be.
Question 12:
A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a customer:
Which of the following is the final cost of the product?
A.
$5,402
B.
$6,297
C.
$7,634
D.
$8,642
Question 13:
SIMULATION -
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
Question 14:
A data analyst has been asked to organize the table below in the following ways:
By sales from high to low -
By state in alphabetic order -
Which of the following functions will allow the data analyst to organize the table in this manner?
A.
Conditional formatting
B.
Grouping
C.
Filtering
D.
Sorting
Question 15:
Which of the following is an example of a at flat file?
A.
CSV file
B.
PDF file
C.
JSON file
D.
JPEG file
Disclaimer:
The content on this webpage is collected from various internet sources. While we strive for accuracy, we cannot guarantee its completeness or correctness. Please use it with caution and conduct further research if needed. We do not claim ownership or copyright over any content. If you find any copyrighted material or content that violates laws, please contact us for removal. By accessing this webpage, you agree to these terms. Thank you for your understanding.
The content on this webpage is collected from various internet sources. While we strive for accuracy, we cannot guarantee its completeness or correctness. Please use it with caution and conduct further research if needed. We do not claim ownership or copyright over any content. If you find any copyrighted material or content that violates laws, please contact us for removal. By accessing this webpage, you agree to these terms. Thank you for your understanding.