Microsoft DP-900 Actual Free Exam Questions & Community Discussion
Which storage solution supports access control lists (ACLs) at the file and folder level?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
To complete the sentence, select the appropriate option in the answer area.
Correct Answer:
Select the answer that correctly completes the sentence.
Correct Answer:
See the answer below:
Explanation:
Answer as below.
Explanation:
Answer as below.
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount 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.
You need to query the table to return the average sales amount 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.
Correct Answer:
Explanation:
Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as ' Average bonus ' , SUM(SalesYTD) as ' YTD sales ' FROM Sales.SalesPerson GROUP BY TerritoryID; Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Correct Answer:
Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
Correct Answer: D
Vote an answer
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure What is a possible cause of the issue?
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure What is a possible cause of the issue?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes
What should you recommend?
Native SQL API access
Configurable indexes
What should you recommend?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
What should you use to query the files?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10