Data Engineering Fundamentals

Question 1

Three different types of data models are listed below, EXCEPT:

Accepted Answer

Schema Data Model

Answer

Logical Data Model

Answer

Conceptual Data Model

Answer

Physical Data Model

Question 2

The process of normalizing a data model is one of the steps in data modeling, particularly in...

Accepted Answer

Logical Data Model

Answer

Conceptual Data Model

Answer

Schema Data Model

Answer

Physical Data Model

Question 3

We need data engineers for a number of reasons, EXCEPT:

Accepted Answer

Various Capabilities

Answer

Various Data Format

Answer

Various Data Sources

Answer

Various Technologies

Question 4

Which of the following is NOT a part of the ETL / ELT process:

Accepted Answer

Export

Answer

Extract

Answer

Transform

Answer

Load

Question 5

The following are components of the Data Pipeline in which Data Engineers play a significant role in:

Accepted Answer

Collect and Prepare Data

Answer

Prepare and Visualize Data

Answer

Analyze and Visualize Data

Answer

Collect and Analyze Data

Question 6

Which of the following is NOT a common source of big data?

Accepted Answer

Official Statistics Surveys

Answer

Google Trends

Answer

Sensors

Question 7

Which of the following commands belongs to the data manipulation language?

Accepted Answer

Select, Insert, Delete

Answer

Rollback, Commit

Answer

Alter, Create, Drop

Answer

Grant, Revoke