Page 9 of 15 · 294 total questions.
A company notifies its employees that emails will be automatically moved to a cloud-based server in 180 days. Which of the following describes this concept?
The correct answer is C. Option C: Data retention
An analyst wants to check the progress and performance regarding the number of customers an organization served in the last six years. Which of the following represents the type of analysis the analyst should perform?
The correct answer is B. Option B: Trend analysis
A business unit made the following modification to the values in a table: Which of the following data quality dimensions was applied in this scenario?
The correct answer is D. Option D: Accuracy
A reporting analyst is creating a dashboard that shows the year-over-year performance for a sales organization. Which of the following is the best visual for the analyst use to illustrate the organization's performance?
The correct answer is D. Option D: Line chart
Which of the following query statements would be used when filtering data in a relational database management system? (Choose two.)
The correct answer is B, C. Option B: HAVING Option C: WHERE
Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?
The correct answer is D. Option D: Clustered index
A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?
The correct answer is A. Option A: Role-based
An analyst is working with a data set that lists individuals' first and last names in separate columns. Which of the following processes should the analyst use to combine the first and last names into a single spreadsheet cell?
The correct answer is C. Option C: Concatenate
Explanation
Network address translation maps addresses between networks and commonly lets private hosts share public connectivity.
A data analyst reviews the following data set: Which of the following is the range value?
The correct answer is D. Option D: 13
An analyst is creating a resource to improve users' experience when they select specific records based on particular dates. Which of the following should the analyst use to create a resource that best meets user needs?
The correct answer is B. Option B: Date range
An analyst collected data that includes primary account numbers, expiration dates, and service codes. Which of the following data governance classifications is used to describe this data?
The correct answer is B. Option B: PCI
An analyst in a consumer bank department wants to showcase the concentration of accounts opened in the United States by ZIP Code to describe the effectiveness of the bank's marketing campaigns. Which of the following would be the best way to visualize the data?
The correct answer is D. Option D: A geographic map
A data analyst needs to write a SQL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creating?
The correct answer is D. Option D: Report view
A data analyst was asked to create a visual representation of sales for the first quarter of 2020. Which of the following visualizations should be used when a time element is present?
The correct answer is B. Option B: A line chart
A data analyst received a large amount of third-party data that needs to be joined with in-house data files. After the data is joined, the analyst notices three columns all contain dates. Which of the following should the analyst do to maintain data consistency?
The correct answer is C. Option C: Merge all date columns and unify the format.
A data analyst is helping a retail store categorize its customers into five different groups based on the following information: • How recently the customers made purchases • How frequently the customers made purchases • How much the customers spent Given the following information: Which of the following would be most important for the analysis?
The correct answer is C. Option C: Customer_ID, Order_Date, Amount
Which of the following is a relational database?
The correct answer is A. Option A: SQL
An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should the analyst use?
The correct answer is D. Option D: ELT
A data analyst needs to apply quality control concepts to a data set for accuracy. Which of the following is the best way to do this?
The correct answer is D. Option D: Cross-validation
A client has requested an analysis of all pet care items purchased by current customers and their social media connections in the past 12 months. Which of the following data analysis techniques would be the best choice given these requirements?
The correct answer is C. Option C: Link analysis
Showing questions 161–180 of 294 · Page 9 of 15