
Answer-first summary for fast verification
Answer: assetType:Table OR assetType:view
## Explanation To search the Microsoft Purview Data Catalog for assets where the `assetType` property is either 'Table' or 'View', we need to use the correct search syntax supported by Purview's unified catalog. ### Correct Answer Analysis **Option B (`assetType:Table OR assetType:view`)** is the correct choice because: - **Purview Field Search Syntax**: Microsoft Purview uses a specific syntax where field searches follow the pattern `fieldName:value` - **OR Operator Support**: The `OR` operator is properly used to combine multiple field searches for the same property - **Valid Syntax**: This format `assetType:Table OR assetType:view` correctly searches for assets where assetType equals 'Table' OR assetType equals 'View' - **Case Sensitivity**: Note that 'Table' and 'view' have different casing, which reflects how these asset types are typically stored in the catalog ### Incorrect Options Analysis **Option A (`assetType IN ('Table', 'View')`)** - This uses SQL-like `IN` syntax which is not supported in Purview catalog searches. Purview uses a different query language for catalog searches. **Option C (`assetType = (Table OR View)`)** - This mixes SQL equality syntax with logical operators in an unsupported format. The parentheses grouping is not valid in Purview search syntax. **Option D (`assetType:(Table OR View)`)** - While this might seem intuitive, grouping with parentheses within a field search is explicitly not supported in Purview. The documentation specifies that grouping isn't supported within field searches. ### Best Practice Recommendation When searching Microsoft Purview Data Catalog: - Use the `fieldName:value` syntax for property searches - Use logical operators (`AND`, `OR`, `NOT`) to combine multiple conditions - Avoid SQL-like syntax or parentheses grouping within field searches - Refer to Microsoft's official documentation for the most current search syntax requirements
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have an Azure subscription containing a Microsoft Purview account.
You need to search the Microsoft Purview Data Catalog to find assets where the assetType property is either 'Table' or 'View'.
Which query should you use?
A
assetType IN ('Table', 'View')
B
assetType:Table OR assetType:view
C
assetType = (Table OR View)
D
assetType:(Table OR View)