Microsoft DP900 Exam Dumps|QAs Page -3

Last updated on July 14th, 2024 at 12:18 am

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 11-15

Q11. Which statement is an example of Data Manipulation Language (DML)?

  1. REVOKE
  2. DISABLE
  3. INSERT
  4. GRANT
Correct answer

3. INSERT

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Q12. 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?

  1. an index
  2. a view
  3. a scalar function
  4. a table
Correct answer

2. a view

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Q13. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

dp900_question 13
Correct answer
dp900_answer 13

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Q14. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

dp900_question 14
Correct answer
dp900_answer 14

Q15. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

dp900_question 15
Correct answer
dp900_answer 15

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Scroll to Top