Home Page Icon
Home Page
Table of Contents for
MC Microsoft Certified Azure Data Fundamentals Study Guide
Close
MC Microsoft Certified Azure Data Fundamentals Study Guide
by Jake Switzer
MC Microsoft Certified Azure Data Fundamentals Study Guide
Cover
Title Page
Copyright
Acknowledgments
About the Author
About the Technical Editor
Introduction
Chapter 1: Core Data Concepts
Chapter 2: Relational Databases in Azure
Chapter 3: Nonrelational Databases in Azure
Chapter 4: File, Object, and Data Lake Storage
Chapter 5: Modern Data Warehouses in Azure
Chapter 6: Reporting with Power BI
Appendix: Answers to the Review Questions
Index
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Title Page
Table of Contents
Cover
Title Page
Copyright
Acknowledgments
About the Author
About the Technical Editor
Introduction
Who Should Read This Book?
Interactive Online Learning Environment and Test Bank
DP-900 Exam Objectives
Domain 1: Describe Core Data Components
Domain 2: Describe How to Work with Relational Data on Azure
Domain 3: Describe How to Work with Nonrelational Data on Azure
Domain 4: Describe an Analytics Workload on Azure
Assessment Test
Answers to the Assessment Test
Chapter 1: Core Data Concepts
Describe Types of Core Data Workloads
Describe Data Analytics Core Concepts
Summary
Exam Essentials
Review Questions
Chapter 2: Relational Databases in Azure
Relational Database Features
Relational Database Offerings in Azure
Management Tasks for Relational Databases in Azure
Query Techniques for SQL
Summary
Exam Essentials
Review Questions
Chapter 3: Nonrelational Databases in Azure
Nonrelational Database Features
Azure Cosmos DB
Management Tasks for Azure Cosmos DB
Summary
Exam Essentials
Review Questions
Chapter 4: File, Object, and Data Lake Storage
File and Object Storage Features
Azure Storage
Management Tasks for Azure Storage
Summary
Exam Essentials
Review Questions
Chapter 5: Modern Data Warehouses in Azure
Analytical Workload Features
Modern Data Warehouse Components
End-to-End Analytics with Azure Synapse Analytics
Summary
Exam Essentials
Review Questions
Chapter 6: Reporting with Power BI
Power BI at a Glance
Summary
Exam Essentials
Review Questions
Appendix: Answers to the Review Questions
Chapter 1: Core Data Concepts
Chapter 2: Relational Databases in Azure
Chapter 3: Nonrelational Databases in Azure
Chapter 4: File, Object, and Data Lake Storage
Chapter 5: Modern Data Warehouses in Azure
Chapter 6: Reporting with Power BI
Index
End User License Agreement
List of Tables
Chapter 2
TABLE 2.1 Available Pay-As-You-Go SQL Server images
TABLE 2.2 Available bring your own license SQL Server images
TABLE 2.3 Azure SQL MI service tier characteristics
TABLE 2.4 DTU-based purchasing model service tier characteristics
TABLE 2.5 vCore-based purchasing model service tier characteristics
TABLE 2.6 Dedicated SQL pool service level objectives
TABLE 2.7 Azure Database for MySQL service tier resource options
TABLE 2.8 Common sqlcmd switches
TABLE 2.9 DDL commands
TABLE 2.10 Common SQL data types
TABLE 2.11 Common SQL constraints
TABLE 2.12 DML commands
Chapter 3
TABLE 3.1 Azure Cosmos DB API-specific names for containers
TABLE 3.2 Azure Cosmos DB API-specific names for items
TABLE 3.3 Azure Table storage vs. Azure Cosmos DB Table API
Chapter 4
TABLE 4.1 Storage service URL endpoint patterns
TABLE 4.2 Storage account redundancy options
TABLE 4.3 Blob and Directory ACL Permissions
TABLE 4.4 Supported AzCopy authorization methods
Chapter 5
TABLE 5.1 Standard and premium tier DBU prices
List of Illustrations
Chapter 1
FIGURE 1.1 Key-value store
FIGURE 1.2 Document database
FIGURE 1.3 Columnar database
FIGURE 1.4 Graph database
FIGURE 1.5 Structured data
FIGURE 1.6 JSON example
FIGURE 1.7 Common architecture for batch processing in Azure
FIGURE 1.8 Live stream processing
FIGURE 1.9 On-demand stream processing
FIGURE 1.10 Lambda architecture
FIGURE 1.11 ETL workflow
FIGURE 1.12 ADF control flow
FIGURE 1.13 Ordering data flow processing with a control flow
FIGURE 1.14 ADF mapping data flow
FIGURE 1.15 Azure Databricks and SQL stored procedure control flow
FIGURE 1.16 ELT workflow
FIGURE 1.17 Analytics Maturity Model
FIGURE 1.18 Table
FIGURE 1.19 Matrix
FIGURE 1.20 Column chart
FIGURE 1.21 Line chart
FIGURE 1.22 Pie chart
FIGURE 1.23 Scatter plot
FIGURE 1.24 Map
Chapter 2
FIGURE 2.1 OLTP ERD
FIGURE 2.2 Star schema
FIGURE 2.3 View definition
FIGURE 2.4 Azure SQL abstraction vs. administrative effort
FIGURE 2.5 Select a SQL virtual machine image.
FIGURE 2.6 Create a SQL virtual machine: Basics tab.
FIGURE 2.7 Create a SQL virtual machine: Networking tab.
FIGURE 2.8 Create a SQL virtual machine: Settings tab.
FIGURE 2.9 Create Azure SQL Database Managed Instance: Basics tab.
FIGURE 2.10 Create Azure SQL Database Managed Instance: Networking tab.
FIGURE 2.11 Configuring an Azure SQL Database
FIGURE 2.12 Create Azure SQL Database: Basics tab.
FIGURE 2.13 Create Azure SQL Database: Networking tab.
FIGURE 2.14 Scaling an Azure SQL MI
FIGURE 2.15 Create MySQL server: Basics tab.
FIGURE 2.16 Azure Cloud Shell icon
FIGURE 2.17 Adding an AAD Administrator
FIGURE 2.18 Connecting to a user database with SSMS
FIGURE 2.19 Script View as ALTER To statement
FIGURE 2.20 SSMS execution plan
FIGURE 2.21 Types of SQL joins
Chapter 3
FIGURE 3.1 Key-Value store
FIGURE 3.2 Document database
FIGURE 3.3 Columnar database
FIGURE 3.4 Graph database
FIGURE 3.5 Select Azure Cosmos DB API.
FIGURE 3.6 Create an Azure Cosmos DB Account: Basics tab.
FIGURE 3.7 Create an Azure Cosmos DB Account: Networking tab.
FIGURE 3.8 Create an Azure Cosmos DB Account: Backup Policy tab.
FIGURE 3.9 Azure Cosmos DB Data Explorer button
FIGURE 3.10 Azure Cosmos DB Data Explorer splash page
FIGURE 3.11 New Database
FIGURE 3.12 New Container
FIGURE 3.13 Adding a new write region replica
FIGURE 3.14 Updating the default consistency to bounded staleness
FIGURE 3.15 Azure Cosmos DB Explorer Open Full Screen icon
FIGURE 3.16 Azure Cosmos DB Explorer pop-up screen
Chapter 4
FIGURE 4.1 Create a Storage Account: Basics tab.
FIGURE 4.2 Create a Storage Account: Advanced tab security configurations.
FIGURE 4.3 Create a Storage Account: Advanced tab storage configurations.
FIGURE 4.4 Create a Storage Account: Networking tab.
FIGURE 4.5 Create a Storage Account: Data Protection tab.
FIGURE 4.6 File shares button
FIGURE 4.7 Create a New File Share button.
FIGURE 4.8 New file share
FIGURE 4.9 Connect button
FIGURE 4.10 Connect page
FIGURE 4.11 Containers button
FIGURE 4.12 Create a New Container button.
FIGURE 4.13 New Container
FIGURE 4.14 Upload button
FIGURE 4.15 Upload blob
FIGURE 4.16 Networking button
FIGURE 4.17 Virtual Network and Firewall Access
FIGURE 4.18 Exceptions and Networking Routing
FIGURE 4.19 Shared access signature configuration options
FIGURE 4.20 Configure Active Directory for Azure Files.
FIGURE 4.21 Manage ACLs in the Azure Portal.
FIGURE 4.22 How ADLS evaluates identity access
FIGURE 4.23 Connect to Azure Storage button
FIGURE 4.24 Storage account display
FIGURE 4.25 Upload Files pop-up page
Chapter 5
FIGURE 5.1 Batch processing example
FIGURE 5.2 On-demand stream processing example
FIGURE 5.3 Lambda architecture workflow
FIGURE 5.4 Apache Spark distributed architecture
FIGURE 5.5 Create an Azure Databricks workspace: Basics tab.
FIGURE 5.6 Create an Azure Databricks workspace: Networking tab.
FIGURE 5.7 Launch Workspace button
FIGURE 5.8 Azure Databricks home page
FIGURE 5.9 Azure Databricks workspace personas
FIGURE 5.10 Azure Databricks Workspace tab
FIGURE 5.11 Azure Databricks Compute page
FIGURE 5.12 Azure Databricks Jobs page
FIGURE 5.13 Azure Databricks Create Cluster page
FIGURE 5.14 Azure Databricks Create Notebook page
FIGURE 5.15 Creating a mount point with Azure AD credential passthrough
FIGURE 5.16 Create an ADF Instance: Basics tab.
FIGURE 5.17 Create an ADF Instance: Git configuration tab.
FIGURE 5.18 Azure Data Factory overview page
FIGURE 5.19 Azure Data Factory Studio home page
FIGURE 5.20 Azure Data Factory Studio Author page
FIGURE 5.21 Azure Data Factory Studio Monitor page
FIGURE 5.22 Azure Data Factory Studio Manage page
FIGURE 5.23 Creating a blank ADF pipeline
FIGURE 5.24 The ADF Pipeline Creation page
FIGURE 5.25 Copy Data Activity: General tab
FIGURE 5.26 New Dataset page
FIGURE 5.27 New linked service page: Azure SQL Database
FIGURE 5.28 Set properties page for a new dataset: Azure SQL Database
FIGURE 5.29 Copy Data Activity: Source tab
FIGURE 5.30 New linked service page: ADLS
FIGURE 5.31 Set properties page for a new dataset: ADLS
FIGURE 5.32 Using the Azure Data Factory Studio to edit a CSV dataset
FIGURE 5.33 Copy Data Activity: Mapping tab
FIGURE 5.34 Using the Publish all button to save the pipeline and datasets....
FIGURE 5.35 Create an Azure Synapse Analytics workspace: Basics tab.
FIGURE 5.36 Create an Azure Synapse Analytics workspace: Security tab.
FIGURE 5.37 Azure Synapse workspace overview page
FIGURE 5.38 Synapse Studio home page
FIGURE 5.39 Synapse Studio Data page
FIGURE 5.40 Synapse Studio Develop page
FIGURE 5.41 Synapse Studio Integrate page
FIGURE 5.42 Synapse Studio Monitor page
FIGURE 5.43 Synapse Studio Manage page
FIGURE 5.44 New dedicated SQL pool: Basics tab
FIGURE 5.45 New dedicated SQL pool: Additional settings tab
FIGURE 5.46 Pausing a dedicated SQL pool
FIGURE 5.47 Synapse Studio SQL script window
FIGURE 5.48 Choosing the Built-in SQL pool
FIGURE 5.49 Executing Serverless SQL Pool Queries in Synapse Studio
Chapter 6
FIGURE 6.1 A blank report in the Power BI Desktop Report view. You can switc...
FIGURE 6.2 Get Data page
FIGURE 6.3 SQL Server database connection page
FIGURE 6.4 Select the tables or views that will be imported into the Power B...
FIGURE 6.5 Power Query Editor
FIGURE 6.6 M Code can be viewed and edited through the Power Query Advanced ...
FIGURE 6.7 Power BI Desktop Model view
FIGURE 6.8 Power BI Desktop Data view
FIGURE 6.9 Power BI Desktop Report view on the Order Quantity Sold Per Item ...
FIGURE 6.10 Power BI Service Workspace home page
FIGURE 6.11 Power BI Service Report view
FIGURE 6.12 The pin icon on a report visual
FIGURE 6.13 Power BI dashboard
FIGURE 6.14 Power BI Q&A output
FIGURE 6.15 Power BI Report Builder Getting Started window
FIGURE 6.16 A blank report in Power BI Report Builder
Guide
Cover Page
Title Page
Copyright
Acknowledgments
About the Author
About the Technical Editor
Introduction
Table of Contents
Begin Reading
Appendix: Answers to the Review Questions
Index
End User License Agreement
Pages
iii
iv
v
vii
xi
xvii
xviii
xix
xx
xxi
xxii
xxiii
xxiv
xxv
xxvi
xxvii
xxviii
xxix
xxx
xxxi
xxxii
xxxiii
xxxiv
xxxv
xxxvi
xxxvii
xxxviii
xxxix
xl
xli
xlii
xliii
xliv
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
329
330
331
332
333
334
335
336
337
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset