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

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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

• A.CREATE
• B.MERGE
• C.SELECT
• D.JOIN

Comment: *

Name: *

Email: *

Verification: *

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?

• A.Archive
• B.Hot
• C.Cool

Comment: *

Name: *

Email: *

Verification: *

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

• A.denormalized data
• B.normalized data
• C.schema on read
• D.schema on write
• E.heavy writes and moderate reads
• F.light writes and heavy reads

Comment: *

Name: *

Email: *

Verification: *

You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query. What should you create?

• A.a table
• B.an index
• C.scalar function
• D.a view

Comment: *

Name: *

Email: *

Verification: *