CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Free DP-900 Exam Braindumps (page: 18)

Page 17 of 78
PDF with 306 Questions

DRAG DROP (Drag and Drop is not supported)
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://en.wikipedia.org/wiki/Table_(database)
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index



You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

  1. stream processing
  2. batch processing
  3. Online Analytical Processing (OLAP)
  4. Online Transaction Processing (OLTP)

Answer(s): D

Explanation:

OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.


Reference:

https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/



When can you use an Azure Resource Manager template?

  1. to automate the creation of an interdependent group of Azure resources in a repeatable way
  2. to apply Azure policies for multi-tenant deployments
  3. to provision Azure subscriptions
  4. to control which services and feature administrators and developers can deploy from the Azure portal

Answer(s): A

Explanation:

You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed
To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object
Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.


Reference:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview



You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
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?

  1. role-based access control (RBAC)
  2. Dynamic Host Configuration Protocol (DHCP)
  3. Domain Name Service (DNS)
  4. a database-level firewall

Answer(s): D

Explanation:

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/






Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

DP-900 Exam Discussions & Posts