top of page
Search

What is Designing and Implementing Microsoft Azure Data Platform Certification?

  • Writer: Palak Mazumdar
    Palak Mazumdar
  • Sep 11, 2018
  • 4 min read

Designing and Implementing Microsoft Azure Data Platform certification questions and exam summary helps you to get focused on exam. This guide also helps you to be on 70-473 exam track to get certified with good score in final exam.


70-473 - Designing and Implementing Microsoft Azure Data Platform Certification Summary


70-473 Designing and Implementing Microsoft Azure Data Platform Certification Questions:


Q 1:You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?


Options:

A. Implement merge replication between the main office and the Azure Virtual machine.

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. 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.


Q 2: A customer plans to monitor the performance of a Microsoft Azure SQL Server database. You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DIU) percentage


Which three metrics should you identify?

Each correct answer presents part of the solution.


Options:

A. CPU percentage

B. Log IO percentage

C. Total database size

D. Data IO percentage

E. Database size percentage

F. Blocked by firewall


Q 3: You plan to implement a Microsoft Azure SQL database. You need to create and manage the new database on a new server. Which three cmd lets should you use?


Each correct answer presents part of the solution.


Options:

A. New-AzureSqIDatabaseServerFirewaIIRule

B. New-AzureSqIDatabaseServerContext

C. New-AzureSqIDatabase

D. New-AzureVNI

E. New-AzureSqIDatabaseServer


Q 4: 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.


Options:

A. an elastic query

B. SQL server Analysis Services (SSAS)

C. SQL server Integration Services (SSIS)

D. an elastic databasejob


Q 5: You are an administrator setting up a new Azure SQL Database that wiil be deployed on a new servser object. After creating the new server and database, you are unable to connect to it with Management Studio from your workstation.


Options:

A. Add a new user to the Azure SQL Database server's User Access Administrator role.

B. Add your current public IP address to the Azure SQL Database server's firewall settings.

C. Add your current public IP address to the Azure SQL Database's firewall settings

D. Add and configure Auditing for the Azure SQL Database.


Answers:


Question: 1: Answer: A

Question: 2: Answer: A, B, E

Question: 3: Answer: C, D, E

Question: 4: Answer: C

Question: 5: Answer:B, C


Designing and Implementing Microsoft Azure Data Platform Certification 70-473 Exam Syllabus


1. Design and implement database solutions for Microsoft SQL Server and Microsoft Azure SQL Database (20–25%):

Design a hybrid SQL Server solution

  • Design a Disaster Recovery topology for a hybrid deployment, design a data storage architecture, design a security architecture, design a data load strategy, design a data synchronization strategy.

Implement SQL Server on Azure Virtual Machines (VMs)

  • Provision SQL Server on an Azure VM, configure firewall rules, configure and optimize storage, migrate an on-premises database to Microsoft Azure, configure and optimize VM sizes by workload.

Design a database solution on Azure SQL database and SQL Server in Azure

  • Design a solution architecture, design a Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, determine the appropriate deployment scenario, determine IaaS vs PaaS, determine application access in Azure.

Implement Azure SQL Database

  • Provision Azure SQL Database, configure firewall rules, configure Active Geo-Replication, migrate an on-premises database to SQL Database, configure for scale and performance.

Design and implement MySQL and PostgreSQL database solutions in Azure

  • Design security, design a data load strategy, determine the appropriate service tier, provision databases and servers, configure firewall rules, migrate to Azure, configure for scale and performance.

2. Design and Implement Security (25–30%):

Design and implement SQL Server Database security

  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure Transparent Database Encryption (TDE); configure row-level security; configure data encryption; configure data masking; configure Always Encrypted.

Design and implement Azure SQL Database security

  • Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted, configure Automatic Threat Detection.

3. Design for high availability, disaster recovery and scalability (25–30%):

Design and implement high availability solutions

  • Design a high-availability solution topology, design a high-availability solution for SQL on Azure VMs, implement high-availability solutions.

Design and implement scalable solutions

  • Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for Azure SQL Database.

Design and implement Azure SQL Database data recovery

  • Implement self-service restore, copy and export databases, implement long-term retention backups.

4. Monitor and manage database implementations on Azure (25–30%):

Monitor and troubleshoot SQL Server VMs on Azure

  • Monitor database and instance activity, monitor by using DMVs and DMFs, monitor performance and scalability.

Monitor and troubleshoot SQL Database

  • Monitor and troubleshoot SQL Database, monitor database activity, monitor by using DMVs and DMFs, monitor performance and scalability

Automate and manage database implementations on Azure

  • Automate and manage SQL Server on Azure VMs, automate and manage Azure SQL Database, configure automation and runbooks.


How to Register for Designing and Implementing Microsoft Azure Data Platform Certification Exam?


Exam Registration:

Comments

bottom of page