MCSE Data Management and Analytics


comp name

This certification will validate your expertise in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments.
Earning this certification qualifies you for a position for such jobs as database analyst, database designer, and business intelligence analyst.

Prerequired Exam(s) Or Skills :
Before attempting MCSE Data Management and Analytics Exam, candidates should pass anyone mcsa exams like MCSA in SQL Server 2012/2014, or SQL 2016 Database Administration, Database Development, BI Development or Machine Learning.

To Earn MCSE Data Management and Analytics Certification, Candidates should pass any 1 exam that are listed below.



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.



Exam 70-464 : Developing Microsoft SQL Server Databases


Exam Details

Required Exam(s) 70-464
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Developing Microsoft SQL Server Databases

Exam Pattern

Below are the exam objectives of Exam 70-464 : Developing Microsoft SQL Server Databases

In this exam you will be tested on following areas and you have to score necessary % in all areas.

Implement database objects (30–35%)
  • Create and alter tables
  • Design, implement, and troubleshoot security
  • Design the locking granularity level
  • Implement indexes
  • Implement data types
  • Create and modify constraints
Implement programming objects (15-20%)
  • Design and implement stored procedures
  • Design T-SQL table-valued and scalar functions
  • Create, use, and alter user-defined functions (UDFs)
  • Create and alter views
Design database objects (25–30%)
  • Design tables
  • Design for concurrency
  • Design indexes
  • Design data integrity
  • Design for implicit and explicit transactions
Optimize and troubleshoot queries (25–30%)
  • Optimize and tune queries
  • Troubleshoot and resolve performance problems
  • Optimize indexes
  • Capture and analyze execution plans
  • Collect performance and system information

Books to Prepare


No Official books available for now, instead you can check online course training videos in Microsoft website.

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions




Exam 70-465 : Designing Database Solutions for Microsoft SQL Server


Exam Details

Required Exam(s) 70-465
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Designing Database Solutions for Microsoft SQL Server

Exam Pattern

Below are the exam objectives of Exam 70-465 : Designing Database Solutions for Microsoft SQL Server

In this exam you will be tested on following areas and you have to score necessary % in all areas.

Design a database structure (25–30%)
  • Design for business requirements
  • Design physical database and object placement
  • Design a table and index partitioning strategy
  • Design a migration, consolidation, and upgrade strategy
  • Design SQL Server instances
  • Design backup and recovery
Design databases and database objects (30–35%)
  • Design a database model
  • Design tables
  • Design for concurrency
  • Design T-SQL stored procedures
  • Design a management automation strategy
  • Design for transactions
Design database security (10–15%)
  • Design an application strategy to support security
  • Design database, schema, and object security permissions
  • Design instance-level security configurations
Design a troubleshooting and optimization solution (25–30%)
  • Design a maintenance strategy for database servers
  • Troubleshoot and resolve concurrency issues
  • Design and implement a high availability solution
  • Design a solution to monitor performance and concurrency
  • Design a monitoring solution at the instance level

Books to Prepare


No Official books available for now, instead you can check online course training videos in Microsoft website.

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions




Exam 70-466 : Implementing Data Models and Reports with Microsoft SQL Server


Exam Details

Required Exam(s) 70-466
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Implementing Data Models and Reports with Microsoft SQL Server

Exam Pattern

Below are the exam objectives of Exam 70-466 : Implementing Data Models and Reports with Microsoft SQL Server

In this exam you will be tested on following areas and you have to score necessary % in all areas.

Build an analysis services multidimensional database (35-40%)
  • Design dimensions and measures
  • Implement and configure dimensions in a cube
  • Design a schema to support cube architecture
  • Create and configure measures
  • Implement a cube
  • Create Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) queries
  • Implement custom logic in a data model
  • Implement storage design in a multidimensional model
  • Select an appropriate model for data analysis
Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database (15-20%)
  • Analyze data model performance
  • Process data models
  • Troubleshoot data analysis issues
  • Deploy SSAS databases
  • Install and maintain an SSAS instance
Build a tabular data model (15-20%)
  • Configure permissions and roles in a tabular model
  • Implement a tabular data model
  • Implement business logic in a tabular data model
  • Implement data access for a tabular data model
Build a report with SQL Server Reporting Services (SSRS) (25-30%)
  • Design a report
  • Implement a report layout
  • Configure authentication and authorization for a reporting solution
  • Implement interactivity in a report
  • Troubleshoot reporting services issues
  • Manage a report environment
  • Configure report data sources and datasets

Books to Prepare


No Official books available for now, instead you can check online course training videos in Microsoft website.

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions




Exam 70-467 : Designing Business Intelligence Solutions with Microsoft SQL Server


Exam Details

Required Exam(s) 70-467
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Designing Business Intelligence Solutions with Microsoft SQL Server

Exam Pattern

Below are the exam objectives of Exam 70-467 : Designing Business Intelligence Solutions with Microsoft SQL Server

In this exam you will be tested on following areas and you have to score necessary % in all areas.

Plan business intelligence (BI) infrastructure (15–20%)
  • Plan for performance
  • Plan for scalability
  • Plan and manage upgrades
  • Maintain server health
Design BI infrastructure (15–20%)
  • Design a security strategy
  • Design a SQL partitioning strategy
  • Design a high availability and disaster recovery strategy
  • Design a logging and auditing strategy
Design a reporting solution (20–25%)
  • Design a Reporting Services dataset
  • Manage Excel Services/reporting for SharePoint
  • Design a data acquisition strategy
  • Plan and manage reporting services configuration
  • Design BI reporting solution architecture
Design BI data models (30–35%)
  • Design the data warehouse
  • Design a schema
  • Design cube architecture
  • Design fact tables
  • Design BI semantic models
  • Design and create MDX calculations
Design an ETL solution (10–15%)
  • Design SSIS package execution
  • Plan to deploy SSIS solutions
  • Design package configurations for SSIS packages

Books to Prepare


No Official books available for now, instead you can check online course training videos in Microsoft webiste.

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions