You have a Fabric workspace that contains a Real-Time Intelligence solution and an Eventhouse.Users report that from OneLake file explorer, they cannot see the data from the Eventhouse.You enable OneLake availability for the KQL database.What will be copied to OneLake?
Answer(s): E
You have a Fabric workspace named Workspace1.You plan to integrate Workspace1 with Azure DevOps.You will use a Fabric deployment pipeline named deployPipeline1 to deploy items from Workspace1 to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1 by using an API call from an Azure DevOps pipeline.You need to configure API authentication between Azure DevOps and Fabric.Which type of authentication should you use?
Answer(s): A
When integrating Azure DevOps with Fabric (Workspace1), using a service principal is the recommended authentication method. A service principal provides a way for applications (such as an Azure DevOps pipeline) to authenticate and interact with resources securely. It allows Azure DevOps to authenticate API calls to Fabric without requiring direct user credentials. This method is ideal for automating tasks such as deploying items through a Fabric deployment pipeline.
You have a Google Cloud Storage (GCS) container named storage1 that contains the files shown in the following table.You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the shortcuts shown in the following table.You need to read data from all the shortcuts.Which shortcuts will retrieve data from the cache?
Answer(s): C
When reading data from shortcuts in Fabric (in this case, from a lakehouse like Lakehouse1), the cache for shortcuts helps by storing the data locally for quick access. The last accessed timestamp and the cache expiration rules determine whether data is fetched from the cache or from the source (Google Cloud Storage, in this case).Products: The ProductFile.parquet was last accessed 12 hours ago. Since the cache has data available for up to 12 hours, it is likely that this data will be retrieved from the cache, as it hasn't been too long since it was last accessed.Stores: The StoreFile.json was last accessed 4 hours ago, which is within the cache retention period. Therefore, this data will also be retrieved from the cache.Trips: The TripsFile.csv was last accessed 48 hours ago. Given that it's outside the typical caching window (assuming the cache has a maximum retention period of around 24 hours), it would not be retrieved from the cache. Instead, it will likely require a fresh read from the source.
You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1.You have an Azure SQL database named Source1 that has public internet access disabled.You need to ensure that Job1 can access the data in Source1.What should you create?
Answer(s): B
To allow Job1 in Workspace1 to access an Azure SQL database (Source1) with public internet access disabled, you need to create a managed private endpoint. A managed private endpoint is a secure, private connection that enables services like Fabric (or other Azure services) to access resources such as databases, storage accounts, or other services within a virtual network (VNet) without requiring public internet access. This approach maintains the security and integrity of your data while enabling access to the Azure SQL database.
You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2.You have the Parquet files shown in the following table.You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts:-A shortcut to ProductFile aliased as Products-A shortcut to StoreFile aliased as Stores-A shortcut to TripsFile aliased as TripsThe data from which shortcuts will be retrieved from the cache?
When the cache for shortcuts is enabled in Fabric, the data retrieval is governed by the caching behavior, which generally retains data for a specific period after it was last accessed. The data from the shortcuts will be retrieved from the cache if the data is stored in locations that support caching. Here's a breakdown based on the data's location:-Products: The ProductFile is stored in Azure Data Lake Storage Gen2 (storage1). Since Azure Data Lake is a supported storage system in Fabric and the file is relatively small (50 MB), this data is most likely cached and can be retrieved from the cache.-Stores: The StoreFile is stored in Amazon S3 (storage2), and even though it is stored in a different cloud provider, Fabric can cache data from Amazon S3 if caching is enabled. This data (25 MB) is likely cached and retrievable.-Trips: The TripsFile is stored in Amazon S3 (storage2) and is significantly larger (2 GB) compared to the other files. -While Fabric can cache data from Amazon S3, the larger size of the file (2 GB) may exceed typical cache sizes or retention windows, causing this file to likely be retrieved directly from the source instead of the cache.
HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)You have a Fabric workspace named Workspace1 that contains the items shown in the following table.For Model1, the Keep your Direct Lake data up to date option is disabled.You need to configure the execution of the items to meet the following requirements:-Notebook1 must execute every weekday at 8:00 AM.-Notebook2 must execute when a file is saved to an Azure Blob Storage container.-Model1 must refresh when Notebook1 has executed successfully.How should you orchestrate each item? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Notebook1 - Add Notebook1 to Pipeline1. To schedule Notebook1 to run every weekday at 8:00 AM, the best way to orchestrate it is by adding it to Pipeline1 and then configuring a schedule for the pipeline execution. This allows you to leverage the scheduling capabilities of pipelines in Fabric, ensuring that Notebook1 runs at the desired time.Notebook2 - From Real-Time hub, configure the execution of Notebook2. Since Notebook2 needs to execute when a file is saved to an Azure Blob Storage container, the best way to trigger this is by using Real-Time hub. The Real-Time hub is designed for event-driven scenarios like this, where an external event (e.g., file saved to a blob) can trigger the execution of a notebook.Pipeline1 - Configure the execution of Pipeline1 by using a schedule. To ensure Model1 refreshes when Notebook1 has executed successfully, you can orchestrate the execution flow by adding Notebook1 to Pipeline1 and configuring the pipeline to execute on a schedule (such as when Notebook1 runs). You can also use dependencies within the pipeline to ensure Model1 only refreshes after Notebook1 executes.Model1 - Add Model1 to Pipeline1. To ensure Model1 refreshes when Notebook1 executes, you need to add Model1 to Pipeline1 and configure the execution within the pipeline. By configuring the pipeline so that Model1 refreshes after Notebook1 has successfully executed, you establish the correct dependency. Additionally, ensure that the Keep your Direct Lake data up to date option is disabled since the refresh is controlled by Pipeline1.
Your company has a sales department that uses two Fabric workspaces named Workspace1 and Workspace2.The company decides to implement a domain strategy to organize the workspaces.You need to ensure that a user can perform the following tasks:-Create a new domain for the sales department.-Create two subdomains: one for the east region and one for the west region.-Assign Workspace1 to the east region subdomain.-Assign Workspace2 to the west region subdomain.The solution must follow the principle of least privilege.Which role should you assign to the user?
Answer(s): D
You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1.You plan to add a user named User3 to Workspace1.You need to ensure that User3 can perform the following actions:-View all the items in Workspace1.-Update the tables in DW1.The solution must follow the principle of least privilege.You already assigned the appropriate object-level permissions to DW1.Which workspace role should you assign to User3?
To ensure User3 can view all items in Workspace1 and update the tables in DW1, the most appropriate workspace role to assign is the Contributor role. This role allows User3 to:1. View all items in Workspace1: The Contributor role provides the ability to view all objects within the workspace, such as data pipelines, warehouses, and other resources. 2. Update the tables in DW1: The Contributor role allows User3 to modify or update resources within the workspace, including the tables in DW1, assuming that appropriate object-level permissions are set for the warehouse.This role adheres to the principle of least privilege, as it provides the necessary permissions without granting broader administrative rights.
Share your comments for Microsoft DP-700 exam with other users:
so why did u mark it as certified incorrectlyYou’re right to challenge that. I made an error by accepting the question bank’s explanation instead of checking whether dashboards support endorsement. I should have identified that:
Q23: Fabric Admin is correct. Because Domain admin cannot create domains. Only Fabric Admin can among the given options. Q51: Wrapping @pipeline.parameter.param1 inside {} will return a string. But question requires the expression to return Int, so correct answer should be @pipeline.parameter.param1 (no {})
Question 23:The correct answer is Domain admin (option B), not Fabric admin.