Test
5
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (9)
1Which of the following statements about star schemas is incorrect?
- ACompared to fact tables, dimension tables typically have fewer instances and more columns.
- BTo make the slicing and dicing of the data easier, most measures are defined as part of the dimension tables.
- CFact tables represent business transactions.
- DThe grain represents the granularity level of a fact table.
- EDimension tables are used for what, when, and who analysis.
2Which of the following statements about data transformation are correct?
1. Data transformation has three subprocesses: cleaning, restructuring, and integration.
2. Cleaning aims to correct data anomalies.
3. Restructuring does not change any data, just the way they are organized.
4. Integration links the data together by defining relationships- A1,2,3,4
- B1 & 3
- C1,2,4
- D1 & 2
3Data cleaning can involve adding, modifying, and deleting data. In which of the following examples would data modifying be required?
- ADuring your analysis of purchase orders, you note that some of the orders include the vendor phone number.
- BA file of purchase orders is missing one month of purchase orders.
- CWhile examining the purchase orders data, you note that the vendor's name, street address, city and state are listed in separate columns. In some cases, the state column displays the state name, in other cases the state abbreviation is shown.
- DYou are preparing an analysis of how many purchase orders are greater than $500. The file you are working with has a row at the beginning of each new month with the month name listed in the date column. There is no other data in the row with the month name.
4A data dictionary is
- Aa chart that indicates the column name, a brief description of content, the data type, and whether or not the field is a calculated column.
- Ba chart that indicates the column name, a brief description of content, the data type, whether the field is a primary or foreign key, and whether the field is mandatory or option
- Ca chart that indicates the column name, a brief description of content, whether the column is a measure or a dimension.
- Da chart that indicates the column name, the source of the data, whether the column is a measure or a dimension.
5Hao, an accounts receivable analyst, is reviewing the customer master file for use in an analysis project. He noticed that in the Address field one customer's state is listed as NM, while another customer's state is listed as New Mexico. Which of the following is true?
- AHao has identified an instance of data that is not sizable.
- BHao has identified an instance of data that is incorrect.
- CHao has identified an instance of data that is inconsistent.
- DHao has identified an instance of data that is invalid.
6Lizelle is a financial analyst preparing an analytical database to analyze manufacturing data to determine the most efficient processes. She is currently identifying irrelevant and unreliable data in columns within a table. Which of the following is the most appropriate response when she identifies irrelevant or unreliable data?
- AAbandon the project because the data are not valid and cannot be analyzed.
- BPut the relevant, irrelevant, reliable, and unreliable data in separate columns.
- CUnpivot the column so that the data are separated into distinct fields.
- DRemove the column with irrelevant or unreliable data
7To restructure a composite column you should
- Asplit the column data into separate columns
- Bcreate a separate table.
- Cmove the column to another table.
- Dremove the column data that is not needed
8Mithali, a financial analyst, is preparing data to engage in a data analysis project to predict revenue for the next period based on 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?
- AThe primary and foreign key fields must have the same name.
- BThe primary key must be single-valued, but the foreign key can be multi-valued
- CThe primary and foreign key fields can have different data types.
- DAll values in a foreign key should also exist as values in the corresponding primary key.
9Hamza is transferring data into an analytical database for analysis. Which steps should he take to identify whether all the data transferred?
- AEstablish data validation rules and identify which data do not comply with the data validation rules.
- BReview the columns for appropriate naming conventions.
- CCompare the row count for the analytical database with the row count of the data set in the ETL tool.
- DInspect distinct values and analyze frequencies.
Información
- Descripción
- University acc Test sobre 5, creado por Jake Jakes el 15/12/2024.
- Autor
- Jake Jakes
- Idioma
- English
- Visitas
- 0
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test