Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions
Questions # 11:

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

NOTE: Each correct selection is worth one point.

Question # 11


Expert Solution
Questions # 12:

You are reviewing the data model shown in the following exhibit.

Question # 12

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point

Question # 12


Expert Solution
Questions # 13:

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

You must be assigned the Reader role for the resource group that contains the database.


B.

You must have SELECT access to the Products table.


C.

You must have a user in the database.


D.

You must be assigned the Contributor role for the resource group that contains the database.


E.

Your IP address must be allowed to connect to the database.


Expert Solution
Questions # 14:

Select the answer that correctly completes the sentence.

Question # 14


Expert Solution
Questions # 15:

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

Azure Time Series Insights


B.

Azure HDInsight


C.

Azure Databricks


D.

Azure Log Analytics


Expert Solution
Questions # 16:

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 stages. Each location may be used once, more than 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.

Question # 16


Expert Solution
Questions # 17:

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

Options:

A.

Azure SQL Managed Instance


B.

SQL Server on Azure Virtual Machines


C.

Azure SQL Edge


D.

Azure SQL Database


Expert Solution
Questions # 18:

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options:

A.

native support for cross-database queries and transactions


B.

built-in high availability


C.

system-Initiated automatic backups


D.

support for encryption at rest


Expert Solution
Questions # 19:

Which statement is an example of Data Definition Language (DDL)?

Options:

A.

SELECT


B.

JOIN


C.

MERGE


D.

CREATE


Expert Solution
Questions # 20:

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

NOTE: Each correct selection is worth one point.

Question # 20


Expert Solution
Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions