DP 900 - pt 10

You have an on-premises Microsoft SQL Server database. You need to migrate the database to the cloud. The solution must meet the following requirements:

Minimize maintenance effort.

Support the Database Mail and Service Broker features.

What should you include in the solution?

• Azure SQL Database single database

• Azure SQL Database elastic pool

• . Azure SQL Managed instance

• SQL Server on Azure virtual machines

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

• data is processed before loaded to target data sto
• matching schema in data surce and data target
• target data store powerful enough to transform dat
• data target be relational database

Batch workloads ​ (a)  

• collect data & process data when condition met
• always processed data in memory, row by row
• collect & process data most once a day
• process data as new data is received in real time

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process?

a

b

c

CRM system

data warehouse

standalone data analysis tool

Descriptive analytics tells you ​ (a)  

• what occured in the past
• what is most likely to happen in the future
• which actions you can perform to affect outcomes
• why something occured in the past

What is a function of a modern data warehouse?

• supports batch processing only

• . supports real-time and batch processing

• provides built-in or native online analytical processing

• stores raw data only

Azure Storage account must have ​ (a)   enabled to support Azure Data Lake Storage

• hierarchical namespace
• blob soft delete
• large file shares
• versioning

What can be used with native notebook support to query and visualize data by using a web-based interface?

• . Azure Databricks

• . pgAdmin

• Microsoft Power BI

Which format was used?

• XML

• HTML

• YAML

• JSON

• JSON

• YAML

• HTML

• XML