D900_5

Descriptive analytics tells you:

• ​what is most likely to happen in the future

• ​what occurred in the past

• ​which actions you can perform to affect outcomes

• ​why something occurred in the past

An ETL Process requires

• ​a matching schema in the data source and data target

• ​a target data store powerful enough to transform the data

• ​data that is fully processed before being loaded in the target data store

• ​that the target store be relational data store

Relational databases use ---------- to enforce relationship among tables

• ​keys

• ​columns

• ​partitions

• collections

A virtual table that defines content defined by a query

• ​index

• ​views

• ​heap

• ​stored procedure

Select the correct option:

• ​A database object that holds data - Table

  A database object whose content is defined by a query -View

  A database object that helps to improve the speed of data retrieval- Index

• A database object that holds data - ViewA

  database object whose content is defined by a query -Table

  A database object that helps to improve the speed of data retrieval- Index

• A database object that holds data - View

  A database object whose content is defined by a query -Index

  A database object that helps to improve the speed of data retrieval- Table

Select all that is TRUE

• ​You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics

• You can use Azure Data Studio to query Microsoft SQL server big data cluster

• ​You can use MYSQL workbench to query Azure Databases with Maria DB

Select the correct option for data stores and appropriate scenarios:

• ​Application users and their default language - key value

  Medical Image and their associated metadata - Object

  Employee data that shows relationship between employees - Graph

• Application users and their default language - Object

  Medical Image and their associated metadata - key value

  Employee data that shows relationship between employees - Graph

• Application users and their default language - Object

  Medical Image and their associated metadata - Graph

  Employee data that shows relationship between employees - key value

Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

• ​the throughput

• the read region

• ​the partition key

• ​the API

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

• ​Archive

• ​Hot

• Cool

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

• ​document

• ​columnar

• graph

• time series