Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

DP-900 Exam Dumps - Microsoft Azure Data Fundamentals

Go to page:
Question # 17

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 18

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

A.

Azure Functions

B.

Microsoft SQL Server Integration Services (SSIS)

C.

PolyBase

D.

Azure Data Factory

Full Access
Question # 19

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Full Access
Question # 20

Match the Azure services to the appropriate locations in the architecture.

To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Full Access
Question # 21

Select the answer that correctly completes the sentence.

Full Access
Question # 22

What is a characteristic of a non-relational database?

A.

a fixed schema

B.

self-describing entities

C.

full support for Transact-SQL

Full Access
Question # 23

Select the answer that correctly completes the sentence.

Full Access
Question # 24

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? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Full Access
Go to page: