Data Analytics Final Paper Exam Questions Accurate Answers Full Solution.pdf

DATA ANALYTICS FINAL PAPER EXAM QUESTIONS ACCURATE ANSWERS FULL SOLUTION




Question:
Database schema.

Answer:
describes the logical or physical structure of a relational database



Question:
Extract Step 2.

Answer:
Identify tables and attributes you need to answer your question. Include Primary Keys, Foreign
Keys, and Non- Key Attributes.



Question:
Extract Step 3.

Answer:
Refer to the data dictionary



Question:
Data dictionary.

Answer:
defines each attribute's characteristics, including name, description, data type, size, and notes.



Question:
Extract Step 4.

, Answer:
Access a data warehouse or make a request for data. When you make a data request you will receive
a data extract stored in a series of flat delimited files, such as a comma-separated value (CSV) file or
XML file.



Question:
Data warehouse.

Answer:
a central location of a copy of a firm's master and transaction data that is typically refreshed on a
daily basis



Question:
Delimited file.

Answer:
a flat file that contains database values that are separated (delimited) by a special character, such as
a comma, tab, or space



Question:
Comma-separated value (CSV) file.

Answer:
a flat file containing values separated by commas



Question:
Tab-separated text file (TXT) file.

Answer:
a flat file containing values separated by TAB characters



Question: