Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 191:

  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?

  A. a database-level firewall

  B. role-based access control (RSAC)

  C. Dynamic Host Configuration Protocol (DHCP)

  D. Domain Name Service (DNS)

  Correct Answer: A

  The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database. When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.

  Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

• Question 192:

  You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?

  A. Azure Cosmos DB

  B. Azure HDInsig

  C. Azure SQL Database

  D. Azure Synapse Analytics

  Correct Answer: C

  Azure SQL Database is relational database and a managed service.

  Incorrect Answers:

  A, B: Cosmos DB, HDInsight are non-relational databases.

  D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing

  Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

• Question 193:

  Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

  A. Azure DNS

  B. Azure Application Gateway

  C. Azure Private link

  D. Azure Traffic Manager

  Correct Answer: C

  Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

  Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary

  Reference:

  https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

• Question 194:

  Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

  A. Azure SQL Database Hyperscale

  B. Azure SQL managed instance

  C. Azure SQL Database serveless

  D. Azure SQL Database elastic pod

  Correct Answer: B

• Question 195:

  What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. access to the latest features

  B. complete control over backup and restore processes

  C. in-database machine learning services

  D. reduced administrative effort for managing the server infrastructure

  Correct Answer: AD

  A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

  D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.

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

• Question 196:

  Which statement is an example of Data Manipulation Language (DML)?

  A. INSERT

  B. DISABLE

  C. ALTER

  D. DROP

  Correct Answer: A

  Data Manipulation Language (DML) statements: DELETE INSERT UPDATE Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

• Question 197:

  You have a SQL query that combines customer data and order data

  The query includes calculated columns.

  You need to persist the SQL query so that other users can use the query. What should you create?

  A. a table

  B. an index

  C. scalar function

  D. a view

  Correct Answer: D

  A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

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

• Question 198:

  Which setting can only be configured during the creation of an Azure Cosmos DB account?

  A. geo-redundancy

  B. multi-region writes

  C. production or non-reduction account type

  D. API

  Correct Answer: D

  You must create a separate account for each API.

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

• Question 199:

  What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

  A. supports partitioning

  B. provides resiliency if art Azure region fails

  C. provides a higher storage capacity

  D. supports a multi-master model

  Correct Answer: D

  Multi-master support for Azure Cosmos DB is now available in all public regions.

  Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.

  Reference:

  https://docs.microsoft.com/en-us/azure/cosmos-db/table-support

• Question 200:

  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. item

  C. database

  D. partition

  Correct Answer: AC

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput