Exam 70-417 is an upgrade exam that is a composite of three standalone exams: 70-410, 70-411, and 70-412. Exam 70-417 validates skills related to core features and functionality of Windows Server 2012 R2, from the existing knowledge base of a Microsoft Certified Systems Administrator for Windows Server 2008. Mackin helps you prepare for the exam by focusing on the core technical skills.

Fully updated for Windows Server 2012 R2! Prepare for Microsoft Exam 70-417 - and help demonstrate your real-world mastery of Windows Server 2012 R2 core infrastructure services. Exam 70-417 is an upgrade exam that is a composite of three standalone exams: 70-410, 70-411, and 70-412. Exam 70-417 validates skills related to core features and functionality of Windows Server 2012 R2, from the existing knowledge base of a Microsoft Certified Systems Administrator for Windows Server 2008. Focus on the expertise measured by these objectives: EXAM 70-410 Install and configure servers Configure server roles and features Configure Hyper-V Deploy and configure core network services Install and administer Active Directory EXAM 70-411 Deploy, manage, and maintain servers Configure network services and access Configure a network policy server infrastructure Configure and manage Active Directory Configure and manage Group Policy EXAM 70-412 Configure and manage high availability Configure file and storage solutions Implement business continuity and disaster recovery Configure network services Configure identity and access solutions This Microsoft Exam Ref: Organizes its coverage by exam objectives. Features strategic, what-if scenarios to challenge you.

This study guide helps readers prepare for Microsoft Exam 70-740, required for Microsoft Certified Solutions Associate certification for Windows Server 2016.

Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI

About the Book: Prepare for Microsoft Exam 70-743—and demonstrate that your skills are upgraded for Windows Server 2016. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the skills measured on the exam: • Install Windows servers in host and compute environments • Implement storage solutions • Implement Hyper-V • Implement Windows containers • Implement high availability • Implement Domain Name System (DNS) • Implement IP Address Management (IPAM) • Implement network connectivity and remote access solutions • Implement an advanced network infrastructure • Install and configure Active Directory Domain Services (AD DS) • Implement identity federation and access solutions This Microsoft Exam Ref: • Organizes its coverage by the “Skills measured” posted on the exam webpage • Features strategic, what-if scenarios to challenge you • Points to in-depth material by topic for exam candidates needing additional review • Assumes you are an IT pro looking to validate your skills in and knowledge of installing and configuring Windows Server 2016

Prepare for Microsoft Exam 70-742—and help demonstrate your real-world mastery of Windows Server 2016 identity features and functionality. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: · Install and configure Active Directory Domain Services (AD DS) · Manage and maintain AD DS · Create and manage Group Policy · Implement Active Directory Certificate Services (AD CS) · Implement identity federation and access solutions This Microsoft Exam Ref: · Organizes its coverage by exam objectives · Features strategic, what-if scenarios to challenge you · Assumes you have experience working with Windows Server, Windows clients, and virtualization; are familiar with core networking technologies, and are aware of basic security best practices

Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package. Focus on the expertise measured by these objectives: • Design, and implement, and maintain a data warehouse • Extract, transform, and load data • Build data quality solutionsThis Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse. Implementing a SQL Data Warehouse About the Exam Exam 70-767 focuses on skills and knowledge required for working with relational database technology. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification. See full details at: microsoft.com/learning