- All Exams Instant Download
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...
Consider this dataset showing the retirement age of 11 people, in whole years:
Consider this dataset showing the retirement age of 11 people, in whole years: 54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60 This tables show a simple frequency distribution of the retirement age data. A . 56B . 55C . 57D . 54View AnswerAnswer: D Explanation: A measure...
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...
