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)