MCSA Cloud Platform


comp name

MCSA Cloud Platform Certification is for those who wants to start their IT career in Microsoft Azure Cloud technologies. This Certification will demonstrate your technical skills in Microsoft cloud-related technologies to reduce IT costs and deliver more value for the modern business.
Earning of MCSA Microsoft Cloud Platform provides the foundation for a position as a cloud administrator or architect.

To Earn MCSA in Microsoft Cloud Platform, you must pass two of the following exams.


  • Developing Microsoft Azure Solutions (70-532)

  • Implementing Microsoft Azure Infrastructure Solutions(70-533)

  • Architecting Microsoft Azure Solutions (70-534)

  • Designing and Implementing Cloud Data Platform Solutions (70-473)

  • Designing and Implementing Big Data Analytics Solutions (70-475)



Developing Microsoft Azure Solutions (70-532)


Exam Details

Required Exam(s) Developing Microsoft Azure Solutions 70-532
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop and simulation types.
Exam Fees Rs.4800
Prerequired Exams No Prerequired exam for this certifications
Recommended Training Developing Microsoft Azure Solutions

Exam Pattern

Below are the exam topics of Developing Microsoft Azure Solutions (70-532) .
1.0 Create and manage Azure Resource Manager Virtual Machines (30‒35%)
Deploy workloads on Azure Resource Manager (ARM) Virtual Machines (VMs)
  • Identify workloads that can and cannot be deployed; run workloads, including Microsoft and Linux; create VMs
Perform configuration management
  • Automate configuration management by using PowerShell Desired State Configuration and VM Agent (custom script extensions); configure VMs using a configuration management tool, such as Puppet or Chef; enable remote debugging
Configure ARM VM networking
  • Configure static IP addresses, Network Security Groups (NSG), DNS, User Defined Routes (UDRs), external and internal load balancing with HTTP and TCP health probes, public IPs, firewall rules, and direct server return; design and implement Application Gateway
Scale ARM VMs
  • Scale up and scale down VM sizes, deploy ARM VM Scale Sets (VMSS), configure ARM VMSS auto-scale
Design and implement ARM VM storage
  • Configure disk caching, plan for storage capacity, configure shared storage using Azure File service, configure geo-replication, implement ARM VMs with Standard and Premium Storage
Monitor ARM VMs
  • Configure ARM VM monitoring, configure alerts, configure diagnostic and monitoring storage location
Manage ARM VM availability
  • Configure multiple ARM VMs in an availability set for redundancy, configure each application tier into separate availability sets, combine the Load Balancer with availability sets
2.0 Design and implement a storage and data strategy (25‒30%)
Implement Azure Storage blobs and Azure files
  • Read data, change data, set metadata on a container, store data using block and page blobs, stream data using blobs, access blobs securely, implement async blob copy, configure Content Delivery Network (CDN), design blob hierarchies, configure custom domains, scale blob storage
Implement Azure storage tables and queues
  • Implement CRUD with and without transactions; design and manage partitions; query using OData, scale tables and partitions, add and process messages, retrieve a batch of messages, scale queues
Manage access and monitor storage
  • Generate shared access signatures, including client renewal and data validation; create stored access policies; regenerate storage account keys; configure and use Cross-Origin Resource Sharing (CORS); set retention policies and logging levels; analyse logs
Implement Azure SQL Databases
  • Choose the appropriate database tier and performance level, configure and perform point-in-time recovery, enable geo-replication, import and export data and schema, scale Azure SQL databases
Implement Azure DocumentDB
  • Create databases and collections, query documents, run DocumentDB queries
Implement Redis caching
  • Choose a cache tier, implement data persistence, implement security and network isolation, tune cluster performance
Implement Azure Search
  • Create a service index, add data, search an index, handle search results
3.0 Manage identity, application and network services (15‒20%)
Integrate an app with Azure Active Directory (Azure AD)
  • Develop apps that use WS-federation, OAuth, and SAML-P endpoints; query the directory using Graph API
Design and implement a communication strategy
  • Implement hybrid connections to access data sources on-premises, leverage site-to-site (S2S) VPN and ExpressRoute to connect to an on-premises infrastructure
Design and implement a messaging strategy
  • Develop and scale messaging solutions using service bus queues, topics, relays and notification hubs; monitor service bus queues, topics, relays, event hubs and notification hubs
Develop apps that use Azure AD B2C and Azure AD B2B
  • Design and implement .NET MVC, Web API and Windows desktop apps that leverage social identity provider authentication, including Microsoft account, Facebook, Google+, Amazon and LinkedIn; leverage Azure AD B2B to design and implement applications that support partner-managed identities
4.0 Design and implement Azure PaaS compute and web and mobile services (25–30%)
Design Azure App Service Web Apps
  • Define and manage App Service plans; configure Web Apps settings, certificates and custom domains; manage Web Apps by using the API, Azure PowerShell and Xplat-CLI; implement diagnostics, monitoring and analytics; implement web jobs; design and configure Web Apps for scale and resilience
Implement Azure Functions
  • Create Azure Functions, implement a webhook function, create an event processing function, implement an Azure-connected function
Implement API management
  • Create managed APIs, configure API management policies, protect APIs with rate limits, add caching to improve performance, monitor APIs, customise the Developer Portal
Design Azure App Service API Apps
  • Create and deploy API Apps, automate API discovery by using Swashbuckle, use Swagger API metadata to generate client code for an API app, monitor API Apps
Develop Azure App Service Logic Apps
  • Create a Logic App connecting SaaS services, create a Logic App with B2B capabilities, create a Logic App with XML capabilities, trigger a Logic App from another app, create custom and long-running actions, monitor Logic Apps
  • Create a Mobile App, add offline sync to a Mobile App, add authentication to a Mobile App, add push notifications to a Mobile App
  • Design and implement Azure Service Fabric apps
    • Create a Service Fabric application; build an Actors-based service; add a web front end to a Service Fabric application; monitor and diagnose services; migrate apps from cloud services; create, secure, upgrade and scale Service Fabric Cluster in Azure; scale a Service Fabric app

    Books to Prepare

    Below are the recommended books for preparing 70-532 Exams

    CCNP Route Cover Image

    Book Name : Exam Ref 70-532 Developing Microsoft Azure Solutions

    Author Name : Zoiner Tejada, Michele Leroux Bustamante, Ike Ellis

    Publisher : Microsoft Press

    Topics Covered in this book:


    • Chapter 1 Design and implement websites
    • Chapter 2 Create and manage virtual machines
    • Chapter 3 Design and implement cloud services
    • Chapter 4 Design and implement a storage strategy
    • Chapter 5 Manage application and network services

    Implementing Microsoft Azure Infrastructure Solutions 70-533


    Exam Details

    Required Exam(s) Implementing Microsoft Azure Infrastructure Solutions 70-533
    Durations 120 Minutes (40 - 60 Questions)
    Question Types Multiple choice, drag and drop and simulation types.
    Exam Fees Rs.4800
    Prerequired Exams No Prerequired exam for this certifications
    Recommended Training Implementing Microsoft Azure Infrastructure Solutions

    Exam Pattern

    Below are the exam topics of Implementing Microsoft Azure Infrastructure Solutions 70-533 .
    1.0 Design and implement Azure App Service apps (15–20%)
    Deploy Web Apps
    • Define deployment slots; roll back deployments; implement pre- and post-deployment actions; create, configure and deploy packages; create App Service plans; migrate Web Apps between App Service plans; create a Web App within an App Service plan
    Configure Web Apps
    • Define and use app settings, connection strings, handlers and virtual directories; configure certificates and custom domains; configure SSL bindings and runtime configurations; manage Web Apps by using Azure PowerShell and Xplat-CLI
    Configure diagnostics, monitoring and analytics
    • Retrieve diagnostics data; view streaming logs; configure endpoint monitoring, alerts and diagnostics; use remote debugging; monitor website resources
    Configure Web Apps for scale and resilience
    • Configure auto-scale using built-in and custom schedules, configure by metric, change the size of an instance, configure Traffic Manager
    2.0 Create and manage Azure Resource Manager Virtual Machines (20–25%)
    Deploy workloads on Azure Resource Manager (ARM) virtual machines (VMs)
    • Identify workloads that can and cannot be deployed, run workloads including Microsoft and Linux, create VMs, connect to a Windows/Linux VM
    Perform configuration management
    • Automate configuration management by using PowerShell Desired State Configuration (DSC) and VM Agent (custom script extensions), configure VMs using a configuration management tool such as Puppet or Chef, enable remote debugging
    Design and implement VM storage
    • Configure disk caching, plan storage capacity, configure operating system disk redundancy, configure shared storage using Azure File service, configure geo-replication, encrypt disks, implement ARM VMs with Standard and Premium Storage
    Monitor ARM VMs
    • Configure ARM VM monitoring, configure alerts, configure diagnostic and monitoring storage location
    Monitor ARM VM availability
    • Configure multiple ARM VMs in an availability set for redundancy, configure each application tier into separate availability sets, combine the Load Balancer with availability sets
    Scale ARM VMs
    • Scale up and scale down VM sizes, deploy ARM VM Scale Sets (VMSS), configure ARM VMSS auto-scale
    3.0 Design and implement a storage strategy (20–25%)
    Implement Azure storage blobs and Azure files
    • Read data, change data, set metadata on a container, store data using block and page blobs, stream data using blobs, access blobs securely, implement async blob copy, configure a Content Delivery Network (CDN), design blob hierarchies, configure custom domains, scale blob storage
    Manage access
    • Create and manage shared access signatures, use stored access policies, regenerate keys
    Configure diagnostics, monitoring and analytics
    • Set retention policies and logging levels, analyse logs
    Implement Azure SQL Databases
    • Choose the appropriate database tier and performance level; configure point-in-time recovery, geo-replication and data sync; import and export data and schema; design a scaling strategy
    Implement recovery services
    • Create a backup vault, deploy a backup agent, back up and restore data
    4.0 Implement an Azure Active Directory (15–20%)
    Integrate an Azure Active Directory (Azure AD) with existing directories
    • Implement Azure AD Connect and single sign-on with on-premises Windows Server 2012 R2, add custom domains, monitor Azure AD
    Configure Application Access
    • Configure single sign-on with SaaS applications using federation and password-based, add users and groups to applications, revoke access to SaaS applications, configure access, configure federation with Facebook and Google ID
    Integrate an app with Azure AD
    • Implement Azure AD integration in web and desktop applications, leverage Graph API
    Implement Azure AD B2C and Azure B2B
    • Create an Azure AD B2C Directory, register an application, implement social identity provider authentication, enable multi-factor authentication, set up self-service password reset, implement B2B collaboration, configure partner users, integrate with applications
    5.0 Implement virtual networks (10–15%)
    Configure virtual networks
      Deploy a VM into a virtual network; configure external and internal load balancing; implement Application Gateway; design subnets; configure static, public, and private IP addresses; set up Network Security Groups (NSGs), DNS at the virtual network level, HTTP and TCP health probes, public IPs, User Defined Routes (UDRs), firewall rules and direct server return
    Modify network configuration
      Modify a subnet, import and export a network configuration
    Design and implement a multi-site or hybrid network
      Choose the appropriate solution between ExpressRoute, site-to-site and point-to-site; choose the appropriate gateway; identify supported devices and software VPN solutions; identify networking prerequisites; configure virtual networks and multi-site virtual networks
    6.0 Design and deploy ARM templates (10–15%)
    Implement ARM templates
      Author ARM templates; create ARM templates to deploy ARM Resource Providers resources; deploy templates with PowerShell, CLI and REST API
    Implement ARM templates
      Leverage service principals with ARM authentication, use Azure Active Directory Authentication with ARM, set management policies, lock resources
    Implement ARM templates
      Secure resource scopes, such as the ability to create VMs and Azure Web Apps; implement Azure role-based access control (RBAC) standard roles; design Azure RBAC custom

    Books to Prepare

    Below are the recommended books for preparing 70-533 Exams

    CCNP Route Cover Image

    Book Name : Exam Ref 70-532 Developing Microsoft Azure Solutions

    Author Name : Michael Washam, Rick Rainey

    Publisher : Microsoft Press

    Topics Covered in this book:


    • Chapter 1 Implement Websites
    • Chapter 2 Implement virtual machines
    • Chapter 3 Implement Cloud Services
    • Chapter 4 Implement storage
    • Chapter 5 Implement an Azure Active Directory
    • CHAPTER 6 Implement virtual networks

    Exam Details

    Required Exam(s) Architecting Microsoft Azure Solutions 70-534
    Durations 120 Minutes (40 - 60 Questions)
    Question Types Multiple choice, drag and drop and simulation types.
    Exam Fees Rs.4800
    Prerequired Exams No Prerequired exam for this certifications
    Recommended Training Architecting Microsoft Azure Solutions

    Exam Pattern

    Below are the exam topics of Architecting Microsoft Azure Solutions 70-534 .
    1.0 Design Azure Resource Manager (ARM) networking (5–10%)
    Design Azure virtual networks
    • Extend on-premises; leverage Azure networking services: implement load balancing using Azure Load Balancer and Azure Traffic Manager; define DNS, DHCP and IP addressing configuration; define static IP reservations; apply Network Security Groups (NSGs) and User Defined Routes (UDRs); deploy Azure Application Gateway
    Describe Azure VPN and ExpressRoute architecture and design
    • Describe Azure point-to-site (P2S) and site-to-site (S2S) VPN, leverage Azure VPN and ExpressRoute in network architecture
    2.0 Secure resources (20–25%)
    Secure resources by using managed identities
    • Describe the differences between Active Directory on-premises and Azure Active Directory (Azure AD), programmatically access Azure AD using Graph API, secure access to resources from Azure AD applications using OAuth and OpenID Connect
    Secure resources by using hybrid identities
    • Use SAML claims to authenticate to on-premises resources, describe AD Connect synchronisation, implement federated identities using Active Directory Federation Services (ADFS)
    Secure resources by using identity providers
    • Provide access to resources using identity providers, such as Microsoft account, Facebook, Google and Yahoo!; manage identity and access by using Azure AD B2C; implement Azure AD B2B
    Identify an appropriate data security solution
    • Identify security requirements for data in transit and data at rest; identify security requirements using Azure services, including Azure Storage Encryption, Azure Disk Encryption and Azure SQL Database TDE
    Design a role-based access control (RBAC) strategy
    • Secure resource scopes, such as the ability to create VMs and Azure Web Apps; implement Azure RBAC standard roles; design Azure RBAC custom roles
    Manage security risks by using an appropriate security solution
    • Identify, assess and mitigate security risks by using Azure Security Center, Operations Management Suite and other services
    3.0 Design an application storage and data access strategy (5–10%)
    Design data storage
    • Design storage options for data, including Table Storage, SQL Database, DocumentDB, Blob Storage, MongoDB and MySQL; design security options for SQL Database or Azure Storage
    Select the appropriate storage option
    • Select the appropriate storage for performance, identify storage options for cloud services and hybrid scenarios with compute on-premises and storage on Azure
    4.0 Design advanced applications (20–25%)
    Create compute-intensive applications
    • Design high-performance computing (HPC) and other compute-intensive applications using Azure Services
    Create long-running applications
    • Implement Azure Batch for scalable processing, design stateless components to accommodate scale, use Azure Scheduler
    Integrate Azure services in a solution
    • Design Azure architecture using Azure services, such as Azure AD, Azure App Service, API Management, Azure Cache, Azure Search, Service Bus, Event Hubs, Stream Analytics and IoT Hub; identify the appropriate use of Azure Machine Learning, big data, Azure Media Services and Azure Search services
    Implement messaging applications
    • Use a queue-centric pattern for development; select appropriate technology, such as Azure Storage Queues, Azure Service Bus queues, topics, subscriptions and Azure Event Hubs
    Implement applications for background processing
    • Implement Azure Batch for compute-intensive tasks, use Azure WebJobs to implement background tasks, use Azure Functions to implement event-driven actions, leverage Azure Scheduler to run processes at preset/recurring timeslots
    Design connectivity for hybrid applications
    • Connect to on-premises data from Azure applications using Service Bus Relay, Hybrid Connections or the Azure Web App virtual private network (VPN) capability; identify constraints for connectivity with VPN; identify options for joining VMs to domains or cloud services
    5.0 Design Azure Web and Mobile Apps (5–10%)
    Design Web Applications
    • Design Azure App Service Web Apps, design custom web API, offload long-running applications using WebJobs, secure Web API using Azure AD, design Web Apps for scalability and performance, deploy Azure Web Apps to multiple regions for high availability, deploy Web Apps, create App Service plans, design Web Apps for business continuity, configure data replication patterns, update Azure Web Apps with minimal downtime, back up and restore data, design for disaster recovery
    Design Mobile Applications
    • Design Azure Mobile Services; consume Mobile Apps from cross-platform clients; integrate offline sync capabilities into an application; extend Mobile Apps using custom code; implement Mobile Apps using Microsoft .NET or Node.js; secure Mobile Apps using Azure AD; implement push notification services in Mobile Apps; send push notifications to all subscribers, specific subscribers or a segment of subscribers
    6.0 Design a management, monitoring and business continuity strategy (20–25%)
    Design a monitoring strategy
    • Identify the Microsoft products and services for monitoring Azure solutions; leverage the capabilities of Azure Operations Management Suite and Azure Application Insights for monitoring Azure solutions; leverage built-in Azure capabilities; identify third-party monitoring tools, including open source; describe Azure architecture constructs, such as availability sets and update domains, and how they impact a patching strategy; analyse logs by using the Azure Operations Management Suite
    Describe Azure business continuity/disaster recovery (BC/DR) capabilities
    • Leverage the architectural capabilities of BC/DR, describe Hyper-V Replica and Azure Site Recovery (ASR), describe use cases for Hyper-V Replica and ASR
    Design a disaster recovery strategy
    • Design and deploy Azure Backup and other Microsoft backup solutions for Azure, leverage use cases when StorSimple and System Center Data Protection Manager would be appropriate, design and deploy Azure Site recovery
    Design Azure Automation and PowerShell workflows
    • Create a PowerShell script specific to Azure, automate tasks by using the Azure Operations Management Suite
    Describe the use cases for Azure Automation configuration
      Evaluate when to use Azure Automation, Chef, Puppet, PowerShell or Desired State Configuration (DSC)
    7.0 Architect an Azure Compute infrastructure (10–15%)
    Design ARM Virtual Machines (VMs)
    • Design VM deployments leveraging availability sets, fault domains and update domains in Azure; select appropriate VM SKUs
    Design ARM template deployment
    • Author ARM templates; deploy ARM templates via the portal, PowerShell and CL
    Design for availability
    • Implement regional availability and high availability for Azure deployments

    Books to Prepare

    Below are the recommended books for preparing 70-534 Exams

    CCNP Route Cover Image

    Book Name : Exam Ref 70-534 Architecting Microsoft Azure Solutions

    Author Name : Haishi Bai, Steve Maier, Dan Stolts

    Publisher : Microsoft Press

    Topics Covered in this book:


    • Chapter 1: Design Microsoft Azure infrastructure and networking
    • Chapter 2: Secure resources
    • Chapter 3: Design an application storage and data access strategy
    • Chapter 4: Design an advanced application
    • Chapter 5: Design Web Apps
    • Chapter 6: Design a management, monitoring, and business continuity strategy

    Designing and Implementing Cloud Data Platform Solutions 70- 473



    Exam Details

    Required Exam(s) Designing and Implementing Cloud Data Platform Solutions 70- 473
    Durations 120 Minutes (40 - 60 Questions)
    Question Types Multiple choice, drag and drop and simulation types.
    Exam Fees Rs.4800
    Prerequired Exams No Prerequired exam for this certifications
    Recommended Training Designing and Implementing Cloud Data Platform Solutions

    Exam Pattern

    Below are the exam topics of Designing and Implementing Cloud Data Platform Solutions 70-473.
    1.0 Design and implement database solutions for Microsoft SQL Server and SQL Database (20–25%)
    Design a hybrid SQL Server solution
    • Design Geo/DR topology, design a data storage architecture, design a security architecture, design a data load strategy
    Implement SQL Server on Azure Virtual Machines (VMs)
    • Provision SQL Server in an Azure VM, configure firewall rules, configure and optimise storage, migrate an on-premises database to Microsoft Azure, configure and optimise VM sizes by workload
    Design a SQL Database solution
    • Design a solution architecture, design Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier
    Implement SQL Database
    • Provision 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 data warehousing on Azure
    • Design a data warehousing solution on Azure, design a data load strategy and topology, configure SQL Data Warehouse, migrate an on-premises database to SQL Data Warehouse
    2.0 Manage database management systems (DBMS) 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
    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
    3.0 Design for high availability, disaster recovery and scalability (25–30%)
    Design and implement high availability solutions
    • Design a high availability solution topology, implement high availability solutions between on-premises and Azure, design cloud-based backup solutions, implement backup and recovery strategies
    Design and implement scalable solutions
    • Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for SQL Database
    Design and implement SQL Database data recovery
    • Design a backup solution for SQL Database, implement self-service restore, copy and export databases
    4.0 Monitor and manage database implementations on Azure (25–30%)
    Monitor and troubleshoot SQL Server VMs on Azure
    • Monitor database and instance activity, monitor using dynamic management views (DMVs) and dynamic management functions (DMFs), monitor performance and scalability
    Monitor and troubleshoot SQL Database
    • Monitor and troubleshoot SQL Database, monitor database activity, monitor using DMVs and DMFs, monitor performance and scalability
    Automate and manage database implementations on Azure
    • Manage SQL Server in Azure VMs with PowerShell, manage Azure SQL Database with PowerShell, configure Automation and Runbooks

    Books to Prepare

    Below are the recommended books for preparing 70-473 Exams

    No Study guides available for now, will update the details soon.
    Please click here for official course details from Microsoft.

    Designing and Implementing Big Data Analytics Solutions 70- 475


    Exam Details

    Required Exam(s) Designing and Implementing Big Data Analytics Solutions 70- 475
    Durations 120 Minutes (40 - 60 Questions)
    Question Types Multiple choice, drag and drop and simulation types.
    Exam Fees Rs.4800
    Prerequired Exams No Prerequired exam for this certifications
    Recommended Training Designing and Implementing Big Data Analytics Solutions

    Exam Pattern

    Below are the exam topics of Designing and Implementing Big Data Analytics Solutions 70-475.
    1.0 Design big data batch processing and interactive solutions (25–30%)
    Ingest data for batch and interactive processing
    • Ingest from cloud-born or on-premises data, store data in Microsoft Azure Data Lake, store data in Azure BLOB Storage, perform a one-time bulk data transfer, perform routine small writes on a continuous basis
    Design and provision compute clusters
    • Select compute cluster type, estimate cluster size based on workload
    Design for data security
    • Protect personally identifiable information (PII) data in Azure, encrypt and mask data, implement role-based security
    Design for batch processing
    • Select appropriate language and tool, identify formats, define metadata, configure output
    Design interactive queries for big data
    • Provision Spark cluster, set the right resources in Spark cluster, execute queries using Spark SQL, select the right data format (Parquet), cache data in memory (make sure cluster is of the right size), visualise using business intelligence (BI) tools (for example, Power BI, Tableau), select the right tool for business analysis
    2.0 Design big data real-time processing solutions (25–30%)
    Ingest data for real-time processing
      Select data ingestion technology, design partitioning scheme, design row key of event tables in HBase
    Design and provision compute resources
      Select streaming technology in Azure, select real-time event processing technology, select real-time event storage technology, select streaming units, configure cluster size, assign appropriate resources for Spark clusters, assign appropriate resources for HBase clusters, utilise Visual Studio to write and debug Storm topologies
    Design for Lambda architecture
      Identify application of Lambda architecture, utilise streaming data to draw business insights in real time, utilise streaming data to show trends in data in real time, utilise streaming data and convert into batch data to get historical view, design such that batch data doesn't introduce latency, utilise batch data for deeper data analysis
    Design for real-time processing
      Design for latency and throughput, design reference data streams, design business logic, design visualisation output
    3.0 Design Machine Learning solutions (20–25%)
    Create and manage experiments
    • Create, manage, and share workspaces; create training experiment; select template experiment from Machine Learning gallery
    Determine when to pre-process or train inside Machine Learning Studio
    • Select model type based on desired algorithm, select technique based on data size
    Select input/output types
    • Select appropriate SQL parameters, select BLOB storage parameters, identify data sources, select HiveQL queries
    Apply custom processing steps with R and Python
    • Visualise custom graphs, estimate custom algorithms, select custom parameters, interact with datasets through notebooks (Jupyter Notebook)
    Publish web services
    • Operationalise Azure Machine Learning models, operationalise Spark models using Azure Machine Learning, operationalise custom models
    4.0 Operationalise end-to-end cloud analytics solutions (25–30%)
    Create a data factory
    • Identify data sources, identify and provision data processing infrastructure, utilise Visual Studio to design and deploy pipelines
    Orchestrate data processing activities in a data-driven workflow
    • Leverage data-slicing concepts, identify data dependencies and chaining multiple activities, model complex schedules based on data dependencies, provision and run data pipelines
    Monitor and manage the data factory
    • Identify failures and root causes, create alerts for specified conditions, perform a restatement
    Move, transform, and analyse data
    • Leverage Pig, Hive, MapReduce for data processing; copy data between on-premises and cloud; copy data between cloud data sources; leverage stored procedures; leverage Machine Learning batch execution for scoring, retraining, and update resource; extend the data factory with custom processing steps; load data into a relational store, visualise using Power BI
    Design a deployment strategy for an end-to-end solution
    • Leverage PowerShell for deployment, automate deployment programmatically

    Books to Prepare

    Below are the recommended books for preparing 70-475 Exams




    No Study guides available for now, will update the details soon.