Download Administering Relational Databases on Microsoft Azure.examtorrent.DP-300.vV12-35.2021-02-05.1e.57q.vcex

Download Exam

File Info

Exam Administering Relational Databases on Microsoft Azure
Number DP-300
File Name Administering Relational Databases on Microsoft Azure.examtorrent.DP-300.vV12-35.2021-02-05.1e.57q.vcex
Size 3.82 Mb
Posted February 05, 2021
Downloads 93

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAM_HUB

Discount: 20%

 
 



Demo Questions

Question 1
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. 
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. 
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. 
Minimize the possibility of VM1 exfiltrating data stored in SqlDb1. 
What should you create on VNet1?

  • A: a VPN gateway
  • B: a service endpoint
  • C: a private link
  • D: an ExpressRoute gateway



Question 2
You have an Azure SQL database named db1.  
You need to retrieve the resource usage of db1 from the last week. 
How should you complete the statement? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point.




Question 3
You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. 
You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS. 
You need to configure storage for the virtual machine to support the database. 
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order. 




Question 4
You have SQL Server on an Azure virtual machine that contains a database named DB1. The database reports a CHECKSUM error. 
You need to recover the database. 
How should you complete the statements? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point.




Question 5
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. 
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. 
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. 
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2. 
Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. 
Does this meet the goal?

  • A: Yes
  • B: No



Question 6
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. 

    
  
FactSales has 6 billion rows and is loaded nightly by using a batch process. 
Which type of compression provides the greatest space reduction for the database?

  • A: page compression
  • B: row compression
  • C: columnstore compression
  • D: columnstore archival compression



Question 7
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. 
The solution must minimize downtime during scaling operations. 
What should you use?

  • A: An Azure SQL Database elastic pool
  • B: SQL Server on Azure virtual machines
  • C: an Azure SQL Database managed instance
  • D: Azure SQL databases



Question 8
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. 
You plan to migrate DB1 to an Azure SQL Database managed instance. 
What should you use to minimize downtime and data loss during the migration?

  • A: distributed availability groups
  • B: database mirroring
  • C: log shipping
  • D: Database Migration Assistant



Question 9
You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. 
You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. 
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.




Question 10
You have an Azure SQL database. 
You identify a long running query. 
You need to identify which operation in the query is causing the performance issue. 
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

  • A: Live Query Statistics
  • B: an estimated execution plan
  • C: an actual execution plan
  • D: Client Statistics






CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset