Page 6 of 15 · 294 total questions.
An analyst must obtain the average daily sales for the following week: Which of the following must the analyst perform to obtain this value?
The correct answer is C. Option C: Data aggregation
A data analyst received the information in the table below from a recently completed marketing campaign: Which of the following is the total order conversion rate?
The correct answer is B. Option B: 14.8%
Given the information in the following tables: Online transactions: In-store transactions: Which of the following describes merging these tables to create a master file that includes all transactions for both online and in-store sales?
The correct answer is D. Option D: Data consolidation
Given the image below: The data should be cleaned because of the presence of:
The correct answer is A. Option A: outliers.
Data was previously stored in the following relational tables: A database architect changes the relational database structure to include an additional lookup table, which includes the following: Which of the following MDM issues does this change in structure solve?
The correct answer is A. Option A: Multiple redundant data fields
A data analyst is preparing a presentation for the company’s board of directors. The presentation will not contain any confidential information and will only be provided to the board members. Which of the following is the MOST important information to include in the presentation?
The correct answer is D. Option D: Company branding
An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the following data qualities does this present the GREATEST issue?
The correct answer is A. Option A: Data completeness
Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?
The correct answer is C. Option C: SQL
A data analyst is reviewing the results of a survey. Respondents used the terms “avg,” “average,” and “avg.” throughout the survey in a response for the word “average.” Because of this, the analyst changed all related answers to say “average.” Which of the following are reasons why the analyst MOST likely made these changes? (Choose two.)
The correct answer is B, F. Option B: Data accuracy Option F: Data consistency
A business analyst reviews the following text: txt = “I have registered for a certification exam and will take it within a couple of months. I need to work hard to pass the exam with flying colors.” The analyst then splits the string into two parts: txt1 = “I have registered for a certification exam and will take it within a couple of months.” txt2 = “I need to work hard to pass the exam with flying colors.” Which of the following BEST describes the process the business analyst is following?
The correct answer is D. Option D: String manipulation
A customer’s telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?
The correct answer is C. Option C: Text
A team is planning to automate daily reporting for a company. Prior to this rollout, the team wants to determine how to ensure the data is refreshed at approximately the same time every day. Which of the following would be the BEST step for the team to take to get the data connected and refreshed on a daily automated schedule?
The correct answer is C. Option C: Connect the input to a live connection within the data warehouse that refreshes daily.
Which of the following describes a formal process for acquiring data from websites?
The correct answer is D. Option D: Web scraping
A data analyst needs to survey customers about their preferences for various types of soda. Which of the following sampling methods should the analyst use to collect the survey data?
The correct answer is A. Option A: Simple random sampling
Given the following data set: Which of the following steps would be MOST appropriate to cleanse the data set?
The correct answer is A. Option A: Remove duplicate data.
An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?
The correct answer is C. Option C: A trend analysis
Which of the following is the BEST example of unstructured data?
The correct answer is D. Option D: An audio file
A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?
The correct answer is B. Option B: Variance
A data analyst has received a list of customer names in alphabetical order that needs to instead be put in order by transaction date. Which of the following data manipulation techniques should the analyst use?
The correct answer is C. Option C: Sorting
A data analyst has been asked to find the mean, median, and mode of the distribution in the data shown below: Which of the following is the correct answer?
The correct answer is D. Option D: Mean: 6 -Median: 7 -Mode: 7
Showing questions 101–120 of 294 · Page 6 of 15