DP-900

Descriptive analytics tell you

• what is most likely to occur in future

• what occured in the past

• Which actions you can perform to affect outcomes

• why something occurred in the past

An extract, transform, and load (ETL) process

• A matching schema in the data source and the target data

• A target data store powerful enough to transform data

• Data that is fully processed before being loaded to the target data store

• That the data target be a relational database

An extract, load and transform (ELT) process

• A separate transformation engine

• A target data store powerful enough to transform data

• Data that is fully processed before being loaded to the target data store

• A data pipeline that includes a transformation engine

A relational database is appropriate for scenarios that involve a high volume of

• Changes to relationships between entities

• Geographically distributed writes

• Transactional writes

• Writes that have varying data structures

Text to speech is an example of ______ analytics

• cognitive

• descriptive

• predictive

• prescriptive

A visualization that shows a university’s current student enrolment versus the maximum capacity is an example of ________ analytics.

• cognitive

• descriptive

• predictive

• prescriptive

Relational data uses ____ to enforce relationships between different tables.

• Collections

• columns

• keys

• partitions

A chart that shows the relationship between two numerical values

• Tree map

• bar chart

• key influencer

• scatter

A chart of colored rectangles that displays individual data points represented by the size and color of a relative rectangle

• Tree map

• waterfall

• ribbon

• scatter

Platform as a service (PaaS) database offerings in azure provide built-in high availability

• Yes

• No