How to search Microsoft Purview Data Catalog for specific asset types?
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?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
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.
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.
Community Discussion (3 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The correct syntax for searching specific properties in Microsoft Purview ispropertyName: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 likename:(alice AND bob) being invalid. Comments [2] and [3] simply confirm that B is the correct answer based on standard Purview syntax.