Page 15 of 15 · 294 total questions.
An analyst is developing a form to collect data from clients. Which of the following techniques should the analyst use to best ensure data integrity?
The correct answer is A. Option A: Adding rules for data validation
A reporting analyst needs to create a report that refreshes automatically and is accessible to the entire sales organization. Which of the following tools is the most appropriate to use for this task?
The correct answer is C. Option C: Tableau
Which of the following data integration concepts should be used if only new data is being added to a table since the previous load?
The correct answer is C. Option C: Delta load
A customer survey reveals 90% positive feedback. Which of the following statistical methods would be best to utilize to determine the reliability of a data set and predict how a larger sample of customers over the same time period might respond?
The correct answer is C. Option C: Calculate a low standard deviation on survey responses.
Which of the following statistical measures is the most suitable and simple measure of the strength and direction of the linear relationship between price and volume?
The correct answer is C. Option C: Correlation
An analyst is recording the following financial transaction data with a vendor: 59.99, 49.50, 70.49 Which of the following data types is the best way to record this information?
The correct answer is C. Option C: Currency
A data analyst is creating a high-level report for the Chief Executive Officer. Which of the following data would most likely be included in the report?
The correct answer is D. Option D: Year-to-date sales numbers
Which of the following is a reason for sampling?
The correct answer is D. Option D: Conclusions need to be drawn from a large population.
A data analyst is creating a dashboard to monitor and manage processes on a daily, weekly, and quarterly basis. Which of the following types of dashboards is the best for this purpose?
The correct answer is D. Option D: Tactical
Which of the following is a flat file data format?
The correct answer is B. Option B: CSV
Which of the following refers to the process of quantifying data?
The correct answer is D. Option D: Enumeration
Which of the following query optimization techniques is the best way for an analyst to make the query execute faster?
The correct answer is A. Option A: Indexing
A health care data analyst is reviewing a data set containing patient blood pressure measurements taken over the past year. The analyst notices that some of the values for blood pressure seem unusually high, which might indicate data entry errors or outliers. Which of the following data quality dimensions should be the primary focus to address this issue?
The correct answer is A. Option A: Data accuracy
Which of the following would the value "January 15, 23" be classified as?
The correct answer is C. Option C: Text
Showing questions 281–294 of 294 · Page 15 of 15