HOTSPOT
HOTSPOT You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry dat a. The data is organized in folders by the year, month, and day according to when the telemetry was…
DP-500
Which three actions should you perform in sequence?
DRAG DROP You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root The OData feed is…
HOTSPOT
HOTSPOT You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five How should you complete the code?…
How should you configure the chart?
HOTSPOT You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips. You need to create a chart that will show the total trip distance according to the number of passengers as shown in the…
HOTSPOT
HOTSPOT You have the Power BI workspaces shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one…
Which three actions should you perform in sequence?
DRAG DROP You have a shared dataset in Power Bl named Dataset1. You have an on-premises Microsoft SQL Server database named DB1. You need to ensure that Dataset1 refreshes data from DB1. Which three actions should you perform in sequence?…
How should you complete the DAX expression?
HOTSPOT You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column. pfflag = IF(‘Calendar'[Date] < TOOAYQ, "Past", "Future") You need to create a measure that will perform a fiscal prior year-to-date…
How should you complete the query?
HOTSPOT You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table. A sample of the…
Which type of pool should each group use?
DRAG DROP You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table. Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each…
HOTSPOT
HOTSPOT You have a Power Bl dataset that has the query dependencies shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each…