Category: Azure Exams

This is where I post azure study guides

Oct18202118 October 202125 October 20214 Commentsby Gregor Suttie

Azure Exam DP-420: Study Guide Designing and Implementing CloudNative Applications Using Microsoft Azure Cosmos DB (Beta)

The following will be my study guide for the exam along with the following labs:-

https://azurecosmosdb.github.io/labs/

Don’t forget to subscribe to my YouTube Channel.

Design and Implement Data Models (35–40%)

Design and implement a non-relational data model for Azure Cosmos DB Core API

develop a design by storing multiple entity types in the same container
develop a design by storing multiple related entities in the same document
develop a model that denormalizes data across documents
develop a design by referencing between documents
identify primary and unique keys
identify data and associated access patterns
specify a default TTL on a container for a transactional store

Design a data partitioning strategy for Azure Cosmos DB Core API
choose a partition strategy based on a specific workload
choose a partition key
plan for transactions when choosing a partition key
eva luate the cost of using a cross-partition query
calculate and evaluate data distribution based on partition key selection
calculate and evaluate throughput distribution based on partition key selection
construct and implement a synthetic partition key
design partitioning for workloads that require multiple partition keys

Plan and implement sizing and scaling for a database created with Azure Cosmos DB
evaluate the throughput and data storage requirements for a specific workload
choose between serverless and provisioned models
choose when to use database-level provisioned throughput
design for granular scale units and resource governance
evaluate the cost of the global distribution of data
configure throughput for Azure Cosmos DB by using the Azure portal

Implement client connectivity options in the Azure Cosmos DB SDK
choose a connectivity mode (gateway versus direct)
implement a connectivity mode
create a connection to a database
enable offline development by using the Azure Cosmos DB emulator
handle connection errors
implement a singleton for the client
specify a region for global distribution
configure client-side threading and parallelism options
enable SDK logging

Implement data access by using the Azure Cosmos DB SQL language
implement queries that use arrays, nested objects, aggregation, and ordering
implement a correlated subquery
implement queries that use array and type-checking functions
implement queries that use mathematical, string, and date functions
implement queries based on variable data

Implement data access by using SQL API SDKs
choose when to use a point operation versus a query operation
implement a point operation that creates, updates, and deletes documents
implement an update by using a patch operation
manage multi-document transactions using SDK Transactional Batch
perform a multi-document load using SDK Bulk
implement optimistic concurrency control using ETags
implement session consistency by using session tokens
implement a query operation that includes pagination
implement a query operation by using a continuation token
handle transient errors and 429s
specify TTL for a document https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels
retrieve and use query metrics

Implement server-side programming in Azure Cosmos DB Core API by using JavaScript
write, deploy, and call a stored procedure
design stored procedures to work with multiple items transactionally
implement triggers
implement a user-defined function

—

Design and Implement Data Distribution (5–10%)

Design and implement a replication strategy for Azure Cosmos DB
choose when to distribute data
define automatic failover policies for regional failure for Azure Cosmos DB Core API
perform manual failovers to move single master write regions
choose a consistency model
identify use cases for different consistency models
evaluate the impact of consistency model choices on availability and associated RU cost
evaluate the impact of consistency model choices on performance and latency
specify application connections to replicated data

Design and implement multi-region write
choose when to use multi-region write
implement multi-region write
implement a custom conflict resolution policy for Azure Cosmos DB Core API

—

Integrate an Azure Cosmos DB Solution (5–10%)

Enable Azure Cosmos DB analytical workloads
enable Azure Synapse Link
choose between Azure Synapse Link and Spark Connector
enable the analytical store on a container
enable a connection to an analytical store and query from Azure Synapse Spark or Azure
Synapse SQL
perform a query against the transactional store from Spark
write data back to the transactional store from Spark

Implement solutions across services
integrate events with other applications by using Azure Functions and Azure Event Hubs
denormalize data by using Change Feed and Azure Functions
enforce referential integrity by using Change Feed and Azure Functions
aggregate data by using Change Feed and Azure Functions, including reporting
archive data by using Change Feed and Azure Functions
implement Azure Cognitive Search for an Azure Cosmos DB solution

—

Optimize an Azure Cosmos DB Solution (15–20%)

Optimize query performance in Azure Cosmos DB Core API
adjust indexes on the database
calculate the cost of the query
retrieve request unit cost of a point operation or query
implement Azure Cosmos DB integrated cache

Design and implement change feeds for an Azure Cosmos DB Core API
develop an Azure Functions trigger to process a change feed
consume a change feed from within an application by using the SDK
manage the number of change feed instances by using the change feed estimator
implement denormalization by using a change feed
implement referential enforcement by using a change feed
implement aggregation persistence by using a change feed
implement data archiving by using a change feed

Define and implement an indexing strategy for an Azure Cosmos DB Core API
choose when to use a read-heavy versus write-heavy index strategy
choose an appropriate index type
configure a custom indexing policy by using the Azure portal
implement a composite index
optimize index performance

—

Maintain an Azure Cosmos DB Solution (25–30%)

Monitor and troubleshoot an Azure Cosmos DB solution
evaluate response status code and failure metrics
monitor metrics for normalized throughput usage by using Azure Monitor
monitor server-side latency metrics by using Azure Monitor
monitor data replication in relation to latency and availability
configure Azure Monitor alerts for Azure Cosmos DB
implement and query Azure Cosmos DB logs
monitor throughput across partitions
monitor distribution of data across partitions
monitor security by using logging and auditing

Implement backup and restore for an Azure Cosmos DB solution
choose between periodic and continuous backup
configure periodic backup
configure continuous backup and recovery
locate a recovery point for a point-in-time recovery
recover a database or container from a recovery point

Implement security for an Azure Cosmos DB solution
choose between service-managed and customer-managed encryption keys
configure network-level access control for Azure Cosmos DB
configure data encryption for Azure Cosmos DB
manage control plane access to Azure Cosmos DB by using Azure role-based access
control (RBAC)
manage data plane access to Azure Cosmos DB by using keys
manage data plane access to Azure Cosmos DB by using Azure Active Directory
configure Cross-Origin Resource Sharing (CORS) settings
manage account keys by using Azure Key Vault
implement customer-managed keys for encryption
implement Always Encrypted

Implement data movement for an Azure Cosmos DB solution
choose a data movement strategy
move data by using client SDK bulk operations
move data by using Azure Data Factory and Azure Synapse pipelines
move data by using a Kafka connector
move data by using Azure Stream Analytics
move data by using the Azure Cosmos DB Spark Connector

Implement a DevOps process for an Azure Cosmos DB solution
choose when to use declarative versus imperative operations
provision and manage Azure Cosmos DB resources by using Azure Resource Manager
templates (ARM templates)
migrate between standard and autoscale throughput by using PowerShell or Azure CLI
initiate a regional failover by using PowerShell or Azure CLI
maintain index policies in production by using ARM templates

Remember a lot of this content is covered in the following GitHub labs:-

https://azurecosmosdb.github.io/labs/

Enjoy!

Don’t forget to subscribe to my YouTube Channel.

Tags:CosmosDB

May13202113 May 202124 May 20214 Commentsby Gregor Suttie

AI-102 Azure Study Guide

Posted in Azure, Azure Exams

In this blog post I cover all of the resources I came across whilst studying for the AZ-102 Exam

AI-102: AI Engineer on GitHub: – https://github.com/MicrosoftLearning/AI-102-AIEngineerhttps://github.com/MicrosoftLearning/AI-102-AIEngineer

And this too:-

https://microsoftlearning.github.io/AI-102-AIEngineer/

Plan and Manage an Azure Cognitive Services Solution (15-20%)
Select the appropriate Cognitive Services resource

select the appropriate cognitive service for a vision solution
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/overview
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/overview
select the appropriate cognitive service for a language analysis solution
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/what-is-luis
select the appropriate cognitive Service for a decision support solution
https://docs.microsoft.com/en-us/azure/cognitive-services/what-are-cognitive-services#decision-apis
select the appropriate cognitive service for a speech solution
https://docs.microsoft.com/en-us/azure/cognitive-services/what-are-cognitive-services#speech-apis

Plan and configure security for a Cognitive Services solution
manage Cognitive Services account keys
https://docs.microsoft.com/en-us/azure/cognitive-services/cognitive-services-apis-create-account?tabs=multiservice%2Cwindows#get-the-keys-for-your-resource
manage authentication for a resource
https://docs.microsoft.com/en-us/azure/cognitive-services/authentication?tabs=powershell
secure Cognitive Services by using Azure Virtual Network
https://docs.microsoft.com/en-us/azure/cognitive-services/cognitive-services-virtual-networks?tabs=portal
plan for a solution that meets responsible AI principles
https://www.microsoft.com/en-us/ai/responsible-ai-resources?activetab=pivot1%3aprimaryr4

Create a Cognitive Services resource
create a Cognitive Services resource
https://docs.microsoft.com/en-us/azure/cognitive-services/cognitive-services-apis-create-account?tabs=multiservice%2Cwindows
configure diagnostic logging for a Cognitive Services resource
https://docs.microsoft.com/en-us/azure/cognitive-services/diagnostic-logging
manage Cognitive Services costs
https://docs.microsoft.com/en-us/azure/cognitive-services/plan-manage-costs
monitor a cognitive service
https://docs.microsoft.com/en-us/azure/search/search-monitor-usage
implement a privacy policy in Cognitive Services
https://docs.microsoft.com/en-us/legal/cognitive-services/computer-vision/compliance-privacy-security-2

Plan and implement Cognitive Services containers
identify when to deploy to a container
https://docs.microsoft.com/en-us/azure/cognitive-services/cognitive-services-container-support
containerize Cognitive Services (including Computer Vision API, Face API, Text Analytics,
Speech, Form Recognizer)
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/speech-container-howto?tabs=stt%2Ccsharp%2Csimple-format

Implement Computer Vision Solutions (20-25%)

Analyze images by using the Computer Vision API
retrieve image descriptions and tags by using the Computer Vision API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/concept-tagging-images
identify landmarks and celebrities by using the Computer Vision API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/concept-detecting-domain-content
detect brands in images by using the Computer Vision API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/concept-brand-detection
moderate content in images by using the Computer Vision API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/concept-detecting-adult-content
generate thumbnails by using the Computer Vision API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/concept-generating-thumbnails

Extract text from images
extract text from images by using the OCR API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/overview-ocr
extract text from images or PDFs by using the Read API
https://docs.microsoft.com/en-us/azure/cognitive-services/computer-vision/overview-ocr#read-api
convert handwritten text by using Ink Recognizer
https://docs.microsoft.com/en-us/previous-versions/azure/cognitive-services/Ink-Recognizer/quickstarts/csharp
extract information from forms or receipts by using the pre-built receipt model in Form
Recognizer
https://docs.microsoft.com/en-us/azure/cognitive-services/form-recognizer/concept-receipts
build and optimize a custom model for Form Recognizer
https://docs.microsoft.com/en-us/azure/cognitive-services/form-recognizer/build-training-data-set

Extract facial information from images
detect faces in an image by using the Face API
https://docs.microsoft.com/en-us/azure/cognitive-services/face/face-api-how-to-topics/howtodetectfacesinimage
recognize faces in an image by using the Face API
https://docs.microsoft.com/en-us/azure/cognitive-services/face/quickstarts/client-libraries?tabs=visual-studio&pivots=programming-language-csharp
o configure persons and person groups
https://docs.microsoft.com/en-us/rest/api/cognitiveservices/face/persongroupperson/create
analyze facial attributes by using the Face API
https://docs.microsoft.com/en-in/learn/modules/detect-analyze-faces/2-face-analysis-azure
match similar faces by using the Face API
https://docs.microsoft.com/en-us/rest/api/faceapi/face/findsimilar

Implement image classification by using the Custom Vision service
label images by using the Computer Vision Portal
https://docs.microsoft.com/en-in/azure/cognitive-services/custom-vision-service/suggested-tags
train a custom image classification model in the Custom Vision Portal
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/getting-started-build-a-classifier
train a custom image classification model by using the SDK
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/quickstarts/image-classification?tabs=visual-studio&pivots=programming-language-csharp
manage model iterations
https://docs.microsoft.com/en-in/azure/cognitive-services/custom-vision-service/getting-started-build-a-classifier#manage-training-iterations
evaluate classification model metrics
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/getting-started-build-a-classifier#evaluate-the-classifier
publish a trained iteration of a model
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/use-prediction-api#publish-your-trained-iteration
export a model in an appropriate format for a specific target
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/export-your-model
consume a classification model from a client application
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-consume-web-service?tabs=python
deploy image classification custom models to containers
https://docs.microsoft.com/en-us/azure/iot-edge/tutorial-deploy-custom-vision?view=iotedge-2018-06

Implement an object detection solution by using the Custom Vision service
label images with bounding boxes by using the Computer Vision Portal
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-label-data#tag-images-and-specify-bounding-boxes-for-object-detection
train a custom object detection model by using the Custom Vision Portal
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/get-started-build-detector
train a custom object detection model by using the SDK
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/quickstarts/object-detection?tabs=visual-studio&pivots=programming-language-csharp
manage model iterations
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/get-started-build-detector#manage-training-iterations
evaluate object detection model metrics
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/get-started-build-detector#evaluate-the-detector
publish a trained iteration of a model
https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/quickstarts/object-detection?tabs=visual-studio&pivots=programming-language-csharp#publish-the-current-iteration
consume an object detection model from a client application
https://docs.microsoft.com/en-us/ai-builder/object-detection-model-in-flow
deploy custom object detection models to containers
https://docs.microsoft.com/en-us/azure/cognitive-services/cognitive-services-container-support

Analyze video by using Video Indexer
process a video
https://docs.microsoft.com/en-us/azure/media-services/video-indexer/upload-index-videos
extract insights from a video
https://docs.microsoft.com/en-us/learn/modules/extract-insights-from-videos-with-video-indexer-service/
moderate content in a video
https://azure.microsoft.com/en-gb/services/cognitive-services/content-moderator
customize the Brands model used by Video Indexer
https://docs.microsoft.com/en-us/azure/media-services/video-indexer/customize-brands-model-with-website
customize the Language model used by Video Indexer by using the Custom Speech
service
https://docs.microsoft.com/en-us/azure/media-services/video-indexer/customize-language-model-with-website
customize the Person model used by Video Indexer
https://docs.microsoft.com/en-us/azure/media-services/video-indexer/customize-person-model-with-website
extract insights from a live stream of video data
https://www.youtube.com/wa t ch?v=wAHRBpqxpOg

Implement Natural Language Processing Solutions (20-25%)

Analyze text by using the Text Analytics service
retrieve and process key phrases
https://docs.microsoft.com/en-in/azure/cognitive-services/text-analytics/how-tos/text-analytics-how-to-keyword-extraction
retrieve and process entity information (people, places, urls, etc.)
https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/how-tos/text-analytics-how-to-entity-linking?tabs=version-3-preview
retrieve and process sentiment
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-sentiment-analysis-cognitive-services?toc=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fcognitive-services%2Ftext-analytics%2Ftoc.json&bc=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fbread%2Ftoc.json
detect the language used in text
https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/how-tos/text-analytics-how-to-language-detection

Manage speech by using the Speech service
implement text-to-speech
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/text-to-speech
customize text-to-speech
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/how-to-custom-voice
implement speech-to-text
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/get-started-speech-to-text?tabs=windowsinstall&pivots=programming-language-csharp
improve speech-to-text accuracy
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/tutorial-tenant-model

Translate language
translate text by using the Translator service
https://docs.microsoft.com/en-us/azure/cognitive-services/translator/translator-info-overview
translate speech-to-speech by using the Speech service
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/get-started-speech-translation?tabs=script%2Cwindowsinstall&pivots=programming-language-csharp
translate speech-to-text by using the Speech service
https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/get-started-speech-to-text?tabs=windowsinstall&pivots=programming-language-csharp

Build an initial language model by using Language Understanding Service (LUIS)
create intents and entities based on a schema, and then add utterances
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-add-intents
create complex hierarchical entities
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-concept-entity-types
o use this instead of roles
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-collaborate
train and deploy a model
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-train

Iterate on and optimize a language model by using LUIS
implement phrase lists
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-concept-feature#create-a-phrase-list-for-a-concept
implement a model as a feature (i.e. prebuilt entities)
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-add-features#model-as-a-feature
manage punctuation and diacritics
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-reference-application-settings#punctuation-normalization
implement active learning
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-concept-review-endpoint-utterances
monitor and correct data imbalances
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-use-dashboard#review-data-imbalance
implement patterns
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-tutorial-pattern

Manage a LUIS model
manage collaborators
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-collaborate
manage versioning
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-manage-versions
publish a model through the portal or in a container
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-how-to-publish-app
export a LUIS package
https://docs.microsoft.com/en-us/azure/cognitive-services/luis/luis-container-howto?tabs=v3#export-packaged-app-from-luis
deploy a LUIS package to a container
https://docs.microsoft.com/en-us/azure/cognitive-services/containers/azure-container-instance-recipe?tabs=portal
integrate Bot Framework (LUDown) to run outside of the LUIS portal
https://github.com/Microsoft/botbuilder-tools/tree/master/packages/Ludown#ludown

Implement Knowledge Mining Solutions (15-20%)
Implement a Cognitive Search solution
create data sources
https://docs.microsoft.com/en-us/rest/api/searchservice/create-data-source
define an index
https://docs.microsoft.com/en-us/azure/search/search-what-is-an-index
create and run an indexer
https://docs.microsoft.com/en-us/azure/search/search-howto-create-indexers#run-the-indexer
query an index
https://docs.microsoft.com/en-us/azure/search/search-query-overview
configure an index to support autocomplete and autosuggest
https://docs.microsoft.com/en-us/azure/search/search-add-autocomplete-suggestions
boost results based on relevance
https://docs.microsoft.com/en-us/azure/search/index-add-scoring-profiles
implement synonyms
https://docs.microsoft.com/en-us/azure/search/search-synonyms

Implement an enrichment pipeline
attach a Cognitive Services account to a skillset
https://docs.microsoft.com/en-us/azure/search/cognitive-search-attach-cognitive-services
select and include built-in skills for documents
https://docs.microsoft.com/en-us/azure/search/cognitive-search-predefined-skills
implement custom skills and include them in a skillset
https://docs.microsoft.com/en-us/azure/search/cognitive-search-custom-skill-interface

Implement a knowledge store
define file projections
https://docs.microsoft.com/en-us/azure/search/knowledge-store-projections-examples#projecting-to-file
define object projections
https://docs.microsoft.com/en-us/azure/search/knowledge-store-projections-examples#projecting-to-objects
define table projections
https://docs.microsoft.com/en-us/azure/search/knowledge-store-projections-examples#projecting-to-tables
query projections
https://docs.microsoft.com/en-us/azure/search/knowledge-store-projection-overview

Manage a Cognitive Search solution
provision Cognitive Search
https://docs.microsoft.com/en-us/azure/search/search-create-service-portal
configure security for Cognitive Search
https://docs.microsoft.com/en-us/azure/search/search-security-overview
configure scalability for Cognitive Search
https://docs.microsoft.com/en-us/azure/search/search-performance-optimization

Manage indexing
manage re-indexing
https://docs.microsoft.com/en-us/rest/api/searchservice/update-index
rebuild indexes
https://docs.microsoft.com/en-us/azure/search/search-howto-reindex
schedule indexing
https://docs.microsoft.com/en-us/azure/search/search-howto-schedule-indexers
monitor indexing
https://docs.microsoft.com/en-us/azure/search/search-howto-monitor-indexers
implement incremental indexing
https://docs.microsoft.com/en-us/azure/search/cognitive-search-incremental-indexing-conceptual
manage concurrency
https://docs.microsoft.com/en-us/azure/search/search-howto-concurrency
push data to an index
https://docs.microsoft.com/en-us/azure/search/search-what-is-data-import#pushing-data-to-an-index
troubleshoot indexing for a pipeline
https://docs.microsoft.com/en-us/azure/search/search-indexer-troubleshooting

