- All Exams Instant Download
Which of the following is an example of a at flat file?
Which of the following is an example of a at flat file?A . CSV fileB . PDF fileC . JSON fileD . JPEG fileView AnswerAnswer: D
Which of the following BEST describes standard deviation?
Which of the following BEST describes standard deviation?A . A measure that is used to establish a relationship between two variablesB . A measure of how data is distributedC . A measure of the amount of dispersion of a set of valuesD . A measure that is used to find...
Which of the following string manipulation commands will combine the address and region name columns to create a full address?
Consider the following dataset which contains information about houses that are for sale: Which of the following string manipulation commands will combine the address and region name columns to create a full address? full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40...
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...
