Download Administering Relational Databases on Microsoft Azure.dump4pass.DP-300.2022-01-08.7e.177q.vcex


Download Exam

File Info

Exam Administering Relational Databases on Microsoft Azure
Number DP-300
File Name Administering Relational Databases on Microsoft Azure.dump4pass.DP-300.2022-01-08.7e.177q.vcex
Size 11.41 Mb
Posted January 08, 2022
Downloads 98



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
What should you use to migrate the PostgreSQL database?

  • A: Azure DataBox 
  • B: AzCopy
  • C: Azure Database MigrationService
  • D: Azure SiteRecovery



Question 2
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 3
You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.  
What should you recommend? To answer, select the appropriate options in the answer area.    
NOTE: Each correct selection is worth one point. 




Question 4
You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. 
Which Azure Storage functionality should you include in the solution?

  • A: time-basedretention
  • B: changefeed
  • C: lifecyclemanagement
  • D: softdelete



Question 5
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?

  • A: a table that has a FOREIGN KEYconstraint
  • B: a table the has an IDENTITYproperty
  • C: a user-defined SEQUENCEobject
  • D: a system-versioned temporaltable



Question 6
You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point. 




Question 7
You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases.  
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.    
NOTE: Each correct selection is worth one point.

  • A: total size of all thedatabases
  • B: geo-replicationsupport
  • C: number of concurrently peaking databases * peak CPU utilization perdatabase
  • D: maximum number of concurrent sessions for all the databases
  • E: total number of databases * average CPU utilization perdatabase



Question 8
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A recent failure causes the master database to be lost.  
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.    
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct.  




Question 9
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. You must provide the greatest reduction in space for the database and maximize performance.    
Which type of compression provides the greatest space reduction for the database?

  • A: pagecompression 
  • B: rowcompression
  • C: columnstorecompression
  • D: columnstore archivalcompression



Question 10
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.    
Clustered columnstore indexes  
Automatic tuning  
Change tracking  
PolyBase    
You plan to migrate DB1 to an Azure SQL database.    
What feature should be removed or replaced before DB1 can be migrated?

  • A: Clustered columnstoreindexes
  • B: PolyBase
  • C: Changetracking
  • D: Automatictuning








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