Implement Conversational AI Solutions (15-20%)
Create a knowledge base by using QnA Maker
create a QnA Maker service
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/how-to/set-up-qnamaker-service-azure?tabs=v1#create-a-new-qna-maker-service
create a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/quickstarts/create-publish-knowledge-base?tabs=v1
import a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/tutorials/migrate-knowledge-base#migrate-a-knowledge-base-from-qna-maker
train and test a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/quickstarts/create-publish-knowledge-base?tabs=v1#save-and-train
publish a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/quickstarts/create-publish-knowledge-base?tabs=v1#publish-the-knowledge-base
create a multi-turn conversation
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/how-to/multiturn-conversation
add alternate phrasing
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/how-to/edit-knowledge-base#add-alternate-questions
add chit-chat to a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/how-to/chit-chat-knowledge-base?tabs=v1
export a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/tutorials/migrate-knowledge-base
add active learning to a knowledge base
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/how-to/use-active-learning?tabs=v1
manage collaborators
https://docs.microsoft.com/en-us/azure/cognitive-services/qnamaker/concepts/role-based-access-control

Design and implement conversation flow
design conversation logic for a bot
https://docs.microsoft.com/en-us/azure/bot-service/bot-service-design-conversation-flow?view=azure-bot-service-4.0
create and evaluate *.chat file conversations by using the Bot Framework Emulator
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-debug-transcript?view=azure-bot-service-4.0
add language generation for a response
https://docs.microsoft.com/en-us/composer/concept-language-generation
design and implement adaptive cards
https://docs.microsoft.com/en-us/adaptive-cards/sdk/designer

Create a bot by using the Bot Framework SDK
implement dialogs
https://docs.microsoft.com/en-us/azure/bot-service/skill-actions-in-dialogs?view=azure-bot-service-4.0&tabs=cs
maintain state
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-concept-state?view=azure-bot-service-4.0
implement logging for a bot conversation
https://docs.microsoft.com/en-us/azure/bot-service/using-trace-activities?view=azure-bot-service-4.0&tabs=csharp
implement a prompt for user input
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-primitive-prompts?view=azure-bot-service-4.0&tabs=csharp
add and review bot telemetry
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-telemetry?view=azure-bot-service-4.0&tabs=csharp
implement a bot-to-human handoff
https://docs.microsoft.com/en-us/azure/bot-service/bot-service-design-pattern-handoff-human?view=azure-bot-service-4.0
troubleshoot a conversational bot
https://docs.microsoft.com/en-us/azure/bot-service/bot-service-troubleshoot-general-problems?view=azure-bot-service-4.0
add a custom middleware for processing user messages
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-concept-middleware?view=azure-bot-service-4.0
manage identity and authentication
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-authentication?view=azure-bot-service-4.0&tabs=aadv2%2Ccsharp
implement channel-specific logic
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-channeldata?view=azure-bot-service-4.0
publish a bot
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-tutorial-deploy-basic-bot?view=azure-bot-service-4.0&tabs=csharp

Create a bot by using the Bot Framework Composer
implement dialogs
https://docs.microsoft.com/en-us/composer/concept-dialog
maintain state
https://docs.microsoft.com/en-us/composer/concept-memory
implement logging for a bot conversation
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-telemetry?view=azure-bot-service-4.0&tabs=csharp
implement prompts for user input
https://docs.microsoft.com/en-us/composer/how-to-ask-for-user-input
troubleshoot a conversational bot
https://docs.microsoft.com/en-us/azure/bot-service/bot-service-troubleshoot-bot-configuration?view=azure-bot-service-4.0
test a bot by using the Bot Framework Emulator
https://docs.microsoft.com/en-us/azure/bot-service/bot-service-debug-emulator?view=azure-bot-service-4.0&tabs=csharp
publish a bot
https://docs.microsoft.com/en-us/composer/how-to-publish-bot

Integrate Cognitive Services into a bot
integrate a QnA Maker service
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-howto-qna?view=azure-bot-service-4.0&tabs=cs
integrate a LUIS service
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-howto-v4-luis?view=azure-bot-service-4.0&tabs=csharp
integrate a Speech service
https://docs.microsoft.com/en-us/azure/bot-service/rest-api/bot-framework-rest-connector-text-to-speech?view=azure-bot-service-4.0
integrate Dispatch for multiple language models
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-tutorial-dispatch?view=azure-bot-service-4.0&tabs=cs
manage keys in app settings file
https://docs.microsoft.com/en-us/azure/bot-service/bot-builder-howto-v4-luis?view=azure-bot-service-4.0&tabs=csharp#update-the-settings-file

Mar0620216 March 202124 May 20210 Commentby Gregor Suttie

Azure DP-300 Exam Study guide

Posted in Azure, Azure Exams, SQL Server

Plan and Implement Data Platform Resources (15-20%)
Deploy resources by using manual methods

Deploy database offerings on selected platforms
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-get-started?tabs=azure-portal&?WT.mc_id=AZ-MVP-5003451
configure customized deployment templates
https://docs.microsoft.com/en-us/azure/templates/microsoft.sql/servers?tabs=json&?WT.mc_id=AZ-MVP-5003451
apply patches and updates for hybrid and IaaS deployment
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-get-started?tabs=azure-portal&WT.mc_id=AZ-MVP-5003451

Recommend an appropriate database offering based on specific requirements
evaluate requirements for the deployment
https://docs.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml&WT.mc_id=AZ-MVP-5003451
evaluate the functional benefits/impact of possible database offerings
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas?WT.mc_id=AZ-MVP-5003451
evaluate the scalability of the possible database offering
https://techcommunity.microsoft.com/t5/azure-sql-database/azure-sql-database-8211-scalability/ba-p/386201?WT.mc_id=AZ-MVP-5003451
evaluate the HA/DR of the possible database offering
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr?WT.mc_id=AZ-MVP-5003451
evaluate the security aspects of the possible database offering
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview?WT.mc_id=AZ-MVP-5003451

Configure resources for scale and performance
configure Azure SQL database/elastic pools for scale and performance
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-scale-introduction
configure Azure SQL managed instances for scale and performance
https://docs.microsoft.com/en-us/azure/azure-sql/database/scale-resources?WT.mc_id=AZ-MVP-5003451
configure SQL Server in Azure VMs for scale and performance
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance?WT.mc_id=AZ-MVP-5003451
calculate resource requirements
https://docs.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration?WT.mc_id=AZ-MVP-5003451
evaluate database partitioning techniques, such as database sharding
https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding?WT.mc_id=AZ-MVP-5003451
set up SQL Data Sync
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?WT.mc_id=AZ-MVP-5003451

Evaluate a strategy for moving to Azure
evaluate requirements for the migration
https://docs.microsoft.com/en-us/azure/dms/pre-reqs?WT.mc_id=AZ-MVP-5003451
evaluate offline or online migration strategies
https://azure.microsoft.com/en-gb/services/database-migration/?WT.mc_id=AZ-MVP-5003451
evaluate requirements for the upgrade
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15#pre-upgrade-checklist&WT.mc_id=AZ-MVP-5003451
evaluate offline or online upgrade strategies
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade?WT.mc_id=AZ-MVP-5003451

Implement a migration or upgrade strategy for moving to Azure
implement an online migration strategy
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online?WT.mc_id=AZ-MVP-5003451
implement an offline migration strategy
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql?WT.mc_id=AZ-MVP-5003451
implement an online upgrade strategy
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade?WT.mc_id=AZ-MVP-5003451
implement an offline upgrade strategy
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15?WT.mc_id=AZ-MVP-5003451

Implement a Secure Environment (15-20%)

Configure database authentication by using platform and database tools
configure Azure AD authentication
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?tabs=azure-powershell?WT.mc_id=AZ-MVP-5003451
create users from Azure AD identities
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell#create-contained-users-mapped-to-azure-ad-identities&WT.mc_id=AZ-MVP-5003451
configure security principals
https://techcommunity.microsoft.com/t5/azure-sql-database/azure-ad-service-principal-authentication-to-sql-db-code-sample/ba-p/481467?WT.mc_id=AZ-MVP-5003451

Configure database authorization by using platform and database tools
configure database and object-level permissions using graphical tools
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
apply principle of least privilege for all securables
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authorization-and-permissions-in-sql-server?WT.mc_id=AZ-MVP-5003451

Implement security for data at rest
implement Transparent Data Encryption (TDE)
https://docs.microsoft.com/en-us/azure/sql-database/transparent-data-encryption-azure-sql?tabs=azure-portal&WT.mc_id=AZ-MVP-5003451
implement object-level encryption
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted-azure-key-vault?tabs=azure-powershell&WT.mc_id=AZ-MVP-5003451
implement Dynamic Data Masking
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dynamic-data-masking-get-started-portal?WT.mc_id=AZ-MVP-5003451
implement Azure Key Vault and disk encryption for Azure VMs
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disk-encryption-portal-quickstart?WT.mc_id=AZ-MVP-5003451

Implement security for data in transit
configure server and database-level firewall rules
https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure#server-level-versus-database-level-ip-firewall-rules?WT.mc_id=AZ-MVP-5003451
implement Always Encrypted
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted?WT.mc_id=AZ-MVP-5003451

Implement compliance controls for sensitive data
apply a data classification strategy
https://docs.microsoft.com/bs-latn-ba/azure/cloud-adoption-framework/govern/policy-compliance/data-classification?WT.mc_id=AZ-MVP-5003451
configure server and database audits
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing?WT.mc_id=AZ-MVP-5003451
implement data change tracking
https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-tracking-sql-server?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform a vulnerability assessment
https://docs.microsoft.com/en-us/azure/sql-database/sql-vulnerability-assessment?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Monitor and Optimize Operational Resources (15-20%)

Monitor activity and performance
prepare an operational performance baseline
https://docs.microsoft.com/en-us/sql/relational-databases/performance/establish-a-performance-baseline?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
determine sources for performance metrics
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/data-sources?WT.mc_id=AZ-MVP-5003451
interpret performance metrics
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-query-performance?WT.mc_id=AZ-MVP-5003451
assess database performance by using Intelligent Insights for Azure SQL Database and
Managed Instance
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-intelligent-insights?WT.mc_id=AZ-MVP-5003451
configure and monitor activity and performance at the infrastructure, server, service, and
database levels
https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?WT.mc_id=AZ-MVP-5003451

Implement performance-related maintenance tasks
implement index maintenance tasks
https://docs.microsoft.com/answers/questions/129461/automating-azure-sql-database-index-maintenance.html?WT.mc_id=AZ-MVP-5003451
implement statistics maintenance tasks
https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/update-statistics-task-maintenance-plan?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
configure database auto-tuning
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable?WT.mc_id=AZ-MVP-5003451
automate database maintenance tasks
https://docs.microsoft.com/en-us/azure/azure-sql/database/automation-manage?WT.mc_id=AZ-MVP-5003451
manage storage capacity
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management?WT.mc_id=AZ-MVP-5003451

Identify performance-related issues
configure Query Store to collect performance data
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-query-performance?WT.mc_id=AZ-MVP-5003451
identify sessions that cause blocking
https://azure.microsoft.com/en-in/blog/finding-blocking-queries-in-sql-azure?WT.mc_id=AZ-MVP-5003451
assess growth/fragmentation of databases and logs
https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?WT.mc_id=AZ-MVP-5003451
assess performance-related database configuration parameters
https://docs.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?WT.mc_id=AZ-MVP-5003451

Configure resources for optimal performance
configure storage and infrastructure resources
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-storage-configuration?WT.mc_id=AZ-MVP-5003451
configure server and service account settings for performance
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?WT.mc_id=AZ-MVP-5003451
configure Resource Governor for performance
https://azure.microsoft.com/en-in/blog/resource-governance-in-azure –sql-database/?WT.mc_id=AZ-MVP-5003451

Configure a user database for optimal performance
implement database-scoped configuration
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver15
configure compute resources for scaling
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview?WT.mc_id=AZ-MVP-5003451
configure Intelligent Query Processing (IQP)
https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Optimize Query Performance (5-10%)

Review query plans
determine the appropriate type of execution plan
https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-ver15?WT.mc_id=AZ-MVP-5003451
identify problem areas in execution plans
https://docs.microsoft.com/en-us/sql/relational-databases/performance/analyze-an-actual-execution-plan?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
extract query plans from the Query Store
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Evaluate performance improvements
determine the appropriate Dynamic Management Views (DMVs) to gather query
performance information
https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#monitoring-query-performance?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
identify performance issues using DMVs
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs?WT.mc_id=AZ-MVP-5003451
identify and implement index changes for queries
https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
recommend query construct modifications based on resource usage
https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
assess the use of hints for query performance
https://docs.microsoft.com/en-us/azure/azure-sql/database/performance-guidance#query-tuning-and-hinting?WT.mc_id=AZ-MVP-5003451

Review database table and index design
identify data quality issues with duplication of data
https://docs.microsoft.com/en-us/sql/data-quality-services/data-matching?view=sql-server-ver15?WT.mc_id=AZ-MVP-5003451
identify normal form of database tables
https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description?WT.mc_id=AZ-MVP-5003451
assess index design for performance
https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
validate data types defined for columns
https://docs.microsoft.com/en-us/t-sql/data-types/data-types-transact-sql?WT.mc_id=AZ-MVP-5003451
recommend table and index storage including filegroups
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15#Recommendations&WT.mc_id=AZ-MVP-5003451
evaluate table partitioning strategy
https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning?WT.mc_id=AZ-MVP-5003451
evaluate the use of compression for tables and indexes
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-estimate-data-compression-savings-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Perform Automation of Tasks (10-15%)

Create scheduled tasks
manage schedules for regular maintenance jobs
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview?WT.mc_id=AZ-MVP-5003451
configure multi-server automation
https://docs.microsoft.com/en-us/sql/ssms/agent/automated-administration-across-an-enterprise?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
configure notifications for task success/failure/non-completion
https://docs.microsoft.com/en-us/sql/ssms/agent/notify-an-operator-of-job-status?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Evaluate and implement an alert and notification strategy
create event notifications based on metrics
https://docs.microsoft.com/en-us/azure/mysql/howto-alert-on-metric?WT.mc_id=AZ-MVP-5003451
create event notifications for Azure resources
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
create alerts for server configuration changes
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?WT.mc_id=AZ-MVP-5003451
create tasks that respond to event notifications
https://docs.microsoft.com/en-us/azure/azure-monitor/learn/tutorial-response?WT.mc_id=AZ-MVP-5003451

Manage and automate tasks in Azure
perform automated deployment methods for resources
https://docs.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml&WT.mc_id=AZ-MVP-5003451
automate backups
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups?tabs=single-database&WT.mc_id=AZ-MVP-5003451
automate performance tuning and patching
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-automated-patching?WT.mc_id=AZ-MVP-5003451
implement policies by using automated evaluation modes
https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Plan and Implement a High Availability and Disaster Recovery (HADR)
Environment (15-20%)

Recommend an HADR strategy for a data platform solution
recommend HADR strategy based on RPO/RTO requirements
https://azure.microsoft.com/en-in/blog/understanding-and-leveraging-azure-sql-database-sla?&WT.mc_id=AZ-MVP-5003451
evaluate HADR for hybrid deployments
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr#hybrid-it-disaster-recovery-solutions?&WT.mc_id=AZ-MVP-5003451
evaluate Azure-specific HADR solutions
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr#azure-only-disaster-recovery-solutions?&WT.mc_id=AZ-MVP-5003451
identify resources for HADR solutions
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/business-continuity-high-availability-disaster-recovery-hadr-overview?&WT.mc_id=AZ-MVP-5003451

Test an HADR strategy by using platform, OS, and database tools
test HA by using failover
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-configure-failover-group?tabs=azure-portal&WT.mc_id=AZ-MVP-5003451
test DR by using failover or restore
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-disaster-recovery?WT.mc_id=AZ-MVP-5003451

Perform backup and restore a database by using database tools
perform a database backup with options
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-database-backup-options-page?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform a database restore with options
https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform a database restore to a point in time
https://azure.microsoft.com/en-in/blog/azure-sql-database-point-in-time-restore?WT.mc_id=AZ-MVP-5003451
configure long-term backup retention
https://docs.microsoft.com/bs-cyrl-ba/azure/sql-database/sql-database-long-term-backup-retention-configure?WT.mc_id=AZ-MVP-5003451

Configure HA/DR by using OS, platform, and database tools
configure replication
https://docs.microsoft.com/en-us/azure/sql-database/replication-to-sql-database?WT.mc_id=AZ-MVP-5003451
create an Availability Group
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-tutorial?WT.mc_id=AZ-MVP-5003451
configure auto-failover groups
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell&WT.mc_id=AZ-MVP-5003451
integrate a database into an Availability Group
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-group-add-a-database?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
configure quorum options for a Windows Server Failover Cluster
https://docs.microsoft.com/en-us/windows-server/failover-clustering/manage-cluster-quorum?WT.mc_id=AZ-MVP-5003451
configure an Availability Group listener
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Perform Administration by Using T-SQL (10-15%)

Examine system health
evaluate database health using DMVs
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs?WT.mc_id=AZ-MVP-5003451
evaluate server health using DMVs
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views?view=sql-server-ver15?WT.mc_id=AZ-MVP-5003451
perform database consistency checks by using DBCC
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Monitor database configuration by using T-SQL
assess proper database autogrowth configuration
https://docs.microsoft.com/en-us/troubleshoot/sql/admin/considerations-autogrow-autoshrink?WT.mc_id=AZ-MVP-5003451
report on database free space
https://docs.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
review database configuration options
https://docs.microsoft.com/en-us/sql/relational-databases/databases/change-the-configuration-settings-for-a-database?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Perform backup and restore a database by using T-SQL
prepare databases for Always On Availability Groups
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform transaction log backup
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform restore of user databases
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
perform database backups with options
https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver15#Additional_Considerations?WT.mc_id=AZ-MVP-5003451

Manage authentication by using T-SQL
manage certificates
https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-server-certificates-and-asymmetric-keys?WT.mc_id=AZ-MVP-5003451
manage security principals
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-aad-security-tutorial?WT.mc_id=AZ-MVP-5003451

Manage authorization by using T-SQL
configure permissions for users to access database objects
https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451
configure permissions by using custom roles
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-role-transact-sql?view=sql-server-ver15&WT.mc_id=AZ-MVP-5003451

Aug0620206 August 202024 May 20210 Commentby Gregor Suttie

DP-900 Azure Data Fundamentals

Posted in Azure, Azure Exams

Happy to share that I sat the Beta for this exam and passed – here is a link to my study guide https://gregorsuttie.com/2020/06/09/dp-900-microsoft-azure-data-fundamentals-exam-study-guide/

Another exam done, and the data side of Azure is something I would love to explore further if I ever get the chance.

Don’t forget to subscribe to my YouTube Channel.

Tags:Azure DP-900

Category: Azure Exams

Azure Exam DP-420: Study Guide Designing and Implementing CloudNative Applications Using Microsoft Azure Cosmos DB (Beta)

AI-102 Azure Study Guide

Azure DP-300 Exam Study guide

DP-900 Azure Data Fundamentals

Categories

Certifications and Awards

About Me

Recent Posts

Follow Me