Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:-BikepointID-Street-Neighbourhood-No_Bikes-No_Empty_Docks-TimestampYou need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.Solution: You use the following code segment:Does this meet the goal?
Answer(s): B
This code does not meet the goal because it uses sort by without specifying the order, which defaults to ascending, but explicitly mentioning asc improves clarity.
This code does not meet the goal because it uses order by, which is not valid in KQL. The correct term in KQL is sort by.
Answer(s): A
Where Condition: It correctly finds rows where Neighbourhood is "Sands End" and No_Bikes is greater than or equal to 15.Sorting: The sorting is explicitly done by No_Bikes in ascending order using sort by No_Bikes asc.Projection: It projects the required columns (BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp), which minimizes the data returned for consumption.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure key vault named KeyVault1 that contains secrets.You have a Fabric workspace named Workspace1. Workspace contains a notebook named Notebook1 that performs the following tasks:-Loads stage data to the target tables in a lakehouse-Triggers the refresh of a semantic modelYou plan to add functionality to Notebook1 that will use the Fabric API to monitor the semantic model refreshes.You need to retrieve the registered application ID and secret from KeyVault1 to generate the authentication token.Solution: You use the following code segment:Use notebookutils.credentials.getSecret and specify the key vault URL and key vault secret.Does this meet the goal?
Correct: * You use the following code segment:Use notebookutils.credentials.getSecret and specify the key vault URL and key vault secret.Incorrect:* You use the following code segment:Use notebookutils.credentials.putSecret and specify the key vault URL and key vault secret.* You use the following code segment:Use notebookutils.credentials.getSecret and specify the key vault URL and the name of a linked service.Note: Help on module notebookutils.credentials in notebookutils:NAME notebookutils.credentials - Utility for credentials operations in FabricFUNCTIONS getSecret(akvName, secret) -> str Gets a secret from the given Azure Key Vault. :param akvName: The name of the Azure Key Vault. :param secret: The name of the secret. :return: The secret value.notebookutils.credentials.getSecret('https://<name>.vault.azure.net/', 'secret name')
https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-utilities
Post your Comments and Discuss Microsoft DP-700 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the DP-700 content, but please register or login to continue.