GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

5

Jake Jakes 9 Fragen

Quiz starten

Fragen in diesem Quiz (9)

  1. 1Which of the following statements about star schemas is incorrect?
    1. ACompared to fact tables, dimension tables typically have fewer instances and more columns.
    2. BTo make the slicing and dicing of the data easier, most measures are defined as part of the dimension tables.
    3. CFact tables represent business transactions.
    4. DThe grain represents the granularity level of a fact table.
    5. EDimension tables are used for what, when, and who analysis.
  2. 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
    1. A1,2,3,4
    2. B1 & 3
    3. C1,2,4
    4. D1 & 2
  3. 3Data cleaning can involve adding, modifying, and deleting data. In which of the following examples would data modifying be required?
    1. ADuring your analysis of purchase orders, you note that some of the orders include the vendor phone number.
    2. BA file of purchase orders is missing one month of purchase orders.
    3. 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.
    4. 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.
  4. 4A data dictionary is
    1. 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.
    2. 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
    3. Ca chart that indicates the column name, a brief description of content, whether the column is a measure or a dimension.
    4. Da chart that indicates the column name, the source of the data, whether the column is a measure or a dimension.
  5. 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?
    1. AHao has identified an instance of data that is not sizable.
    2. BHao has identified an instance of data that is incorrect.
    3. CHao has identified an instance of data that is inconsistent.
    4. DHao has identified an instance of data that is invalid.
  6. 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?
    1. AAbandon the project because the data are not valid and cannot be analyzed.
    2. BPut the relevant, irrelevant, reliable, and unreliable data in separate columns.
    3. CUnpivot the column so that the data are separated into distinct fields.
    4. DRemove the column with irrelevant or unreliable data
  7. 7To restructure a composite column you should
    1. Asplit the column data into separate columns
    2. Bcreate a separate table.
    3. Cmove the column to another table.
    4. Dremove the column data that is not needed
  8. 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?
    1. AThe primary and foreign key fields must have the same name.
    2. BThe primary key must be single-valued, but the foreign key can be multi-valued
    3. CThe primary and foreign key fields can have different data types.
    4. DAll values in a foreign key should also exist as values in the corresponding primary key.
  9. 9Hamza is transferring data into an analytical database for analysis. Which steps should he take to identify whether all the data transferred?
    1. AEstablish data validation rules and identify which data do not comply with the data validation rules.
    2. BReview the columns for appropriate naming conventions.
    3. CCompare the row count for the analytical database with the row count of the data set in the ETL tool.
    4. DInspect distinct values and analyze frequencies.

Informationen

Beschreibung
University acc Quiz am 5, erstellt von Jake Jakes am 15/12/2024.
Sprache
English
Aufrufe
0
Schlagwörter
accuniversity
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck