Podcast
Questions and Answers
Wild-code checking and consistency checking are techniques for what?
Wild-code checking and consistency checking are techniques for what?
- Cleaning data (correct)
- Coding modification
- Data entry
- Data modification
Which of the following can be used to monitor a business, offering a combined view of their most-important metrics at a glance?
Which of the following can be used to monitor a business, offering a combined view of their most-important metrics at a glance?
- Catalogue
- Metadata
- Data Mart
- Dashboard (correct)
For what reason might you TYPICALLY compare a dataset with other sources during data validation?
For what reason might you TYPICALLY compare a dataset with other sources during data validation?
- To increase the accessibility of data
- To ascertain the history of the dataset
- To help certify the data quality (correct)
- To understand a process used to transfer the dataset
Which of the following will the below query return from the 'product' table? SELECT TOP 3 * FROM Product;
Which of the following will the below query return from the 'product' table? SELECT TOP 3 * FROM Product;
What is the MAIN purpose of data integration from different sources?
What is the MAIN purpose of data integration from different sources?
Which term defines whether or not all data that is necessary to meet current and future business information demand is available within the data resource?
Which term defines whether or not all data that is necessary to meet current and future business information demand is available within the data resource?
What is NOT involved in a performance stress test?
What is NOT involved in a performance stress test?
The R programming language includes functions that support which of the following?
The R programming language includes functions that support which of the following?
Which of the following is NOT a type of Join in SQL?
Which of the following is NOT a type of Join in SQL?
In Excel, which of the following is NOT a recognized data preparation technique?
In Excel, which of the following is NOT a recognized data preparation technique?
Which of the following is NOT TRUE about Data Profiling?
Which of the following is NOT TRUE about Data Profiling?
What is the likelihood that a relationship between TWO or more variables is caused by something other than random chance referred to as?
What is the likelihood that a relationship between TWO or more variables is caused by something other than random chance referred to as?
Which of the following is a consequence of maintaining and improving data quality?
Which of the following is a consequence of maintaining and improving data quality?
In SQL, which clause combines all records that have identical values in a particular field?
In SQL, which clause combines all records that have identical values in a particular field?
What is the MAIN purpose of data integration from different sources?
What is the MAIN purpose of data integration from different sources?
Which of the following is the correct process of loading data from the source system to a data warehouse?
Which of the following is the correct process of loading data from the source system to a data warehouse?
Which of the following are TYPICAL benefits of synchronizing data?
Which of the following are TYPICAL benefits of synchronizing data?
When would UAT TYPICALLY be performed on a piece of software?
When would UAT TYPICALLY be performed on a piece of software?
Which data quality dimension ensures that data has undergone cleansing to ensure it is correct and useful?
Which data quality dimension ensures that data has undergone cleansing to ensure it is correct and useful?
What is the process of loading data from the source system to a data warehouse called?
What is the process of loading data from the source system to a data warehouse called?
