How to search Microsoft Purview Data Catalog for specific asset types?

DP-203 By islever Editorial Last updated

Short answer

B assetType:Table OR assetType:view

Question

You have an Azure subscription that contains a Microsoft Purview account. You need to search the Microsoft Purview Data Catalog to identify assets that have an assetType property of Table or View. Which query should you run?
  1. assetType IN ('Table', 'View')
  2. assetType:Table OR assetType:view Correct Answer
  3. assetType = (Table OR View)
  4. assetType:(Table OR View)

Key Takeaways

The exam tests knowledge of Purview's query language limitations, specifically that grouping is not supported within a single field search, requiring separate field references combined with OR.

This question tests the correct KQL syntax for filtering assets in the Microsoft Purview Data Catalog. The community consensus confirms that field-specific searches require a colon and that boolean operators must be applied across separate field queries rather than grouped within one.

Common mistake: Option C is a common trap because it attempts to group values (Table OR View) inside parentheses after the field name, which violates the syntax rule that grouping is unsupported within a field search.

Expert Analysis

Why the Answer Is Correct

The correct syntax for searching specific properties in Microsoft Purview is propertyName:value. Since you need to find assets that are either 'Table' or 'View', you must specify the property twice: assetType:Table and assetType:View, connected by the OR operator. This results in the query assetType:Table OR assetType:view.

Why the Other Options Are Wrong

Option A uses SQL-like syntax (IN) which is not supported in Purview's unified catalog search. Option C attempts to use parentheses to group values (assetType = (Table OR View)), but Purview does not support grouping within a single field search. Option D uses incorrect syntax for field matching (: implies a prefix match or exact match depending on context, but the grouping remains invalid).

Community Comment Notes

Comment [1] provides the official Microsoft Learn link explaining that grouping is not supported within a field search and gives examples like name:(alice AND bob) being invalid. Comments [2] and [3] simply confirm that B is the correct answer based on standard Purview syntax.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 3 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 3

  1. 17lan 👍 1 Answered B
    Correct Syntax explained here: https://learn.microsoft.com/en-us/purview/unified-catalog-search#browse-the-unified-catalog Grouping isn't supported within a field search. Customers should use operators to connect field searches. For example,name:(alice AND bob) is invalid search syntax, but name:alice AND name:bob is supported.
  2. JamieMcD 👍 2 Answered B
    Correct Purview syntax
  3. tadenet 👍 2 Answered B
    Correct!

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

How to Verify Result Set Cache Usage in Azure Synapse SQL Pools?

S-grade

Which Diagnostic Setting Tracks Query Start and End Times in Synapse SQL Pool?

S-grade

Which Integration Runtime Connects On-Premises Linux Databases to Azure Data Factory?

S-grade

Which Log Analytics table stores ADF pipeline runs in resource-specific mode?

S-grade

← Back to DP-203 Study Guide