DP-900 pt 1

Descriptive analytics tells you ​ ​ (a)  

• what occured in the past
• what most likely to appear on the future
• which action you can perform to affect outcome
• why something occured in the past

• yes

• no

• yes

• no

• yes

• no

An extract, transform and load (ETL) process requires ​ (a)   ​ ​ ​

• data is processed before load to target data store
• data target be relational database
• target data store powerful to transform data
• matching schema in data source & data target

In batch processing, ​ (a)  

• latency in delivering data result is acceptable
• data is processed in real time
• data is always inserted one row at a time
• processing can only execute serially

transcribing audio file is an example of ​ (a)   analytics

• cognitive
• descriptive
• predictive
• prescriptive

Match the types of analytics that can be used to answer the business questions.

c

a

d

predictive

diagnostic

cognitive

prescriptive

descriptive

customer is ​ (a)  

address is ​ ​ (b)  

social media is ​ (c)  

• root object
• nested array
• nested object

the data model is ​ (a)  

customer is ​ (b)  

• star schema
• transactional model
• snowflake schema
• dimension
• fact
• bridge