New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

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

Viewing page 1 out of 10 pages
Viewing questions 1-10 out of questions
Questions # 1:

Match the database normalization terms to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Question # 1


Expert Solution
Questions # 2:

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Options:

A.

Azure SQL Database Hyperscale


B.

Azure SQL managed instance


C.

Azure SQL Database serveless


D.

Azure SQL Database elastic pod


Expert Solution
Questions # 3:

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

Question # 3


Expert Solution
Questions # 4:

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

Options:

A.

Azure Databricks


B.

pgAdmin


C.

Microsoft Power Bl


Expert Solution
Questions # 5:

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

Options:

A.

Microsoft SQL Server Data Tools (SSDT)


B.

Microsoft SQL Server Management Studio (SSMS)


C.

Azure Databricks


D.

Azure Data Studio


Expert Solution
Questions # 6:

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 # 6


Expert Solution
Questions # 7:

Match the Azure Cosmos DB APIs to the appropriate data structures.

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

NOTE: Each correct match is worth one point.

Question # 7


Expert Solution
Questions # 8:

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Options:

A.

isolation


B.

durability


C.

atomicity


D.

consistency


Expert Solution
Questions # 9:

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

NOTE: Each correct selection is worth one point.

Options:

A.

Azure Databricks


B.

Azure Log Analytics


C.

Azure Time Series Insights


D.

Azure HDinsight


Expert Solution
Questions # 10:

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 # 10


Expert Solution
Viewing page 1 out of 10 pages
Viewing questions 1-10 out of questions