Microsoft Fabric Analytics Engineer Associate DP-600

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Ultimate access to all questions.


As a Fabric Analytics Engineer, you are working on a project that requires analyzing product data stored in a Fabric lakehouse. The dataset includes product categories with attributes such as category ID, category name, and the number of products in each category. Your task is to write a SQL query that retrieves the category name and the number of products for each category, but only for categories that have 10 or more products. Additionally, the solution must be optimized for performance and adhere to best practices for querying large datasets in a lakehouse environment. Choose the best SQL query from the options below to accomplish this task. (Select one option)