Free Data Warehousing on AWS: Data Modeling Questions and Answers

Question 1

What are the atomic facts about entities that we need to know?

Accepted Answer

Attributes

Answer

Entity relationship

Answer

Classes

Answer

Entity integrity

Question 2

A data model is a picture of data.

Accepted Answer

FALSE

Answer

TRUE

Question 3

Data modeling aids in avoiding storing unnecessary data.

Accepted Answer

TRUE

Answer

FALSE

Question 4

Instead than focusing on a data requirement, data modelers concentrate on the operations that are carried out on the data.

Accepted Answer

FALSE

Answer

TRUE

Question 5

The data model's information is used to define

Accepted Answer

Primary and foreign keys

Answer

RDBMS used to store the data

Answer

Data type and length of the column

Answer

Requirements

Question 6

Data abstraction's physical level addresses

Accepted Answer

How data is going to store

Answer

Part of the data in the table

Answer

The relationship between the tables

Answer

What data is going to store

Question 7

An OLTP database is made to handle a business's daily requirements.

Accepted Answer

TRUE

Answer

FALSE

Question 8

Another name for online analytical processing is

Accepted Answer

Decision support processing

Answer

Concurrent control processing

Answer

Transaction control processing

Answer

Online transactional processing

Question 9

A dimensional model is used to store recent data.

Accepted Answer

FALSE

Answer

TRUE

Question 10

A high amount of detail is stored in OLTP.

Accepted Answer

TRUE

Answer

FALSE