Exam Ref DP-900 Microsoft Azure Data Fundamentals

Cover
Title Page
Copyright Page
Contents at a glance
Contents
Introduction
	Organization of this book
	Microsoft certifications
	Errata, updates, and book support
	Stay in touch
Chapter 1 Describe core data concept
	Skill 1.1: Describe ways to represent data
		Describe features of structured data
		Describe features of semi-structured data
		Describe features of unstructured data
	Skill 1.2: Identify options for data storage
		Describe common formats for data files
		Describe types of databases
	Skill 1.3: Describe common data workloads
		Describe features of transactional workloads
		Describe features of analytical workloads
	Skill 1.4: Identify roles and responsibilities for data workloads
		Describe responsibilities for database administrators
		Describe responsibilities for data engineers
		Describe responsibilities for data analysts
	Chapter summary
	Thought experiment
	Thought experiment answers
Chapter 2 Identify considerations for relational data on Azure
	Skill 2.1: Describe relational concepts
		Identify features of relational data
		Describe normalization and how it is used
		Identify common structured query language (SQL) statements
		Identify common database objects
	Skill 2.2: Describe relational Azure data services
		Describe the Azure SQL family of products including Azure SQL Database, Azure SQL, Azure Managed Instance, and SQL Server on Azure Virtual Machines
		Identify Azure database services for open-source database systems
	Chapter summary
	Thought experiment
	Thought experiment answers
	Scenario Exercises
	Exercise 1: Create a Database and Table
	Exercise 2: Explore the Scalability of Azure SQL Database
	Exercise 3: Explore the Security Features of Azure SQL Database
	Exercise 4: Explore Data Recovery in Azure SQL Database
Chapter 3 Describe considerations for working with non-relational data on Azure
	Skill 3.1: Describe capabilities of Azure Storage
		Describe Azure Blob storage
		Describe Azure Data Lake Storage Gen2
		Describe Azure File storage
		Describe Azure Table storage
	Skill 3.2: Describe capabilities and features of Azure Cosmos DB
		Identify use cases for Azure Cosmos DB
		Describe Azure Cosmos DB APIs
	Chapter summary
	Thought experiment
	Thought experiment answers
	Scenario Exercise
	Exercise: Setting Up Azure Services for GHTC’s Telehealth Application
Chapter 4 Describe an analytics workload on Azure
	Skill 4.1 Describe common elements of large-scale analytics
		Describe large-scale data warehousing architecture
		Describe considerations for data ingestion and processing
		Describe options for analytical data stores
		Describe Azure services for data warehousing
	Skill 4.2 Describe consideration for real-time data analytics
		Describe the difference between batch and streaming data
		Identify Microsoft cloud services for real-time analytics
	Skill 4.3 Describe data visualization in Microsoft Power BI
		Identify capabilities of Power BI
		Describe features of data models in Power BI
	Chapter summary
	Thought experiment
	Thought experiment answers
	Scenario Exercises
	Task 1: Large-scale data ingestion and processing
	Task 2: An analytical data store
	Task 3: Real-time analytics
	Task 4: Power BI visualization
	Task 5: Azure data warehousing services
Chapter 5 DP-900 Microsoft Azure Data Fundamentals Exam Updates
	The purpose of this chapter
		About possible exam updates
		Impact on you and your study plan
	News and commentary about the exam objective updates
	Updated technical content
	Objective mapping
Index
	A
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
	Y
	Z