Microsoft Azure Online Training in Oman

create users and groups

manage user and group properties

manage device settings

perform bulk user updates

manage guest accounts

configure Azure AD Join

configure self-service password reset

NOTE: Azure AD Connect; PIM

create a custom role

provide access to Azure resources by assigning roles

subscriptions

resource groups

resources (VM, disk, etc.)

interpret access assignments

manage multiple directories

configure Azure policies

configure resource locks

apply tags

create and manage resource groups

move resources

remove RGs

manage subscriptions

configure Cost Management

configure management groups

configure network access to storage accounts

create and configure storage accounts

generate shared access signature

manage access keys

implement Azure storage replication

configure Azure AD Authentication for a storage account

export from Azure job

import into Azure job

install and use Azure Storage Explorer

copy data by using AZ Copy

create an Azure file share

create and configure Azure File Sync service

configure Azure blob storage

configure storage tiers for Azure blobs

configure high availability

deploy and configure scale sets

modify Azure Resource Manager (ARM) template

configure VHD template

deploy from template

save a deployment as an ARM template

automate configuration management by using custom script extensions

configure Azure Disk Encryption

move VMs from one resource group to another

manage VM sizes

add data discs

configure networking

redeploy VMs

create and configure Azure Kubernetes Service (AKS)

create and configure Azure Container Instances (ACI)

NOT: selecting a container solution architecture or product; container registry settings

create and configure App Service

create and configure App Service Plans

NOT: Azure Functions; Logic Apps; Event Grid

create and configure VNET peering

configure private and public IP addresses, network routes, network interface, subnets, and virtual network

configure Azure DNS

configure custom DNS settings

configure a private or public DNS zone

create security rules

associate an NSG to a subnet or network interface

evaluate effective security rules

deploy and configure Azure Firewall

deploy and configure Azure Bastion Service

NOT: Implement Application Security Groups; DDoS

configure Application Gateway

configure an internal load balancer

configure load balancing rules

configure a public load balancer

troubleshoot load balancing

NOT: Traffic Manager and Front Door and Private Link

monitor on-premises connectivity

use Network Performance Monitor

use Network Watcher

troubleshoot external networking

troubleshoot virtual network connectivity

create and configure Azure VPN Gateway

create and configure VPNs

configure ExpressRoute

configure Azure Virtual WAN

Validate your technical skills like storage, networking, compute, security, and other Cloud operations on Microsoft Azure.

Validate your development skills and showcase your expertize in building cloud solutions, apps, and services.

Top-paying info-tech certification in the world.

It provides you with global recognition for your knowledge, skills, and experience.

The organization looks for those who know Oracle Cloud, AWS, Azure, etc.

Introduction to Cloud Computing

Microsoft Azure Overview

Microsoft Azure Services

Azure Subscriptions

Azure Resource Groups

Organizing Azure Resources

What are Virtual Machines

Introduction to ARM Templates

What are batch Jobs and Azure Batch Services

What is Kubernetes

provision VMs configure VMs for remote access

create ARM templates

create container images for solutions by using Docker

publish an image to the Azure Container Registry

run containers by using Azure Container Instance

Azure Kubernetes Service (AKS) is out of scope

create an Azure App Service Web App

enable diagnostics logging

deploy code to a web app

configure web app settings including SSL, API, and connection strings

implement auto scaling rules, including scheduled auto scaling, and scaling by operational or system metrics

implement input and output bindings for a function

implement function triggers by using data operations, timers, and web-hooks

implement Azure Durable Functions

select the appropriate API for your solution

implement partitioning schemes

interact with data using the appropriate SDK

set the appropriate consistency level for operations

create Cosmos DB containers

implement scaling (partitions, containers)

implement server-side programming including stored procedures, triggers, and change feed notifications

move items in Blob storage between storage accounts or containers

set and retrieve properties and metadata

interact with data using the appropriate SDK

implement data archiving and retention

implement hot, cool, and archive storage

implement OAuth2 authentication

create and implement shared access signatures

register apps and use Azure Active Directory to authenticate users

control access to resources by using role-based access controls (RBAC)

secure app configuration data by using the App Configuration and KeyVault API

manage keys, secrets, and certificates by using the KeyVault API

implement Managed Identities for Azure resources

Design a log routing solution

Recommend an appropriate level of logging

Recommend a monitoring tool(s) for a solution

Recommend a solution for securing resources with role-based access controls

Recommend an identity management solution

Recommend a solution for securing identities

Recommend an organizational and hierarchical structure for Azure resources

Recommend a solution for enforcing and auditing compliance

Recommend solutions to allow applications to access Azure resources

Recommend a solution that securely stores passwords and secrets

Recommend a solution for integrating applications into Azure AD

Recommend a user consent solution for applications

Recommend database service tier sizing

Recommend a solution for database scalability

Recommend a solution for encrypting data at rest, data in transmission, and data in use

Design Data Integration

Recommend a solution for data integration

Recommend a solution for storing relational data

Recommend a solution for storing semi-structured data

Recommend a solution for storing non-relational data

Recommend access control solutions to data storage

Recommend a data storage solution to balance features, performance, and cost

Design a data solution for protection and durability

Recommend a recovery solution for Azure, hybrid, and on-premises workloads that meets

Recovery objectives (RTO, RLO, RPO)

Understand the recovery solutions for containers

Recommend a backup and recovery solution for compute

Recommend a backup and recovery solution for databases

Recommend a backup and recovery solution for unstructured data

Identify the availability requirements of Azure resources

Recommend a high availability solution for Compute

Recommend a high availability solution for non-relational data storage

Recommend a high availability solution for relational data storage

Recommend a Virtual Machine-based compute solution

Recommend an appropriately sized compute solution based on workload requirements

Recommend a Container-based compute solution

Recommend a Server less-based compute solution Describe Azure network security

Recommend a caching solution for applications

Recommend a messaging architecture

Recommend an event-driven architecture

Recommend an automated deployment solution for your applications

Recommend an application configuration management solution

Recommend a solution for API integration

Evaluate migration solution that leverages the Cloud Adoption Framework

Assess and interpret on-premises servers, data, and applications for migration

Recommend a solution for migrating applications and Virtual Machines

Recommend a solution for migrating databases

Recommend a solution for migrating unstructured data

Recommend a network architecture solution based on workload requirements

Recommend a connectivity solution that connects Azure resources to the Internet

Recommend a connectivity solution that connects Azure resources to on-premises networks

Optimize network performance for applications

Recommend a solution to optimize network security

Recommend a load balancing and routing solution

Course Overview

Introduction to Cloud computing

Introduction to Azure

Self-hosting to cloud hosting

Azure Services

Azure Regions

Introduction to DevOps

Where did DevOps come from

What problems led to the creation of DevOps

How is DevOps different from Traditional IT

Why you need DevOps

DevOps Implementation Features

DevOps Lifecycle Phases and Measures

Workflow in DevOps

How DevOps Improved the Development and Operation Process

High Demand roles in DevOps

Future scope of DevOps

assess and Configure a log framework

design a log aggregation and storage strategy (e.g. Azure storage)

design a log aggregation using Azure Monitor

manage access control to logs (workspace-centric/resource-centric)

integrate crash analytics (App Center Crashes, Crashlytics)

design and implement distributed tracing

inspect application performance indicators

inspect infrastructure performance indicators

define and measure key metrics (CPU, memory, disk, network)

implement alerts on key metrics (email, SMS, webhooks, Teams/Slack)

integrate user analytics (e.g. Application Insights funnels, Visual Studio App Center, TestFlight, Google Analytics)

configure and integrate container monitoring (Azure Monitor, Prometheus,)

configure and integrate with monitoring tools (Azure Monitor Application Insights, Dynatrace, New Relic, Nagios, Zabbix)

create feedback loop from platform monitoring tools (e.g. Azure Diagnostics VM extensions, Azure Platform Logs, Event Grid)

manage Access control to the monitoring platform

identify and recommend metrics on which to base alerts

implement alerts using appropriate metrics

implement alerts based on appropriate log messages

implement alerts based on application health checks

analyze combinations of metrics

develop communication mechanism to notify users of degraded systems

implement alerts for self-healing activities (e.g. scaling, failovers)

analyze behavior of system with regards to load and failure conditions

calculate when a system will fail under various conditions

measure baseline metrics for system

recommend the appropriate tools for a failure prediction strategy

analyze system dependencies to determine which dependency should be included in

health check

calculate healthy response timeouts based on SLO for the service

design approach for partial health situations

integrate health check with compute environment

implement different types of health checks (liveness, startup, shutdown)

design an access solution (Azure AD Privileged Identity Management (PIM), Azure AD

Conditional Access, MFA)

organize the team using Azure AD groups

implement Service Principals and Managed Identity

configure service connections

evaluate and configure vault solution (Azure Key Vault, Hashicorp Vault)

generate security certificates

design a secrets storage and retrieval strategy

formulate a plan for deploying secret files as part of a release

automate dependencies scanning for security (container scanning, OWASP)

automate dependencies scanning for compliance (licenses: MIT, GPL)

assess and report risks

design a source code compliance solution (e.g. GitHub security, pipeline-based scans, Git hooks, SonarQube)

implement Azure policies to enforce organizational requirements

implement container scanning (e.g. static scanning, malware, crypto mining)

design and implement Azure Container Registry Tasks (Azure Policy)

design break-the-glass strategy for responding to security incidents

Introduction to Cloud Computing

Overview of Microsoft Azure

Microsoft Azure Services

Azure Subscriptions

Management Groups

Azure Resource Manager

Azure Portal and PowerShell

Azure Resource Manager Policies

Azure Policy Definition Structure

Resource Management Locks

Organizing Azure Resources

Introduction

Azure Virtual Networks

IP Addresses – Public & Private

Classless Inter-domain Routing (CIDR)

Subnets

Network Interface Cards (NICs)

Network Security Groups (NSGs)

Network Security Group Rules

Virtual Network Service Endpoints

Service Endpoint Policies

Azure Load Balancer

Azure DNS

Plan and Design Azure Virtual Networks

add custom domains

Azure AD Join

configure self-service password reset

manage multiple directories

create users and groups

manage user and group properties

manage device settings

perform bulk user updates

manage guest accounts

install Azure AD Connect, including password hash and pass-through synchronization

use Azure AD Connect to configure federation with on-premises Active Directory Domain Services (AD DS)

manage Azure AD Connect

manage password sync and password writeback

configure user accounts for MFA

enable MFA by using bulk update

configure fraud alerts

configure bypass options

configure Trusted IPs

configure verification methods

monitor privileged access for Azure AD Privileged Identity Management (PIM)

configure Access Reviews

activate and configure PIM

configure Azure AD identity protection

create App Registration

configure App Registration permission scopes

manage App Registration permission consent

manage API access to Azure subscriptions and resources

configure subscription and resource permissions

configure resource group permissions

configure custom RBAC roles

identify the appropriate role

apply principle of least privilege

interpret permissions

check access

populate Azure Stack Hub Marketplace in a disconnected environment

create a custom Azure Stack Hub Marketplace item

manage lifecycle for Azure Stack Hub Marketplace items

plan an App Services resource provider deployment

deploy an App Services resource provider

update an App Services resource provider

scale roles based on capacity requirements

rotate App Services secrets and certificates

manage worker tiers

back up App Services

plan an Event Hubs resource provider deployment

deploy an Event Hubs resource provider

update an Event Hubs resource provider

rotate Event Hubs secrets and certificates

create and manage quotas

create and manage plans

create and manage offers

create and manage user subscriptions

change user subscription owner

set up usage data reporting

view and retrieve usage data by using the Usage API

manage usage and billing in multi-tenant and CSP scenarios

recommend a name resolution strategy

recommend a public and internal IP strategy

recommend a data center firewall integration strategy

recommend an identity provider

validate identity provider integration

configure the Time Server (NTP)

recommend a certificate strategy

validate the certificates

run secret rotation PowerShell cmdlet for external certificates

recommend a registration model

register in a connected environment

register in a disconnected environment

re-register

configure Azure Stack Hub home directory

register the guest tenant directory with Azure Stack Hub

disable multi-tenancy

update guest tenant directory

identify an appropriate method for access (service principal, users, groups)

provision a service principal for Azure Stack Hub

recommend a permission model

configure access in Azure Stack Hub

create a custom role

recommend a monitoring strategy

monitor system health by using the REST API

includes resource providers such as Event Hubs

monitor system health by using Syslog Server

manage field replacement or repair

configure automatic diagnostic log collection

collect diagnostic logs on demand by using Power shell

configure Syslog forwarding for Azure Stack Hub infrastructure

recommend a business continuity disaster recovery (BCDR) strategy

recommend a strategy for infrastructure backups

configure storage target for infrastructure backups

configure certificates for infrastructure backups

