DP-900 Free Practice Test

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.

1. A. denormalized data
2. B. heavy writes and moderate reads
3. C. light writes and heavy reads
4. D. schema on write
5. E. schema on read
6. F. normalized data

Correct Answer: BDF

When can you use an Azure Resource Manager template?

1. A. to automate the creation of an interdependent group of Azure resources in a repeatable way
2. B. to automate the creation of an interdependent and develop can deploy from the Azure portal
3. C. To provision Azure subscriptions and apply policies for multi-tenant deployments
4. D. To set complex permissions automatically on existing objects in an Azure subscription

Correct Answer: A
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.

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

1. A. Azure SQL Managed Instance
2. B. SQL Server on Azure Virtual Machines
3. C. a single database in Azure SQL Database
4. D. an Azure SQL Database elastic pool

Correct Answer: C

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

1. A. service principal authentication
2. B. Azure Active Directory (Azure AD) authentication
3. C. SQL authentication
4. D. certificate authentication

Correct Answer: B