- All Exams Instant Download
Which of the following is the mean height for the five dogs?
Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the following is the mean height for the five dogs?A . 394mmB . 405mmC . 493mmD . 504mmView AnswerAnswer: A Explanation: The mean height for the five dogs is calculated by adding up all the...
Which of the following functions did the analyst use to generate the data in the Sales_indicator column?
An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000: Which of the following functions did the analyst use to generate the data in the Sales_indicator column?A . AggregateB . LogicalC . DateD . SortView AnswerAnswer: B...
Which one of the following in NOT a common data integration tool?
Which one of the following in NOT a common data integration tool?A . XSSB . ELTC . ETLD . APIsView AnswerAnswer: A Explanation: Cross-site Scripting (XSS) is a security vulnerability usually found in websites and/or web applications that accept user input. XSS is a client-side vulnerability that targets other application...
Which of the following is a control measure for preventing a data breach?
Which of the following is a control measure for preventing a data breach?A . Data transmissionB . Data attributionC . Data retentionD . Data encryptionView AnswerAnswer: D Explanation: This is because data encryption is a type of control measure that prevents a data breach, which is an unauthorized or illegal...
Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?
Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?A . NumericB . DateC . FloatD . TextView AnswerAnswer: D Explanation: A telephone number formatted as XXX-XXX-XXXX would be considered a text data type, as it is composed of alphanumeric characters and symbols. A numeric...
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...
