Unit 3 Test Review

Question 1

An analyst uses software to analyze data in a company’s data warehouse and produce information presented in understandable charts and graphs on a dashboard. This information is used to inform decisions in the organization.

Which software is used to conduct this data mining for presentation of the information?

Answer 1

Business intelligence

Question 2

Which term describes the field that provides a link between two tables in a relational database table?

Answer 2

Foreign key

Question 3

Which tool allows large data sets to be stored and processed across multiple servers?

Answer 3

Spark

Question 4

Which term is used to refer to the process of combining structured, unstructured, and semi-structured data into a data warehouse structure?

Answer 4

Data normalizing

Question 5

Which technique is used to ensure data accuracy for marketing?

Answer 5

Segmentation