Download Designing and Implementing Cloud Data Platform Solutions.PracticeTest.70-473.2019-04-14.1e.82q.vcex

Download Dump

File Info

Exam Designing and Implementing Cloud Data Platform Solutions
Number 70-473
File Name Designing and Implementing Cloud Data Platform Solutions.PracticeTest.70-473.2019-04-14.1e.82q.vcex
Size 887 Kb
Posted April 14, 2019
Downloads 15



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 consolidation of the databases from Host1. 
You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution.

  • A: BACKUP TO URL
  • B: AlwaysOn failover clustering
  • C: a maintenanceplan
  • D: AlwaysOn Availability Groups



Question 2
You need to recommend a disaster recovery solution for the CRM application that meets the business requirements. 
What should you recommend?

  • A: backup and restore by using Windows Azure Storage
  • B: log shipping
  • C: AlwaysOn Availability Groups
  • D: database mirroring



Question 3
You are evaluating moving the data from WebData1 to an Azure SQL database. 
You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements. 
What should you include in the recommendation?

  • A: SQL Server Integration Services (SSIS)
  • B: SQL Server Analysis Services (SSAS)
  • C: an elastic database job
  • D: an elastic query



Question 4
You are evaluating whether to replace CRM-B with an Azure virtual machine. 
You need to identify the required virtual machine service tier to replace CRM-В. The solution must meet the following requirements:
Ensure that the database isstored in premium storage. 
Meet the business requirements. 
Which virtual machine service tier should you identify?

  • A: Standard DS3
  • B: Standard A6
  • C: Standard GS2
  • D: Standard D3



Question 5
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?

  • A: Extract a data-tier application (DAC).
  • B: Use the bcp command.
  • C: Use the SQL Server Migration Assistant (SSMA).
  • D: Export a data-tier application (DAC).



Question 6
You need to recommend a solution to migrate the Listings database to the cloud. 
What should you recommend?

  • A: Stage the Listings database on an Azure virtual machine prior to the outage. During the outage, perform a data import from the main office by using SQL Server Management Studio.
  • B: Implement log-shipping between the main office and an Azure virtual machine prior to the migration date. During the planned outage, perform a final log backup, restore the backup to the secondary, and then switch the secondary to the primary role.
  • C: Run a full backup during the outage and restore the backup to the Azure virtual machine.
  • D: Implement merge replication between the main office and the Azure virtual machine.



Question 7
You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns. 
What are two possible ways to identify the elastic database transaction units (eDTUs)? Each correct answer presents a complete solution.

  • A: Aggregate data from sys.dm_os_wait_stats.
  • B: Run the Database Engine Tuning Advisor.
  • C: Run the Service Tier Advisor.
  • D: Aggregate data from sys.dm_db_resource_stats.
  • E: Aggregate data from sys.dm_os_performance_counters.



Question 8
You need to recommend a solution to migrate the Listings database to the cloud. 
What should you recommend?

  • A: Stage the Listings database on an Azure virtual machine prior to the outage. During the outage, perform a data import from the main office by using SQL Server Management Studio.
  • B: Enable mirroring between the main office and the Azure virtual machine. During the planned outage, change the mirroring roles on the Azure virtual machine to become the primary server, and then break the mirror.
  • C: Run a full backup during the outage and restore the backup to the Azure virtual machine.
  • D: Implement merge replication between the main office and the Azure virtual machine.



Question 9
Which three components are required to meet the encryption requirements for the ListTest database? Each correct answer presents part of the solution. 
NOTE: Each correct selection is worth one point.

  • A: a Column Master Key
  • B: a certificate
  • C: an Always Encrypted enabled driver
  • D: a Column Encryption Key
  • E: a service master key
  • F: a database master key



Question 10
You need to ensure that the performance statistics for the research department are collected. What should you enable?

  • A: Query Performance Insight
  • B: Scale and Configuration
  • C: Dynamic Data Masking
  • D: Index advisor









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