- All Exams Instant Download
Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?
Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?A . Missing dataB . Duplicate dataC . Redundant dataD . Invalid dataView AnswerAnswer: B Explanation: This is because duplicate data refers to data that is repeated or copied in a data set, which can...
Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?
A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table - In-store Transactions C Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated,...
Which of the following contains alphanumeric values?
Which of the following contains alphanumeric values?A . 10.1Ε²B . 13.6C . 1347D . A3J7View AnswerAnswer: D Explanation: Alphanumeric values are values that contain both letters and numbers, such as A3J7. The other options are numeric values, as they contain only numbers, such as 10.1E2, 13.6, and 1347. Reference: Guide...
Which of the following types of charts should be considered to BEST display the data?
An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts should be considered to BEST display the data?A ....
Which of the following is the mean?
Refer to the exhibit. A data analyst needs to calculate the mean for Q1 sales using the data set below: Which of the following is the mean?A . $2,466.18B . $2,667.60C . $3,082.72D . $12,330.88View AnswerAnswer: C Explanation: The mean is the average of all the values in a data...
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...
