chp. 4

Question 1

The main on objects in databases are …?

Answer 1

tables. Why?

Question 2

What is one of the major differences between application db’s and data warehouse?

Answer 2

how tables are created. Why?

Question 3

tables in application db’s are made to support..?

Answer 3

applications. Why?

Question 4

tabes in application db’s are mostly …?

Answer 4

static. Why?

Question 5

Tables in a data warehouse are ..?

Answer 5

dynamic. Why?

Question 6

Tables are ….?

Answer 6

products, collections of business logic, and data flows. Why?

Question 7

What is the definition of orchistration?

Answer 7

a set of configurations to automate tasks, jobs, and their dependencies. Why?

Question 8

What can we use to automate table creation process in GCP?

Answer 8

Cloud Composer. Why?

Question 9

What are common data pipline issues?

Answer 9

data duplication, handling taks dependencies, managing connections , handling late data. Why?

Question 10

Cloud composer is …?

Answer 10

an Airflow managed service in GCP. Why?

Question 11

What is unique about Airflow?

Answer 11

you can use python scripts to manage workflows. Why?

Question 12

w.r.t workflow management tools the three main components are…?

Answer 12

Handing task dependencies, Scheduler, System Integration.

Question 13

every airflow task is made for….?

Answer 13

scheduling tasks rather than a one-time job runner. Why?

Question 14

airflow is not a …?

Answer 14

user interface based drag and drop tool. Why?

Question 15

airflow is designed for you … ?

Answer 15

write the workflow using code. Why?

Question 16

all configurations can be managed in a …?

Answer 16

git repository. Why?

Question 17

What does DAG stand for?

Answer 17

Directed acyclic graph

Question 18

What is a DAG?

Answer 18

it is a collection of tasks that are chained together with their dependencies. Why?

Question 19

What is the term for when a dag is running?

Answer 19

DAG run. Why?

Question 20

What is an operator w.r.t a dag?

Answer 20

operators are a collection of connections to different systems. Why?

Question 21

airflow uses operators to …?

Answer 21

define tasks. Why?

Question 22

DAG is …?

Answer 22

Airflow terminology of a job configuration. Why?

Question 23

Before you can use Airlfow/ Cloud composer you will need to …?

Answer 23

setup your cloud composer envirnment. Why?

Question 24

Cloud composer cost is based on ..?

Answer 24

cluster hours. Why?

Question 25

for checking task dependencies you have two visualization options. What are they?

Answer 25

Tree view and Graph view. Why?