Free Microsoft DP-900 Study Guides Exam Questions & Answer
DP-900 Exam Dumps, DP-900 Practice Test Questions
NEW QUESTION 33
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 34
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
NEW QUESTION 35
You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
- A. MERGE
- B. CREATE
- C. INSERT
- D. UPDATE
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15
NEW QUESTION 36
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing
NEW QUESTION 37
For each of the following statements, select yes if the statement is true, Otherwise, select No.
Note: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 38
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json
https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-files
NEW QUESTION 39
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter?
- A. descriptive
- B. diagnostic
- C. predictive
- D. prescription
Answer: D
NEW QUESTION 40
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench
NEW QUESTION 41
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
NEW QUESTION 42
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
NEW QUESTION 43
Which command-line tool can you use to query Azure SQL databases?
sqlcmd
- A.
- B. azdata
- C. Azure CLI
- D. bcp
Answer: C
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=single- database
NEW QUESTION 44
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?
- A. Azure Data Studio
- B. sq1cmd
- C. Azure Data Explorer
- D. Microsoft SQL Server Management Studio (SSMS)
Answer: A
NEW QUESTION 45
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
- A. Azure Queue storage
- B. Azure table storage
- C. Azure Files
- D. Azure Data Lake Storage
Answer: B
NEW QUESTION 46
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/
NEW QUESTION 47
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Azure Time Series Insights
- B. Azure Databricks
- C. Azure Log Analytics
- D. Azure HDinsight
Answer: B,D
NEW QUESTION 48
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
NEW QUESTION 49
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 50
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/
https://azure.microsoft.com/en-us/services/sql-database/#product-overview
NEW QUESTION 51
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. container
- B. database
- C. item
- D. partition
Answer: C,D
NEW QUESTION 52
......
Latest DP-900 Actual Free Exam Questions Updated 169 Questions: https://www.dumpsquestion.com/DP-900-exam-dumps-collection.html
Attested DP-900 Dumps PDF Resource [2022]: https://drive.google.com/open?id=1L2TGWi-IfotpQGzzHMZGEF6z8zPF8Zeq