- 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...
Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?
A development company is constructing a new unit in its apartment complex. The complex has the following floor plans: Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?A . $640,900B . $690,000C . $705,200D ....
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 of the following descriptive statistical methods are measures of central tendency? (Choose two.)
Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)A . MeanB . MinimumC . ModeD . VarianceE . CorrelationF . MaximumView AnswerAnswer: A, C Explanation: Mean and mode are measures of central tendency, which describe the typical or most common value in a distribution of...
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 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 one of the following tools is least likely to meet her needs?
Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders. Which one of the following tools is least likely to meet her needs?A . QuickSight.B . Tableau.C . Power BI.D . SPSS Modeler.View AnswerAnswer: D Explanation: SPSS Modeler. QuickSight,...
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 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...
Which of the following are the most common issues?
The ACME Corporation hired an analyst to detect data quality issues in their Excel documents. Which of the following are the most common issues? (Select TWO)A . Apostrophe.B . Commas.C . Symbols.D . Duplicates.E . Misspellings.View AnswerAnswer: D, E Explanation:
