DP-500; DESIGNING AND IMPLEMENTING
ENTERPRISE-SCALE ANALYTICS SOLUTIONS USING
MICROSOFT AZURE AND MICROSOFT POWER BI EXAM
2024-2025
What is Microsoft Purview? - ANSWER • A unified data-governance service that
helps you manage and govern your on-premises, multi-cloud, and
software-as-a-service
• Creates a holistic, up-to-date map of your data landscape with automated data
discovery, sensitive data classification, and end-to-end data lineage
Main elements of Microsoft Purview - ANSWER • Data Map
• Powers the Data Catalog and Data Estate Insights
• Data Catalog
• used to search assets (assuming a data map has been created)
•Data Estate Insights
• Offers a bird's-eye view into your data catalogue
Microsoft Purview Data Map Collections - ANSWER • Support organizational
mapping of metadata - can manage and maintain data sources, scans, and assets in a
hierarchy instead of a flat structure
• Allows you to build a custom hierarchical model of your data landscape
• Also provides a security boundary for metadata - access to collections, data
sources, and metadata is set up and maintained on the collection's hierarchy in
Purview, following a least-privilege model
Microsoft Purview Data Map - ANSWER • Powers the Purview Data Catalog and
Purview Data Estate Insights
,• Keeps an up-to-date map of assets and their metadata across your data estate
• Is scalable and robust to meet enterprise-compliance requirements
• Must be established before the Data Catalog can be searched
• To hydrate the map, need to register and scan data sources in the Microsoft
Purview governance portal
• Map hydration is done at the collection level - once registered, can begin scanning
data sources
Least-privilege model - ANSWER •Users have the minimum amount of access they
need to do their job
• Users don't have access to sensitive data that they don't need
Hydrating the Microsoft Purview Data Map - ANSWER • To hydrate the map,
need to register and scan data sources in the Microsoft Purview governance portal
• Register data source from Azure Portal, then once configured, will use Purview
Governance Portal to register data sources
• Map hydration is done at the collection level - once registered, can begin scanning
data sources
• Select 'New Scan' from a data source
• Complete basic scan configuration
• Next, scope the scan (allows you to choose a specific zone of your data source,
i.e. a specific container in your data lake)
• Next, define Scan Rule Set (a container for grouping a set of scan rules together
so that you can easily associate them with a scan)
• Once scan is complete, can refer to scan details in the 'Scan Information'
Microsoft Purview Data Catalog - ANSWER • Used to search assets (assuming the
Data Map has already been created / hydrated)
• Can also browse/explore data by collection or source type - helpful if you are new
or unfamiliar with data!
,• Can select an asset to see the overview (displays info at a glance, ie. description,
schema classification, asset hierarchy, etc.)
Microsoft Purview Data Catalog - Asset Description - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Provides a brief explanation of the purpose of an asset
Microsoft Purview Data Catalog - Asset Classification - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Way of categorizing data assets by assigning unique logical labels or classes
(based on business context of data)
Microsoft Purview Data Catalog - Glossary Terms - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Managed vocabulary for business terms that can be used to categorize and relate
assets across your environment
Microsoft Purview Data Catalog - Collection Path - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Refers to the location of the asset inside Purview; can move an asset to a different
collection if desired
Microsoft Purview Data Catalog - Asset Schema - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Includes more granular details about the asset (i.e. column names, data types,
column-level classifications, terms, and descriptions)
Microsoft Purview Data Catalog - Asset Lineage - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
• Gives you a clear view of how the asset is populated and where data comes from
• Important for understanding of where data is coming from, what upstream
changes may have occurred, and how it flows through the enterprise data systems
Microsoft Purview Data Catalog - Asset Contacts - ANSWER • Piece of
information displayed in asset overview in Purview Data Catalog
, • Provide contact details of experts or dataset owners
Microsoft Purview Data Estate Insights - ANSWER • Offers a birds-eye view into
your data catalog, covering these key facets:
•Asset Insights
• Scan Insights
• Glossary Insights
• Classification Insights
• Sensitivity Insights
• File Extension Insights
Microsoft Purview Data Estate Insights - Asset Insights - ANSWER • Key facet
covered in Microsoft Purview Data Estate Insights
• A report on the data estate and source-type distribution
• Can view by source type, classification, and file size
• Can view the insights as a graph or KPI
Microsoft Purview Data Estate Insights - Scan Insights - ANSWER • Key facet
covered in Microsoft Purview Data Estate Insights
• Provides information on the health of your scans (successes, failures, or
cancelled)
Microsoft Purview Data Estate Insights - Glossary Insights - ANSWER • Key facet
covered in Microsoft Purview Data Estate Insights
• A status report on the glossary to help users understand the distribution of
glossary terms by status, or to view how the terms are attached to assets
Microsoft Purview Data Estate Insights - Classification Insights - ANSWER • Key
facet covered in Microsoft Purview Data Estate Insights
• Report showing where classified data is located
• Allows security administrators to understand the types of information found in
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.49. You're not tied to anything after your purchase.