Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 41:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

• Question 42:

  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/data-factory/frequently-asked-questions

• Question 43:

  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/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

• Question 44:

  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/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

• Question 45:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

• Question 46:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  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

• Question 47:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

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

• Question 48:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

• Question 49:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server

  Reference: https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

• Question 50:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview

  https://azure.microsoft.com/en-us/pricing/details/bandwidth/