configure frequency and retention policy for infrastructure backups

plan for system capacity

manage partitioned GPUs

add nodes

manage storage capacity

add IP pools

update Azure Stack Hub

download and import update packages manually

update Azure AD Home Directory

connect to a privileged endpoint

configure the cloud admin user role

unlock a support session

close the session on the privileged endpoint

stop and start Azure Stack Hub

perform system diagnostics by using Test-Azure Stack

Identify the benefits of cloud computing, such as High Availability, Scalability, Elasticity,

Agility, and Disaster Recovery

Identify the differences between Capital Expenditure (Cap Ex) and Operational

Expenditure (Op Ex)

Describe the consumption-based model

Describe the shared responsibility model

Describe Infrastructure-as-a-Service (IaaS),

Describe Platform-as-a-Service (PaaS)

Describe server less computing

Describe Software-as-a-Service (SaaS)

Identify a service type based on a use case

Define cloud computing

Describe Public cloud

Describe Private cloud

Describe Hybrid cloud

Compare and contrast the three types of cloud computing

Describe the benefits and usage of Regions and Region Pairs

Describe the benefits and usage of Availability Zones

Describe the benefits and usage of Resource Groups

Describe the benefits and usage of Subscriptions

Describe the benefits and usage of Management Groups

Describe the benefits and usage of Azure Resource Manager

Explain Azure resources

Describe the benefits and usage of Virtual Machines, Azure App Services, Azure

Container Instances (ACI), Azure Kubernetes Service (AKS), and Azure Virtual Desktop

Describe the benefits and usage of Virtual Networks, VPN Gateway, Virtual Network peering, and ExpressRoute

Describe the benefits and usage of Container (Blob) Storage, Disk Storage, File Storage, and storage tiers

Describe the benefits and usage of Cosmos DB, Azure SQL Database, Azure Database for MySQL, Azure Database for PostgreSQL, and SQL Managed Instance

Describe the benefits and usage of Azure Marketplace

Describe the benefits and usage of Internet of Things (IoT) Hub, IoT Central, and Azure Sphere

Describe the benefits and usage of Azure Synapse Analytics, HDInsight, and Azure Data bricks

Describe the benefits and usage of Azure Machine Learning, Cognitive Services and Azure Bot Service

Describe the benefits and usage of server less computing solutions that include Azure Functions and Logic Apps

Describe the benefits and usage of Azure DevOps, GitHub, GitHub Actions, and Azure Dev Test Labs

Describe the functionality and usage of the Azure Portal, Azure PowerShell, Azure CLI, Cloud Shell, and Azure Mobile App

Describe the functionality and usage of Azure Advisor

Describe the functionality and usage of Azure Resource Manager (ARM) templates

Describe the functionality and usage of Azure Monitor

Describe the functionality and usage of Azure Service Health

Describe basic features of Azure Security Center, including policy compliance, security alerts, secure score, and resource hygiene

Describe the functionality and usage of Key Vault

Describe the functionality and usage of Azure Sentinel

Describe the functionality and usage of Azure Dedicated Hosts

Describe the concept of defence in depth

Describe the functionality and usage of Network Security Groups (NSG)

Describe the functionality and usage of Azure Firewall

Describe the functionality and usage of Azure DDoS protection

Implement a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage

Implement data distribution and partitions

Implement a consistency model in Cosmos DB

Provision a non-relational data store

Provide access to data to meet security requirements

Implement for high availability, disaster recovery, and global distribution

Provide access to data to meet security requirements

Implement for high availability and disaster recovery

Implement data distribution and partitions for azure synapse analytics

Implement poly base

Implement data masking

Encrypt data at rest and in motion

Develop batch processing solutions by using Data Factory and Azure Databricks

Ingest data by using Poly Base

Implement the integration runtime for Data Factory

Create linked services and datasets

Create pipelines and activities

Create and schedule triggers

Implement Azure Databricks clusters, notebooks, jobs, and autoscaling

Ingest data into Azure Databricks

Configure input and output

Select the appropriate built-in functions

Implement event processing by using stream analytics

Monitor relational and non-relational data stores

Implement blob storage monitoring

Implement data lake storage gen2 monitoring

Implement azure synapse analytics monitoring

Implement cosmos DB monitoring

Configure azure monitor alerts

Implement auditing by using azure log analytics

Monitor Data Factory pipelines

Monitor Azure Databricks

Monitor Stream Analytics

Configure Azure Monitor alerts

Implement auditing by using Azure Log Analytics

Troubleshoot data partitioning bottlenecks

Optimize data lake storage gen2

Optimize stream analytics

Optimize azure synapse analytics

Manage the data lifecycle

Tips to clear an Interview

Common Interview questions and answers

DP-200 Interview Questions and Answers

Resume Building Guide

Attempt for DP-200 Global Certification Exam

Earn Credentials and Start applying for Jobs

Choose the correct data storage solution to meet technical & business requirements

Choose the partition distribution type

Design data distribution and partitions

Design for scale (including multi-region, latency, and throughput)

Design a solution that uses cosmos DB, data lake storage gen2, or blob storage

Select the appropriate cosmos DB API

Design a disaster recovery strategy

Design for high availability

Design data distribution and partitions

Design for scale (including latency, and throughput)

Design a solution that uses azure synapse analytics

Design a disaster recovery strategy

Design for high availability

Design batch processing solutions that use Data Factory and Azure Databricks

Identify the optimal data ingestion method for a batch processing solution

Identify where processing should take place, such as at the source, at the destination, or in transit

Design for real-time processing by using Stream Analytics and Azure Databricks

Design and provision compute resources

Plan for secure endpoints (private/public)

Choose the appropriate authentication mechanism, such as access keys, shared access signatures (SAS), and azure active directory (azure ad)

Design data encryption for data at rest and in transit

Design for data auditing and data masking

Design for data privacy and data classification

Design a data retention policy

Plan an archiving strategy

Plan to purge data based on business requirements

Tips to clear an Interview

Common Interview questions and answers

DP-201 Interview Questions and Answers

Resume Building Guide

Attempt for DP-201 Global Certification Exam

Earn Credentials and Start applying for Jobs

Design an Azure Data Lake solution

Recommend file types for storage

Recommend file types for analytical queries

Design for efficient querying

Design for data pruning

Design a folder structure that represents the levels of data transformation

Design a distribution strategy

Design a partition strategy for files

Design a partition strategy for analytical workloads

Design a partition strategy for efficiency/performance

Design a partition strategy for Azure Synapse Analytics

Identify when partitioning is needed in Azure Data Lake Storage Gen2

Design star schemas

Design slowly changing dimensions

Design a dimensional hierarchy

Design a solution for temporal data

Design for incremental loading

Design analytical stores

Design meta stores in Azure Synapse Analytics and Azure Data bricks

Implement compression

Implement partitioning

Implement sharing

Implement different table geometries with Azure Synapse Analytics pools

Implement data redundancy

Implement distributions

Implement data archiving

Build a temporal data solution

Build a slowly changing dimension

Build a logical folder structure

Build external tables

Implement file and folder structures for efficient querying and data pruning

Deliver data in a relational star schema

Deliver data in Parquet files

Maintain metadata

Implement a dimensional hierarchy

Transform data by using Apache Spark

Transform data by using Transact-SQL

Transform data by using Data Factory

Transform data by using Azure Synapse Pipelines

Transform data by using Stream Analytics

Cleanse data

Split data

Shred JSON

Encode and decode data

Configure error handling for the transformation

Normalize and deformalize values

Transform data by using Scala

Perform data exploratory analysis

Develop batch processing solutions by using Data Factory, Data Lake, Spark, Azure

Synapse Pipelines, Polybasic, and Azure Data bricks

Create data pipelines

Design and implement incremental data loads

Design and develop slowly changing dimensions

Handle security and compliance requirements

Scale resources

Configure the batch size

Design and create tests for data pipelines

Integrate Jupyter/Python notebooks into a data pipeline

Handle duplicate data

Handle missing data

Handle late-arriving data

Upset data

Regress to a previous state

Design and configure exception handling

Configure batch retention

Design a batch processing solution

Debug Spark jobs by using the Spark UI

Develop a stream processing solution by using Stream Analytics, Azure Data bricks, and

Azure Event Hubs

Process data by using Spark structured streaming

Monitor for performance and functional regressions

Design and create windowed aggregates

Handle schema drift

Process time series data

Process across partitions

Process within one partition

Configure checkpoints/watermarking during processing

Scale resources

Design and create tests for data pipelines

Optimize pipelines for analytical or transactional purposes

Handle interruptions

Design and configure exception handling

