Page 11 of 15 · 294 total questions.
An analyst wants to create a historical data set for the past five years with each year in its own data set. Which of the following methods is the best way to create this historical data set?
The correct answer is C. Option C: Data append
A data set for sales per month includes the following data: Which of the following cleaning and profiling methods should be applied to the data set?
The correct answer is D. Option D: Data type validation
Which of the following data types best describe 4Ac1? (Choose two.)
The correct answer is A, F. Option A: Alphanumeric Option F: String
A user wants a dynamic report that presents a moving average of sales throughout the company's history and also for select periods. Which of the following attributes should the report include?
The correct answer is B. Option B: Date range
A user needs a live report that always displays the current week performance and can also show the past weeks, months, and years performance for all time, if needed. Which of the following requirements should be considered for this report?
The correct answer is C. Option C: Reference dates
A sales director wants a report that provides a view into company sales over multiple quarters in order to gain a better understanding of trends. Which of the following report types would best achieve this objective?
The correct answer is C. Option C: Analytical
Which of the following activities is most likely performed during data preparation in the ETL process?
The correct answer is C. Option C: Removing data duplicates
Which of the following data quality features can be added to a technology platform?
The correct answer is D. Option D: Data integration
A membership organization wants to determine whether renewals have declined in specific regions over the past three years. Which of the following types of analysis would be best for the organization to use to help make this determination?
The correct answer is D. Option D: Trend analysis
A manager would like to see a report that details lost deals for the week. Which of the following report delivery methods best supports this requirement?
The correct answer is A. Option A: Ad hoc
A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the combined sales for all regions. Which of the following would be the most efficient method for meeting the requirements?
The correct answer is A. Option A: Creating a single report with a region filter
After returning from a vacation, a sales manager finds multiple hard copies of the prior week's sales report on a desk with the same date but different information. Which of the following best indicates which report has the correct data?
The correct answer is C. Option C: Data refresh date
A healthcare data analyst notices that one data set in the column for Blood_Pressure contains several outliers that need to be replaced with meaningful values. Which of the following data manipulation techniques should the analyst use?
The correct answer is B. Option B: Impute
Which of the following data types is the "number of packages delivered" an example of?
The correct answer is B. Option B: Discrete
Which of the following is a key feature of a temporary table?
The correct answer is A. Option A: Temporary tables are dropped automatically when the query session is closed.
An intern needs to compile a report that will be used in a customer proposal at the end of the month. Which of the following best describes the type of report the intern should use?
The correct answer is C. Option C: Static
Which of the following is an example of a structured data type?
The correct answer is C. Option C: SQL database
An analyst is working with a data set that contains information regarding refugee status, income, identification numbers, place of residence, and employment status. The analyst needs to randomize placeholders for all the variables in a data set so that the information is useless in the event of a breach but is still useful in producing the necessary reports. Which of the following functions is the analyst performing?
The correct answer is B. Option B: Data masking
A data analyst has removed the outliers from a data set due to large variances. Which of the following central tendencies would be the best measure to use?
The correct answer is B. Option B: Mean
An analyst wrote the following code: Which of the following formats did the analyst use?
The correct answer is C. Option C: XML
Showing questions 201–220 of 294 · Page 11 of 15