New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Full Access Microsoft DP-900 Tutorials

Page: 4 / 23
Total 306 questions

Microsoft Azure Data Fundamentals Questions and Answers

Question 13

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options:

A.

complete control over backup and restore processes

B.

access to the latest features

C.

in-database machine learning services

D.

reduced administrative effort for managing the server infrastructure

Question 14

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Options:

A.

a scalar function

B.

a table

C.

an index

D.

a view

Question 15

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

Options:

Question 16

You have structured data in tabular format.

What represents an individual instance of a data entity?

Options:

A.

a column

B.

a cell

C.

a row

D.

a table

Page: 4 / 23
Total 306 questions