Index

A

  1. Azure Active Directory (AAD)

  2. Azure architecture

    1. compute

    2. fault domain

    3. IaaS

    4. models

      1. classic deployment model

      2. deployment automation

      3. RBAC

      4. Resource Manager deployment model

    5. network

    6. Portal

      1. monitoring metrics configuration

      2. monitor resource utilization

      3. portal metrics

      4. properties

      5. resource utilization metrics

    7. services

      1. IaaS

      2. PaaS

      3. SaaS

    8. storage

    9. update domain

    10. virtual machine

      1. NAS

      2. PaaS

      3. SaaS

      4. SAN

      5. web role

  3. Azure SQL database

    1. architecture

      1. control ring functions

      2. tenant ring

    2. geo-replication

      1. activation

      2. active

      3. performance failover

      4. secondary replication

    3. geo-restore

      1. configuration options

      2. database online

      3. initiation

    4. local redundancy

      1. detailed representation

      2. reconfiguration

      3. representational view

    5. management

SeeManagement tools

  1. migration

    1. database

SeeDatabase migration

  1. SQLPackage.exe

  2. SSMS

  1. point-in-time restore

    1. deleted database

    2. initallation

    3. restore operation

    4. source code

  2. service tiers

    1. DTUs across

    2. elastic database pool

    3. limits and capabilities

    4. performance level

  3. vs. SQL Server

  1. Azure Virtual Machines

SeeSQL Server instance

B

  1. Blob storage

  2. Business continuity and security

    1. Azure SQL database

      1. geo-replication

      2. geo-restore

      3. local redundancy

      4. point-in-time restore

      5. transactional replication

    2. designing applications

    3. human errors

    4. maintenance and upgrades

    5. planning/designing

    6. security

SeeSecurity and auditing

  1. site outages

C

  1. Cell-level/column data encryption

  2. Cloud computing

    1. Azure services

      1. backup services

      2. compute offerings

SeeCompute offerings

  1. data management offerings

SeeData management offerings

  1. developer services

SeeDeveloper services

  1. networking

SeeNetworking

  1. Site Recovery

  1. key characteristics

  2. Microsoft Azure

  3. service models

    1. IaaS

    2. PaaS

    3. SaaS

  1. Compute offerings

    1. Azure WebApps

    2. Virtual Machines

    3. VMs

  2. Compute Resource Provider (CRP)

  3. Control ring functions

    1. architecture

    2. control management node

    3. management services node

    4. services node redirection

D

  1. Database migration

    1. export/import bacpac file

    2. option

    3. SSMS deployment

    4. transaction replication

  2. Database Throughput Units (DTUs)

    1. definition

  3. Data management offerings

    1. Azure Blobs

    2. Azure SQL Database

    3. Azure VMs

    4. NoSQL/key-value storage

  4. Data masking

  5. Deterministic Encryption

  6. Developer services

    1. Application Insights

    2. Visual Studio Team Services

  7. DMV and catalog views

    1. database related information

    2. execution related information

    3. resource utilization

E

  1. Estimated Recovery Time (ERT)

  2. Extended Events/(XEvents)

    1. access database node

    2. DMVs and catalog views

    3. T-SQL script

    4. XEvent script

F

  1. File storage

G, H

  1. Geo-replication

    1. activation

      1. action

      2. configuration option

      3. initialization

      4. representation view

      5. source code

    2. performance failover

    3. standard creation

      1. configuration options

      2. database status

      3. management portal case

      4. representational view

      5. source code

  2. Globally Redundant Storage (GRS)

I, J, K

  1. Identity services

  2. Infrastructure as a Service (IaaS)

  3. In-memory optimizations

L

  1. Locally Redundant Storage (LRS)

M

  1. Management tools

    1. Azure Portal

      1. database creation and properties

      2. service tier and performance level

      3. SQL Server management studio

    2. command-line utilities

    3. REST APIs

    4. SSDT

    5. tools

  2. Microsoft Azure Networking

    1. Azure AD Connect

    2. components

    3. connectivity options

    4. data centers

    5. ExpressRoute

    6. hybrid setup

    7. Point-to-Site connections

    8. Site-to-Site connections

    9. Traffic Manager

    10. VPN

      1. Azure DNS

      2. Load Balancer

      3. setup

  3. Microsoft Azure Storage

    1. architecture

      1. DFS

      2. DFS capacity

      3. Front-end layer

      4. Inter-stamp replication

      5. load balance, DFS layer

      6. partition layer

      7. read requests

      8. storage stamp

    2. blobs

      1. AzCopy

      2. block blobs

      3. copy/move blobs

      4. page blobs

    3. GRS

    4. LRS

    5. Premium Storage

      1. account creation

      2. limits

      3. page blobs

      4. uses

    6. querying data

    7. services

      1. blob storage

      2. design decision

      3. file storage

      4. characteristics

      5. Queue storage

      6. Table storage

    8. using tables

    9. ZRS

  4. Microsoft Azure (VMs)

  5. Monitoring performances

    1. Azure Portal

    2. DMV and catalog Views

    3. XEvents

N, O

  1. Network attached storage (NAS)

  2. Networking

    1. ExpressRoute connection

    2. point-to-site VPN

    3. site-to-site VPN

    4. VNet

  3. Network interfaces (NICs)

  4. Network Resource Provider (NRP)

  5. Network Security Groups (NSG)

P

  1. Performance level

    1. Azure management portal

    2. deployments

    3. optimization features

      1. in-memory

      2. query performance insights

      3. SQL database index advisor

    4. PowerShell script

  2. Platform as a Service (PaaS)

Q

  1. Query Performance Insights

    1. details

    2. page settings

    3. queries

  2. Queue storage

R

  1. Random Encryption

  2. Recovery point objective (RPO)

  3. Recovery time objective (RTO)

  4. Role-Based Access Control (RBAC)

  5. Row-Level Security (RLS)

S

  1. Security and auditing

    1. authentication and authorization

    2. dynamic data masking

    3. encryption

      1. column data

      2. connection

      3. deterministic and random

      4. feature

      5. TDE

      6. T-SQL script

    4. features

    5. firewall administration

    6. row-level security

  2. Service tier

SeePerformance level

  1. Software as a Service (SaaS)

  2. Solid State Devices (SSDs)

  3. SQL database

    1. auditing

    2. index advisor

      1. access index

      2. configuration

      3. index recommendations

    3. threat detection

  4. SQL Hybrid

    1. Azure Storage

    2. BackuptoUrl

      1. add container

      2. Azure storage

      3. Database backup

    3. cloud infrastructure

    4. Microsoft Azure Storage

      1. account

      2. blob & container security dialog

      3. blob storage service

      4. creation

      5. database creation

      6. Engineer File IO

      7. native feature

      8. secret key

    5. Smart Backup

    6. snapshot

    7. VMs

      1. Add Azure Replica wizard

      2. Certificate download screen

      3. requirements

      4. setup

  5. SQL Server data tools (SSDT)

  6. SQL Server instance

    1. automation

      1. ARM Virtual Network

      2. Azure Subscription

      3. commands

      4. Get-AzureRmVMSize

      5. Model and Instance View

      6. New-AzureRmAvailabilitySet

      7. resource group creation

    2. Azure CLI

    3. Azure portal

    4. Azure Resource Explorer

    5. configuration

      1. account limits

      2. disk calculation

      3. NSG

      4. server settings

      5. size

      6. storage limits

      7. virtual machine region

    6. post deployment

  7. SQL Server Management Studio (SSMS)

    1. bacpac file

    2. configuration

    3. deployment

      1. database option

      2. summary page

      3. wizard

    4. export data tier application

    5. export execution

  8. SQL Server transactional replication

    1. Azure SQL database

    2. configuration

    3. snapshot relication

  9. Storage area network (SAN)

  10. Storage Resource Provider (SRP)

  11. Stream layer/Distributed File System (DFS)

T, U

  1. Table storage

  2. Total Cost of Ownership (TCO)

  3. Transparent Data Encryption (TDE)

V

  1. Virtual machine (VM) performance

    1. backups

    2. cheat sheet

    3. compute

    4. database page

    5. data disks

      1. log files

      2. operating system disk

      3. PowerShell script

      4. premium IO

      5. source code

      6. standard IO

    6. data files

      1. file-snapshot backup

      2. hosting database files

    7. monitoring

      1. configuration option

      2. dashboard

    8. multi-tenant

    9. network

    10. operational insights

      1. home page

      2. performance issues

      3. SQL assessment

    11. result of

    12. service account privileges

    13. storage

    14. storage spaces

    15. Tempdb

  2. Virtual network (VNet)

W, X, Y

  1. Windows Azure clusters

Z

  1. Zone Redundant Storage (ZRS)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset