- All Exams Instant Download
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...
Which of the following is the BEST way to meet this stakeholder requirement?
A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?...
Which of the following BEST describes the data set?
Refer to the exhibit. Given the following data: Which of the following BEST describes the data set?A . There is data bias.B . The data is incomplete.C . The data is inconsistent.D . The data is outliers.View AnswerAnswer: C Explanation: This is because inconsistency is a type of data quality...
