You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.A user named User1 wants to use SQL to analyze the data in Lakehouse1.You need to configure access for User1. The solution must meet the following requirements:-Provide User1 with read access to the table data in Lakehouse1.-Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.-Prevent User1 from accessing other items in Workspace1.What should you do?
Answer(s): A
DRAG DROP (Drag and Drop is not supported) (Drag and Drop is not supported)You are implementing the following data entities in a Fabric environment:1. Entity1: Available in a lakehouse and contains data that will be used as a core organization entity 2. Entity2: Available in a semantic model and contains data that meets organizational standards 3. Entity3: Available in a Microsoft Power BI report and contains data that is ready for sharing and reuse 4. Entity4: Available in a Power BI dashboard and contains approved data for executive-level decision makingYour company requires that specific governance processes be implemented for the data.You need to apply endorsement badges to the entities based on each entity’s use case.Which badge should you apply to each entity? To answer, drag the appropriate badges the correct entities. Each badge may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Note: Each correct selection is worth one point.Select and Place:
Entity1: Master data Entity1 is available in a lakehouse and contains data that will be used as a core organizational entity. This type of data, essential for the organization’s operation, qualifies as Master data, which is foundational and authoritative within the business.Entity2: Certified Entity2 is available in a semantic model and contains data that meets organizational standards. Since it conforms to defined standards and has been validated, it should be Certified, signifying that it has passed the required data quality checks and is trusted for reporting and analysis.Entity3: Promoted Entity3 is available in a Microsoft Power BI report and contains data that is ready for sharing and reuse. Since the data is actively promoted for sharing and reuse within the organization, it receives the Promoted badge. This signifies that the data has been curated for wider consumption and distribution.Entity4: Certified Entity4 is available in a Power BI dashboard and contains approved data for executive-level decision making. This data is trusted and vetted for high-level decision-making and is thus Certified, indicating that it meets rigorous standards and is fit for executive-level use.
HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)You have three users named User1, User2, and User3.You have the Fabric workspaces shown in the following table.You have a security group named Group1 that contains User1 and User3.The Fabric admin creates the domains shown in the following table.User1 creates a new workspace named Workspace3.You add Group1 to the default domain of Domain1.For each of the following statements, select Yes if the statement is true. Otherwise, select No.Note: Each correct selection is worth one point.Hot Area:
User3 has Viewer role access to Workspace3 – Yes Since User1 is the admin of Domain1 and Group1 (which contains User1 and User3) has been added to Domain1, User3 inherits the permissions based on their membership in Group1. By default, members of Domain1 will likely have the Viewer role in any new workspaces created within Domain1 unless specifically restricted.User3 has Domain contributor access to Domain1 – No Although User3 is part of Group1, which is added to Domain1, User1 is the admin of Domain1, and there is no direct assignment of Domain contributor access to User3. User3 inherits Viewer permissions for the workspaces under Domain1, but not Domain contributor permissions.User2 has Contributor role access to Workspace3 – No User2 is the admin of Domain2 and has no explicit permissions on Workspace3, which was created by User1 (the admin of Workspace1). Since User2 is not an admin of Domain1 (which governs Workspace3), they do not automatically have the Contributor role in Workspace3. Access to the workspace is governed by the workspace admin or the domain admin, but no such permission has been explicitly assigned to User2 for Workspace3.
You have two Fabric workspaces named Workspace1 and Workspace2.You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Workspace2. DeployPipeline1 contains all the items in Workspace1.You recently modified the items in Workspaces1.The workspaces currently contain the items shown in the following table.Items in Workspace1 that have the same name as items in Workspace2 are currently paired.You need to ensure that the items in Workspace1 overwrite the corresponding items in Workspace2. The solution must minimize effort.What should you do?
Answer(s): D
When running a deployment pipeline in Fabric, if the items in Workspace1 are paired with the corresponding items in Workspace2 (based on the same name), the deployment pipeline will automatically overwrite the existing items in Workspace2 with the modified items from Workspace1. There's no need to delete, rename, or back up items manually unless you need to keep versions. By simply running deployPipeline1, the pipeline will handle overwriting the existing items in Workspace2 based on the pairing, ensuring the latest version of the items is deployed with minimal effort.
You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.You have a deployment pipeline named deployPipeline1 that used to deploy Workspace1 to Workspace2.Workspace1 and Workspace2 are currently synchronized.You restructure Workspace1 by adding a folder named Folder1 and moving Pipeline1 to Folder1.You use deployPipeline1 to deploy Workspace1 to Workspace2.What occurs to Workspace2?
When you restructure Workspace1 by adding a new folder (Folder1) and moving Pipeline1 into it, deployPipeline1 will deploy the entire structure of Workspace1 to Workspace2, preserving the changes made in Workspace1. This includes:-Folder1 will be created in Workspace2, mirroring the structure in Workspace1.-Pipeline1 will be moved into Folder1 in Workspace2, maintaining the same folder structure.-Lakehouse1 will be deployed to Workspace2 as it exists in Workspace1.
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process
DRAG DROP (Drag and Drop is not supported) (Drag and Drop is not supported)Your company has a team of developers. The team creates Python libraries of reusable code that is used to transform data.You create a Fabric workspace name Workspace1 that will be used to develop extract, transform, and load (ETL) solutions by using notebooks.You need to ensure that the libraries are available by default to new notebooks in Workspace1.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
To ensure that your Python libraries are available by default to new notebooks in Workspace1, you need to follow these steps: 1. Create an environment: First, you need to create an environment where your libraries can be installed. This environment will be used by notebooks to access the required libraries. 2. Install the libraries: After creating the environment, you install the required Python libraries into that environment. These libraries can then be used by notebooks within Workspace1. 3. Set the default environment: Finally, to make sure that the libraries are available to new notebooks by default, you set this environment as the default environment for notebooks. When you create a new notebook, it will automatically use the environment with the installed libraries.
You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation.You need to consolidate the underlying Parquet files in Table1.Which command should you run?
Answer(s): C
To consolidate the underlying Parquet files in Table1 and improve query performance by optimizing the data layout, you should use the OPTIMIZE command in Delta Lake. The OPTIMIZE command coalesces smaller files into larger ones and reorganizes the data for more efficient reads. This is particularly useful when working with large datasets in Delta tables, as it helps reduce the number of files and improves performance for subsequent queries or operations like MERGE.
You have five Fabric workspaces.You are monitoring the execution of items by using Monitoring hub.You need to identify in which workspace a specific item runs.Which column should you view in Monitoring hub?
Answer(s): G
To identify in which workspace a specific item runs in Monitoring hub, you should view the Location column. This column indicates the workspace where the item is executed. Since you have multiple workspaces and need to track the execution of items across them, the Location column will show you the exact workspace associated with each item or job execution.
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.
Keeping this site free takes real effort. We constantly battle automated scraping and unauthorized content copying. A quick account helps us protect the community and keep the site free.
To continue studying for your DP-700, please sign in or create a free account.