Download Administering Relational Databases on Microsoft Azure.examboost.DP-300.2021-03-15.1e.56q.vcex


Download Exam

File Info

Exam Administering Relational Databases on Microsoft Azure
Number DP-300
File Name Administering Relational Databases on Microsoft Azure.examboost.DP-300.2021-03-15.1e.56q.vcex
Size 2.02 Mb
Posted March 15, 2021
Downloads 65



How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

Question 1
You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.  
What should you include in the migration plan? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 
  
 




Question 2
You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.  
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 3
You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.  
How should you collect and stream metrics? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 
  
 




Question 4
You need to identify the cause of the performance issues on SalesSQLDb1.   
Which two dynamic management views should you use? Each correct answer presents part of the solution.  
NOTE: Each correct selection is worth one point.

  • A: sys.dm_pdw_nodes_tran_locks
  • B: sys.dm_exec_compute_node_errors
  • C: sys.dm_exec_requests
  • D: sys.dm_cdc_errors
  • E: sys.dm_pdw_nodes_os_wait_stats
  • F: sys.dm_tran_locks



Question 5
You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements.  
What should you include in the recommendation? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 
 




Question 6
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.  
What should you run as part of the implementation?

  • A: CREATE LOGIN and the FROM WINDOWS clause
  • B: CREATE USER and the FROM CERTIFICATE clause
  • C: CREATE USER and the FROM LOGIN clause
  • D: CREATE USER and the ASYMMETRIC KEY clause
  • E: CREATE USER and the FROM EXTERNAL PROVIDER clause



Question 7
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 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 an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.  
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.  
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 
 




Question 10
You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.  
You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev.  
Which four 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.  









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