Page 12 of 15 · 294 total questions.
A healthcare data analyst is working with data sets containing patient information, medical records, and metrics. The data analyst needs to combine two data sets that have a common field, Patient_ID. Which of the following data manipulation techniques should the analyst use?
The correct answer is D. Option D: Data merge
An analyst is explaining the company's financial systems and reporting tools to a new coworker. Which of the following data quality dimensions are the most important? (Choose three.)
The correct answer is B, E, F. Option B: Data accuracy Option E: Data completeness Option F: Data consistency
A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the following visualizations should the analyst use?
The correct answer is C. Option C: Scatter plot
Which of the following techniques is used to quantify data?
The correct answer is B. Option B: Enumeration -B. Structure
Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?
The correct answer is B. Option B: Date
An employer needs to maintain adequate office staffing during the winter and wants to track storm data. Which of the following data collection methods should the employer use?
The correct answer is B. Option B: Public databases
Which of the following is a characteristic of structured data?
The correct answer is D. Option D: Data is formatted in rows and columns.
Which of the following best describes structured data?
The correct answer is D. Option D: Data that is organized, searched, and queried.
A data analyst is working with a team to create a dashboard for a client who requires on-demand access. Which of the following is the best delivery method to support the client's requirement?
The correct answer is C. Option C: Subscription
A college student has taken four exams in a class. The student hopes to finish the class with a weighted average of at least 90% to get an A. Given the following: With one test remaining, which of the following is the lowest score the student can receive while achieving the desired final grade?
The correct answer is D. Option D: 91.2%
Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?
The correct answer is D. Option D: Many-to-many
An analyst is conducting a survey to measure height. Which of the following is the most likely to decrease as the analyst collects more survey responses?
The correct answer is D. Option D: The confidence interval
An analyst is reviewing a company document to identify why sales have declined over multiple sales quarters. Which of the following analysis techniques should the analyst use?
The correct answer is B. Option B: Trend
A field marketing team needs to assess the relationship between gender and volume of sales. The team provided an analyst with the data to be modified. The data sets are shown below: Which of the following data manipulation techniques did the analyst apply?
The correct answer is A. Option A: Data recoding
A data analyst added some missing data to a list of observations, since only a small amount of the data was absent. Which of the following actions did the data analyst perform?
The correct answer is C. Option C: Append
A director wants a data set that can be used to visualize how various marketing campaigns have performed. The information will be provided by internal and external sources and then compiled to produce the desired data set. Which of the following data techniques should an analyst use to fulfill this request?
The correct answer is C. Option C: Blending
An analyst wants to show the population of each district in a city and the associated crime rates. Which of the following describes the appropriate analytical technique that the analyst should apply?
The correct answer is A. Option A: Descriptive
Which of the following should a developer use to interact with data from external resources?
The correct answer is C. Option C: Application programming interface
Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?
The correct answer is B. Option B: SQL
Given the following data table: Which of the following data editing methods is the best to use to make the data usable for analysis?
The correct answer is D. Option D: Imputation
Showing questions 221–240 of 294 · Page 12 of 15