- All Exams Instant Download
Which of the following are reasons to create and maintain a data dictionary? (Choose two.)
Which of the following are reasons to create and maintain a data dictionary? (Choose two.)A . To improve data acquisitionB . To remember specifics about data fieldsC . To specify user groups for databasesD . To provide continuity through personnel turnoverE . To confine breaches of PHI dataF . To...
Which of the following date ranges should be on the report?
A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?A . January 1, 2020...
Which of the following data schemas shown?
Refer to the exhibit. Given the diagram below: Which of the following data schemas shown?A . Key-value pairsB . Online transactional processingC . Data LakeD . Relational databaseView AnswerAnswer: D Explanation: A relational database is a type of database that organizes data into tables, where each table has a fixed...
The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:
The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:A . a t-test.B . a performance analysis.C . an exploratory data analysis.D . a link analysis.View AnswerAnswer: C Explanation: This is because exploratory data analysis is...
Which of the following summary statements upholds integrity in data reporting?
Refer to the exhibit. Given the following graph: Which of the following summary statements upholds integrity in data reporting? A. Sales are approximately equal for Product A and Product B across all strategies. B. Strategy 4 provides the best sales in comparison to other strategies. C. While Strategy 2 does...
Which of the following formats would be the MOST efficient way to deliver this report?
A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?A . A workbook with multiple tabs for each regionB . A daily email with snapshots of regional...
Which of the following steps should be taken to ensure data consistency?
While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?A . Delete any of the responses that do not have “January” written out.B . Replace any of the...
Which of the following would be used to store unstructured data from different sources?
Which of the following would be used to store unstructured data from different sources?A . A data lakeB . A database management systemC . A databaseD . A data warehouseView AnswerAnswer: A Explanation: This is because a data lake is a type of storage system that stores unstructured data from...
Which of the following report types should the data analyst create?
A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types...
If the report will be published on November 1, 2020, which of the following months shouts the report cover?
A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?A . October 1, 2019 to October 31, 2020B . October 31, 2020...
