Last updated on July 14th, 2024 at 12:29 am
Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.
Microsoft DP900 Exam Dumps – QAs 81-85
Table of Contents
Q81. DRAG DROP –
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount per day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Q82. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct Answer
Q83. Which statement is an example of Data Definition Language (DDL)?
- SELECT
- INSERT
- DELETE
- DROP
Q84. You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
- Microsoft SQL Server Data Tools (SSDT)
- Microsoft SQL Server Management Studio (SSMS)
- Azure Databricks
- Azure Data Studio
Correct Answer
1. Microsoft SQL Server Data Tools (SSDT)
Q85. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Correct Answer
Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql