10 free sample questions from a bank of 298, with the correct answers and explanations. No signup required — start practising right now.
1Which of the following makes data unreadable without a required key?
Anonymization
Role-based access control
Encryption
Masking
Answer: C
2An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after meeting the initial requirements?
Show a mock-up to the team.
Explain the desired level of reporting detail.
Present an analysis of the data.
Find out the project due date.
Answer: A
3A data analysis team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:
Which of the following techniques should the team use for this task?
Standardization
Concatenate
Binning
Appending
Answer: C
4Which of the following pieces of information, if made public, results in a data privacy violation?
Gender
Driver’s license
Age
Employment status
Answer: B
5A data analyst is analyzing the following data set:
Which of the following methods should the analyst use to determine the total cost for each transaction?
Parsing
Scaling
Compressing
Deriving
Answer: D
6A data analyst needs to use one table's data to refine data selection from a second table. Which of the following is the most efficient way?
Subquery
Aggregate
Union
Join
Answer: A
7Which of the following is found in metadata?
Transformations
Data lineage
Syntax
Variable types
Answer: B
8Which of the following allows the transfer of isolated applications to multiple environments?
Virtualization
Version control
Continuous integration
Containerization
Answer: D
9A data breach occurs at a company. Which of the following actions should be taken?
Make an announcement on social media so customers are aware as soon as possible.
Tell the company management team and then tell regulatory agencies.
Keep the incident a secret until the issue is resolved.
Inform the entire IT sector, but ask for discretion.
Answer: B
10A data analyst is modeling a new data warehouse to analyze sales. One of the requirements is to analyze sales by region. Which of the following best describes the region table?