Page 8 of 15 · 294 total questions.
Which of the following would be the BEST way to identify multicollinear attributes in a data set?
The correct answer is A. Option A: Correlation coefficient
Which of the following describes the use of a representative amount of data from a main repository?
The correct answer is D. Option D: Sampling
An analyst is updating a customer contacts database with information obtained from a survey of new customers. Which of the following data manipulation techniques should the analyst use?
The correct answer is B. Option B: Append
Which of the following is the best description of discrete data types?
The correct answer is B. Option B: The frequency of the number of times each value occurs by using whole numbers
Which of the following data governance concepts fits into the security requirements category?
The correct answer is A. Option A: Data transmission This option keeps traffic private / properly secured as required.
A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations must a data analyst take into account when creating the dashboard?
The correct answer is B. Option B: Drill-down capability
An analyst develops an IT document and needs to describe the technical terms used in the document. Which of the following is where the analyst should include descriptions of the technical terms?
The correct answer is A. Option A: Glossary
The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?
The correct answer is C. Option C: The report included the previous month's data.
An analyst is reporting on the average income for a county and is reviewing the following data: Which of the following is the reason the analyst would need to cleanse the data in this data set?
The correct answer is A. Option A: Data completeness
Which of the following should an analyst do to best summarize the data on a data set?
The correct answer is B. Option B: Aggregation
Which of the following data types must be used when working with variables that require classification into two or more groups before analysis?
The correct answer is D. Option D: Categorical
An organization would like to add a secondary email field to its customer database in order to enrich the customer profiles. Which of the following data manipulation techniques should the analyst use to add this information?
The correct answer is B. Option B: Merge
Which of the following is the best variable format to store a customer's age using the least possible amount of storage data?
The correct answer is A. Option A: Int
A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture this information?
The correct answer is B. Option B: Boolean
A data analyst has a set of data that shows the number of gallons of oil produced each day. The company would like to know the standard deviation for the data set. The variance for the data is 36 gallons. Which of the following is the standard deviation for gallons produced?
The correct answer is B. Option B: 6
A gambler thinks that a coin is fair and is equally likely to turn up heads or tails when the coin is flipped. Which of the following tests should the gambler use to test this hypothesis?
The correct answer is B. Option B: Chi-squared test
An analyst needs to summarize the number of people in Chicago in 2022 using the following set of data: Which of the following steps should the analyst use to provide results? (Choose two.)
The correct answer is A, C. Option A: Aggregation Option C: Filtering
An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?
The correct answer is D. Option D: Transpose
Which of the following programming languages are best suited for analysis and machine-learning applications? (Choose two.)
The correct answer is D, F. Option D: Python Option F: R
Which of the following is most likely to be used as a data-mining ETL tool?
The correct answer is A. Option A: SSIS
Showing questions 141–160 of 294 · Page 8 of 15