Bu 258 ch 5 quizz

Which of the following statements about data transformation are correct? 1. Data transformation has three so processes call Lynn cleaning, restructuring, and integration 2. Cleaning aims to correct at anomalies. 3. Restructuring does not change any data, just the way they organized. 4. Integration links the data together by defining relationships.

1,2,3,4

Mithali, as financial analyst, is preparing data to engage in a data analysis project to predict revenue for the next period based one environmental considerations. She is currently reviewing the tables to validate inter-table rules for referential integrity. Which of the following is true about referential integrity?

All values in a foreign key should also exist as values in the corresponding primary key.

Hamza is transferring data into an analytical database for analysis. Which steps should he take to identify whether all the data transferred?

Compare the row count for the analytical database with the row count of the data set in the ETL tool

Validation of data transfers is done by comparing the source data with the data in the ETL tool. Which of the following statements about data transfer is incorrect?

Comparing column headers helps validate both completeness and accuracy

Which of the following terms describes the process of profiling, cleaning, restructuring, and integrating data prior to processing and analysis?

Data preparation

Hao, and accounts receivable analyst, is reviewing the customer master file for use in an analysis project. He noticed that in the address field one customer state is listed as NM, while another customer's star is listed as New Mexico. Which of the following is true?

Hao has identified an instance of data that is inconsistent

Which of the following statements is true about establishing a primary key in a table?

Primary keys must have a unique value for each row and have no null values

Lizelle is a financial analyst preparing an analytical data base to analyze manufacturing data to determine the most efficient processes. She's currently identifying irrelevant and unreliable data and columns within a table. Which of the following is the most appropriate response when she identifies irrelevant or unreliable data.

Remove the column with irrelevant or unreliable data

To restructure a composite column you

Split the column data into separate

Which of the following statements about star schemas is incorrect?

To make slicing data, easier, most measures are defined as part of the dimension tables

Data cleaning can involve aaron, modifying, and deleting data. In which of the following examples with data modifying be required?

While examining the purchase orders data, you note that the vendors name, street address, city and state are listed in separate columns. In some cases, the state column displays the state name, and other places the state abbreviation is shown.