Topic 1 · Question 123
Which of the following is the correct extension for a tab-delimited spreadsheet file?
- A.tap
- B.tar
- C.tsv (correct answer)
- D.taz
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: .tsv
DA0-001 — questions
Page 7 of 15 · 294 total questions.
Topic 1 · Question 124
A data analyst needs to analyze a sales data set to identify the sales representatives who are selling the most units per month. Which of the following should the analyst perform?
- AA sales analysis
- BA link analysis
- CA performance analysis (correct answer)
- DA trend analysis
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: A performance analysis
Topic 1 · Question 125
Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?
- ADuplication
- BConsolidation (correct answer)
- CCompliance
- DStandardization
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: Consolidation
Topic 1 · Question 126
Which of the following is the BEST description of the term “data governance”?
- AData governance governs the development of a data visualization dashboard in an organization.
- BData governance is the policy that protects against data breaches by cybercriminals.
- CData governance is the process of analyzing, manipulating, and reporting data in an organization.
- DData governance is the availability, usability, integrity and security of data in an enterprise. (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: Data governance is the availability, usability, integrity and security of data in an enterprise.
Topic 1 · Question 127
In comparison to other data types, which of the following can hold a mix of numbers and letters?
- ACharacter
- BFloat
- CInteger
- DAlphanumeric (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: Alphanumeric
Topic 1 · Question 128
Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together. Which of the following is the MOST efficient way to ensure the data is reported correctly?
- AAssume the data was blended together and wait for feedback.
- BFilter on every column to look for inconsistencies in the data.
- CSpot check a few numbers to look for inconsistencies.
- DReview the files separately and ensure the blended totals match. (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: Review the files separately and ensure the blended totals match.
Topic 1 · Question 129
Given the following numbers: 7, 2, 3, 3, 5 Which of the following is the mean?
- A2
- B3
- C4 (correct answer)
- D7
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: 4
Topic 1 · Question 130
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 (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: $8,642
Topic 1 · Question 131
A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to examine the numerical variables in the data set visually and find any outliers?
- APlot the linear correlations between each pair of variables and look for unusual relationships
- BCreate a bar chart for each variable and look for any distributions that are unusual.
- CBuild a scatter plot of each variable and look for observations that are out of place. (correct answer)
- DOrder each variable in a spreadsheet from lowest to highest and look for unusual numbers at the beginning or at the end of the list.
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: Build a scatter plot of each variable and look for observations that are out of place.
Topic 1 · Question 132
A staff member is analyzing open-ended customer comments from an email survey. Which of the following is the EASIEST way to visualize the data?
- AA stacked chart
- BA word cloud (correct answer)
- CA bar chart
- DA bubble chart
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: A word cloud
Topic 1 · Question 133
A product department wants to review the performance of all products that launched in 2019 in the Midwest. The data provided in the table below is for all sales throughout the entire company and will need to be filtered prior to review. Which of the following filters must be applied to get the desired results?
- ALaunch year and region (correct answer)
- BRegion and product
- CBrand and sales
- DLaunch year and product
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Launch year and region
Topic 1 · Question 134
Which of the following inferential statistical methods would be used to determine if there is a significant difference between the means of two groups?
- Ap-value
- BZ-score
- CChi-squared test
- Dt-test (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: t-test
Topic 1 · Question 135
A data analyst works for a condominium development company. The company is undergoing unit number changes. Which of the following would be MOST appropriate to include on the unit inventory sheet that is shown in board meetings?
- ADisplay a column with historical unit numbers and new unit numbers. (correct answer)
- BCreate a new unit inventory with new unit numbers only.
- CDelete historical files with previous unit numbers.
- DCreate a hidden column that shows the historical unit numbers.
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Display a column with historical unit numbers and new unit numbers.
Topic 1 · Question 136
Which of the following will always result in a null value when aggregate operations are applied?
- ASum collection
- BData collection
- CAverage collection
- DEmpty collection (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: Empty collection
Topic 1 · Question 137
The accounting team has requested a series of self-serve, dynamic reports. Aside from the reporting time frame, the report criteria are identical. Which of the following should the analyst create?
- AA single report with the option to select the date range (correct answer)
- BOne consolidated report with all available data
- CAutomated reports to be distributed based on the time frames in the requirements
- DThe reports as requested in the requirements document
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: A single report with the option to select the date range
Topic 1 · Question 138
Which of the following BEST describes an ad hoc report?
- AA one-time report (correct answer)
- BA recurring report
- CA tactical report
- DA monthly report
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: A one-time report
Topic 1 · Question 139
A home builder is offering a 30% discount on condominium units. Given the table below: Which of the following is the range of savings for the units listed in the table?
- A$103,500 to $157,500 (correct answer)
- B$241,500 to $367,500
- C$320,000 to $386,000
- D$345,000 to $525,000
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: $103,500 to $157,500
Topic 1 · Question 140
A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:
- Anon-relational schema.
- Bgalaxy schema.
- Csnowflake schema.
- Dstar schema. (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: star schema.
Topic 1 · Question 141
A company derives proprietary leads from monthly sales calls and sends them to dealers through a connection that matches the correct leads to the correct dealers Which of the following BEST describes this method?
- AApplication programming interface (correct answer)
- BPublic databases
- CSurvey
- DWeb scraping
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Application programming interface
Topic 1 · Question 142
Which of the following technologies would be BEST suited for creating a multiple linear regression model?
- AMicrosoft Power BI
- BR (correct answer)
- CSQL
- DTableau
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: R
Showing questions 121–140 of 294 · Page 7 of 15