Upset data

Replay archived stream data

Design a stream processing solution

Trigger batches

Handle failed batch loads

Validate batch loads

Manage data pipelines in Data Factory/Synapse Pipelines

Schedule data pipelines in Data Factory/Synapse Pipelines

Implement version control for pipeline artefacts

Manage Spark jobs in a pipeline

Design data encryption for data at rest and in transit

Design a data auditing strategy

Design a data masking strategy

Design for data privacy

Design a data retention policy

Design to purge data based on business requirements

Design Azure role-based access control (Azure RBAC) and POSIX-like Access Control List

(ACL) for Data Lake Storage Gen2

Design row-level and column-level security

Implement data masking

Encrypt data at rest and in motion

Implement row-level and column-level security

Implement Azure RBAC

Implement POSIX-like ACLs for Data Lake Storage Gen2

Implement a data retention policy

Implement a data auditing strategy

Manage identities, keys, and secrets across different data platform technologies

Implement secure endpoints (private and public)

Implement resource tokens in Azure Data bricks

Load a Data Frame with sensitive information

Write encrypted data to tables or Parquet files

Manage sensitive information

Implement logging used by Azure Monitor

Configure monitoring services

Measure performance of data movement

Monitor and update statistics about data across a system

Monitor data pipeline performance

Measure query performance

Monitor cluster performance

Understand custom logging options

Schedule and monitor pipeline tests

Interpret Azure Monitor metrics and logs

Interpret a Spark directed acyclic graph (DAG)

Compact small files

Rewrite user-defined functions (UDFs)

Handle skew in data

Handle data spill

Tune shuffle partitions

Find shuffling in a pipeline

Optimize resource management

Tune queries by using indexers

Tune queries by using cache

Optimize pipelines for analytical or transactional purposes

Optimize pipeline for descriptive versus analytical workloads

Troubleshoot a failed spark job

Troubleshoot a failed pipeline run

deploy database offerings on selected platforms

configure customized deployment templates

apply patches and updates for hybrid and IaaS deployment

evaluate requirements for the deployment

evaluate the functional benefits/impact of possible database offerings

evaluate the scalability of the possible database offering

evaluate the HA/DR of the possible database offering

evaluate the security aspects of the possible database offering

configure Azure SQL database/elastic pools for scale and performance

configure Azure SQL managed instances for scale and performance

configure SQL Server in Azure VMs for scale and performance

calculate resource requirements

evaluate database partitioning techniques, such as database sharding

set up SQL Data Sync

evaluate requirements for the migration

evaluate offline or online migration strategies

evaluate requirements for the upgrade

evaluate offline or online upgrade strategies

implement an online migration strategy

implement an offline migration strategy

implement an online upgrade strategy

implement an offline upgrade strategy

configure Azure AD authentication

create users from Azure AD identities

configure security principals

configure database and object-level permissions using graphical tools

apply principle of least privilege for all securables

implement Transparent Data Encryption (TDE)

implement object-level encryption

implement Dynamic Data Masking

implement Azure Key Vault and disk encryption for Azure VMs

configure server and database-level firewall rules

implement Always Encrypted

apply a data classification strategy

configure server and database audits

implement data change tracking

perform a vulnerability assessment

prepare an operational performance baseline

determine sources for performance metrics

interpret performance metrics

configure and monitor activity and performance at the infrastructure, server, service, and database levels

implement index maintenance tasks

implement statistics maintenance tasks

configure database auto-tuning

automate database maintenance tasks

manage storage capacity

configure Query Store to collect performance data

identify sessions that cause blocking

assess growth/fragmentation of databases and logs

assess performance-related database configuration parameters

configure storage and infrastructure resources

configure server and service account settings for performance

configure Resource Governor for performance

implement database-scoped configuration

configure compute resources for scaling

configure Intelligent Query Processing (IQP)

determine the appropriate type of execution plan

identify problem areas in execution plans

extract query plans from the Query Store

determine the appropriate Dynamic Management Views (DMVs) to gather query performance information

identify performance issues using DMVs

identify and implement index changes for queries

recommend query construct modifications based on resource usage

assess the use of hints for query performance

identify data quality issues with duplication of data

identify normal form of database tables

assess index design for performance

validate data types defined for columns

recommend table and index storage including file groups

evaluate table partitioning strategy

evaluate the use of compression for tables and indexes