DP-900

To complete the sentence, select the appropriate option in the answer area.

An Extract, Transform, and Load (ETL) Process requires?

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

• The 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 relational database.

Answer explanation

Extract, Transform and Load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

Match the type of workloads to the appropriate scenarios.

• Batch

• Data for a product catalog will be loaded every 12 hours to a Datawarehouse.

• Streaming

• Updates to the inventory data will be loaded to a Datawarehouse every 1 million Transactions.

• Batch

• Thousands of data sets per second for online purchases will be loaded into a Datawarehouse in real time.

Answer explanation

Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

Stream processing is a big data technology that allows us to process data in real time as they arrive.

In Batch processing,​ ​ (a)  

• latency is expected.
• data is always inserted one row at a time.
• data is processed in real-time.
• processing can only execute serially.

Answer explanation

Azure Batch is especially well suited to running large-scale parallel and high-performance computing (HPC) batch jobs. The service handles everything for you -- managing and scheduling all the nodes and applications required to run your scenarios.

Transcribing audio files is an example of ​​​ (a)   analytics.

• cognitive
• descriptive
• predictive
• prescriptive
• diagnostic

Answer explanation

Transcribe means converting from audio to text. "Cognitive" in Azure fundamentals means using smart tools that can understand and interact with things like images, speech, and language.

Descriptive: What's happening.

Diagnostic: Why's Happening.

Predictive: What will happen.

Prescriptive: What actions should we take.

To complete the sentence, select the appropriate option.

A visualization that shows a university's current student enrollment versus the maximum capacity is an example of ​ (a)   analytics.

• Descriptive
• cognitive
• predictive
• Prescriptive

Answer explanation

Descriptive: What's happening?

Match the type of visualizations to the appropriate Description.

• Scatter

• The chart that shows the relationship between two numerical values.

• Key Influencer

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

• TreeMap

• A chart that displays the major contributors of the selected result or value.

Identify one or more true statements from the following three options.

• Extract, Transform, and Load (ETL) can reduce the transfer of sensitive data to the destination systems.

• Extract, Load, and Transform (ELT) transforms data by using a compute resource Independent of source system and destination system.

• Extract, Load, and Transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

Answer explanation

Yes - ETL You can reduce the sensitive data with transformations on data source.

No - ELT Actually use the compute resource from destination system.

Yes - ELT Minimizes the time with transformations are going to be processed on target data destination systems.

You need to modify a view in a relational database by adding a new column.

which statement should you use?

• Merge

• Alter

• Insert

• Update

Answer explanation

Alter is used to change the table structure in relational database.

Identify one or more true statements from the following three options.

• Platform as a service (PaaS) database offering in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offering.

• Platform as a service (PaaS) database offering in Azure provides end users with the ability to control and update the operating system versions.

• All relation and non-relational platform as a service (PaaS) database offering in Azure can be paused to reduce Cost.

Answer explanation

PaaS is designed to support the complete web application lifecycle: Building, testing, deploying, managing, and updating. It lets you skip the hassle and cost of buying and handling software license, managing infrastructure, dealing with development tools and other recourses.

You manage the applications and services you develop, and cloud service provider typically manages everything else.

There really is no way to Pause/Stop Billing for your SQL Database.