Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Microsoft
Microsoft Certified: Azure Data Fundamentals
DP-900
Microsoft Azure Data Fundamentals Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Go to Exam

830 Students Passed

91% Average Score

91% Same Questions

Viewing page 10 out of 10 pages

Viewing questions 91-100 out of questions

Questions # 91:

Select the answer the correctly completes the sentence.

Question # 91

Options:

Answer

Answer:

See the answer in explanation below.

Explanation

Answer below as:

Questions # 92:

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

Question # 92

Options:

Answer

Answer:

Explanation

[Reference:, https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture, , , , ]

Questions # 93:

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Options:

normalized data

schema defined in a database

schema defined when reading unstructured data from a database

normalized data

light writes and heavy reads

heavy writes and moderate reads

Answer

A, C, F

Questions # 94:

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

Options:

Answer

Answer:

Questions # 95:

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

Options:

Azure Databricks

pgAdmin

Microsoft Power Bl

Answer

Questions # 96:

When you create an Azure SQL database, which account can always connect to the database ?

Options:

the Azure Active director/ (Azure AO) account that created the database

the Azure Active Directly Azure AD) administrator account

the sa account

the server admin login account of the logical server

Answer

Explanation

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart, , ]

Questions # 97:

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

Question # 97

Options:

Answer

Answer:

Explanation

[Reference:, https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15, , , ]

Questions # 98:

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options:

extract transform, and load (ETL)

a data warehouse

online analytical processing (OLAP)

online transaction processing (OLTP)

Answer

Questions # 99:

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?