Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are working as a Fabric Analytics Engineer and are tasked with optimizing the performance of a SQL query in a Fabric lakehouse environment. The dataset contains detailed information about website page views, including the page URL, page title, and the number of views for each page. Your goal is to retrieve the top 5 most viewed pages, along with their page titles and view counts, while ensuring the query is efficient and scalable for large datasets. Which of the following SQL queries would you use to achieve this task? (Choose one option)
A
SELECT PageTitle, COUNT() AS ViewCount FROM PageViews GROUP BY PageTitle ORDER BY ViewCount DESC LIMIT 5;
B
SELECT PageURL, COUNT() AS ViewCount FROM PageViews GROUP BY PageURL ORDER BY ViewCount DESC FETCH FIRST 5 ROWS ONLY;
C
SELECT PageTitle, SUM(Views) AS ViewCount FROM PageViews GROUP BY PageTitle ORDER BY ViewCount DESC LIMIT 5;
D
SELECT TOP 5 PageTitle, COUNT() AS ViewCount FROM PageViews GROUP BY PageTitle ORDER BY ViewCount DESC;