- All Exams Instant Download
Which of the following should an analyst suggest so the user has a dynamic, seamless experience?
A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?A . Create multiple reports, one for...
Which of the following should the data analyst use to BEST communicate this information to the manager?
A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?A...
Which of the following functions will allow the data analyst to organize the table in this manner?
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 formattingB . GroupingC...
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...
