Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free Microsoft DP-300 Exam Braindumps (page: 11)

Page 11 of 61
PDF with 406 Questions

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet that uses partitioned columnstores.

You need to configure table1 to meet the following requirements:

•Each partition must be compressed.
•The compression ratio must be maximized.
•You must be able to index the compressed data.

What should you use?

  1. page compression
  2. columnstore compression
  3. GZIP compression
  4. columnstore archival compression

Answer(s): D



You have an Azure subscription linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances.

You need to ensure that you can manage the SQL Server instances by using a single user account.

What should you do first?

  1. Enable a user-assigned managed identity on each virtual machine.
  2. Deploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain.
  3. Enable a system-assigned managed identity on each virtual machine.
  4. Join the virtual machines to the Azure AD tenant.

Answer(s): A



DRAG DROP (Drag and Drop is not supported)
You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You need to configure the disks on the virtual machine. The solution must meet the following requirements:

•Minimize latency for transaction logs.
•Minimize the impact on IO throughput of the virtual machine.

Which type of disk should you use for each workload? To answer, drag the appropriate disk types to the correct workloads. Each disk type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have an Azure SQL Database elastic pool that contains 10 databases.

You receive the following alert.

Msg 1132, Level 16, state 1, Line 1
The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs.

You need to resolve the alert. The solution must minimize administrative effort.

Which three actions can you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  1. Increase the maximum storage of the elastic pool.
  2. Delete data from a database.
  3. Remove a database from the pool.
  4. Enable data compression.
  5. Shrink individual databases.

Answer(s): A,C,E



You have an Azure subscription.
You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).

Which three parameters are required?

  1. --name, --edition, and --capacity
  2. --name, --tier, and --min-capacity
  3. --name, --resource-group, and --server
  4. --name, --licence-type, and --capacity

Answer(s): C



Viewing page 11 of 61
Viewing questions 51 - 55 out of 406 questions



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

DP-300 Exam Discussions & Posts