Microsoft DP-900 Actual Free Exam Questions & Community Discussion
Which Azure Storage service implements the key/value model?
Correct Answer: A
Vote an answer
What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Correct Answer: B,D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?
You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
What is a primary characteristic of a relational database?
Correct Answer: A
Vote an answer
Select the answer that correctly completes the sentence.
Correct Answer:
Explanation:
An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
* APPROX_COUNT_DISTINCT
* AVG
* CHECKSUM_AGG
* COUNT
* COUNT_BIG
* GROUPING
* GROUPING_ID
* MAX
* MIN
* STDEV
* STDEVP
* STRING_AGG
* SUM
* VAR
* VARP
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql -server-ver15
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
Select the answer that correctly completes the sentence.
Correct Answer:
See the answer in explanation below.
Explanation:
Answer below as:
Explanation:
Answer below as:
0
0
0
10