18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
United States
share button
Free Webinar: Database Recovery Models And Its Significance : July 29, 2020. 

DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) Training


What DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) training is all about?

In the DP-200T01 Azure Data Solution Training, students will learn and implement an array of data platform technologies into solutions suitable for technical and business requirements including cloud, on-premises, hybrid data scenarios including both No-SQL and relational data. The Microtek Learning directed training will help learners understand how to process data using various languages and technologies for both batch data and streaming.

Students will also get to learn the implementation of data security including data standards and policies, authentication, and authorization. They will also understand and implement data monitoring solutions for both data processing and data storage activities. Additionally, the training will also help learners to troubleshoot and manage Azure data solutions which include disaster recovery and optimization of big data, streaming data solutions and batch processing.

  • START DATE
  • CLASS TIMINGS
  • DELIVERY MODE
  • PRICE
  • ACTION
  • 08/03/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 08/31/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 10/05/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 11/23/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
  • 12/21/2020
  • 9:00 am - 5:00 pm EST
  • $ 1725
What are the course objectives for DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) training?
  • Working with Data Storage
  • Enabling Team-Based Data Science with Azure Databricks
  • Building Globally Distributed Databases with Cosmos DB
  • Working with Relational Data Stores in the Cloud
  • Performing Real-Time Analytics with Stream Analytics
  • Orchestrating Data Movement with Azure Data Factory
  • Securing Azure Data Platforms
  • Monitoring and Troubleshooting Data Storage and Processing
  • Integrating and Optimizing Data Platforms
Who should attend DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) training?

The Azure Data Solution Training is aimed at business intelligence professionals, data professionals, and data architects planning to learn about various data platform technologies existing on Microsoft Azure. In addition to this, individuals who create apps that deliver data from different data platform technologies existing on Microsoft Azure.

What is the course outline for DP-200T01: Implementing an Azure Data Solution Associate (Data Engineer) training?
  • 1. Azure for the Data Engineer
  • a). Explain the evolving world of data
  • b). Survey the services in the Azure Data Platform
  • c). Identify the tasks that are performed by a Data Engineer
  • d). Describe the use cases for the cloud in a Case Study
  • e). Lab : Azure for the Data Engineer
  • 2. Working with Data Storage
  • a). Choose a data storage approach in Azure
  • b). Create an Azure Storage Account
  • c). Explain Azure Data Lake storage
  • d). Upload data into Azure Data Lake
  • e). Lab : Working with Data Storage
  • 3. Enabling Team Based Data Science with Azure Databricks
  • a). Explain Azure Databricks
  • b). Work with Azure Databricks
  • c). Read data with Azure Databricks
  • d). Perform transformations with Azure Databricks
  • e). Lab : Enabling Team Based Data Science with Azure Databricks
  • 4. Building Globally Distributed Databases with Cosmos DB
  • a). Create an Azure Cosmos DB database built to scale
  • b). Insert and query data in your Azure Cosmos DB database
  • c). Build a .NET Core app for Cosmos DB in Visual Studio Code
  • d). Distribute your data globally with Azure Cosmos DB
  • e). Lab : Building Globally Distributed Databases with Cosmos DB
  • 5. Working with Relational Data Stores in the Cloud
  • a). Use Azure SQL Database
  • b). Describe Azure SQL Data Warehouse
  • c). Creating and Querying an Azure SQL Data Warehouse
  • d). Use PolyBase to Load Data into Azure SQL Data Warehouse
  • e). Lab : Working with Relational Data Stores in the Cloud
  • 6. Performing Real-Time Analytics with Stream Analytics
  • a). Explain data streams and event processing
  • b). Data Ingestion with Event Hubs
  • c). Processing Data with Stream Analytics Jobs
  • d). Lab : Performing Real-Time Analytics with Stream Analytics
  • 7. Orchestrating Data Movement with Azure Data Factory
  • a). Explain how Azure Data Factory works
  • b). Azure Data Factory Components
  • c). Azure Data Factory and Databricks
  • d). Lab : Orchestrating Data Movement with Azure Data Factory
  • 8. Securing Azure Data Platforms
  • a). An introduction to security
  • b). Key security components
  • c). Securing Storage Accounts and Data Lake Storage
  • d). Securing Data Stores
  • e). Securing Streaming Data
  • f). Lab : Securing Azure Data Platforms
  • 9. Monitoring and Troubleshooting Data Storage and Processing
  • a). Explain the monitoring capabilities that are available
  • b). Troubleshoot common data storage issues
  • c). Troubleshoot common data processing issues
  • d). Manage disaster recovery
  • e). Lab : Monitoring and Troubleshooting Data Storage and Processing
FAQs
  • Single choice based on a scenario
  • Multiple-choice questions
  • Arrange in right sequence type questions
  • case study with multiple questions
  • There will be at least three questions in a sequence to select from Yes or No; you cant skip these questions
  • You need to get 700 out of 1000 to pass the DP-200 examination. The total duration of DP-200 exam is 210 minutes. Out of total time, 180 minutes are reserved to answer 46 questions.

    According to Microsoft, the skills ratio measured in DP-200 exam are:

  • Implement data storage solutions (40-45%)
  • Manage and develop data processing (25-30%)
  • Monitor and optimize data solutions (30-35%)
  • Our highly experienced Microsoft Azure certified trainers cover the following topics to impart the perfection in optimizing Azure data solutions:

  • Troubleshooting data partitioning bottlenecks
  • Optimize data lake storage; Optimize stream analytics
  • Optimize SQL data warehouse and database
  • Data life cycle management