You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod.You need to deploy an Eventhouse as part of the deployment process.What should you use to add the Eventhouse to the deployment process?
Answer(s): A
Correct: * an Azure DevOps pipelineIncorrect: * a deployment pipeline * an eventstream * GitHub Actions
https://oulasvirta.com/data/2024/10/15/the-enterprise-fabric-challenge-devops-for-microsoft-fabric.html
You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.You plan to implement row-level security (RLS).You need to ensure that the sales representatives can see only their respective data.Which warehouse object do you require to implement RLS?
Answer(s): C
Correct: * Function Restrict access to certain rows to certain users Implement RLS by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions.* SECURITY POLICYIncorrect: * CONSTRAINT * DATABASE ROLE * SCHEMA * STORED PROCEDURE* TABLE * TRIGGER
https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security
Correct: * Function Restrict access to certain rows to certain users Implement RLS by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions.* SECURITY POLICYIncorrect: * CONSTRAINT * DATABASE ROLE * SCHEMA * STORED PROCEDURE * TABLE * TRIGGER
You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.Users report that the performance of some of the reports has degraded over time and some visuals show errors.You need to resolve the performance issues. The solution must meet the following requirements:-Provide the best query performance.-Minimize operational costs.Which should you do?
Answer(s): D
Correct: * Increase the capacity. Direct Lake in Fabric F32 Capacity supports tables up to 300 million rows. F64 can handle 500 million rows.Incorrect: * Change the MD5 hash to SHA256. * Create views. * Disable V-Order on the warehouse. * Enable V-Order. * Modify the surrogate keys to use a different data type.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Fabric-Capacity-Scaling-and-Power-BI-What-happens-when-Power-BI/ba-p/4403792
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.You plan to deploy Warehouse 1 to a new workspace named Workspace2.As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort and provide detailed information about the invalid references.What should you use?
Answer(s): B
Correct: * a deployment pipelineIncorrect: * a database project * a dbt project* a Python script * a T-SQL scriptNote: A deployment pipeline in Fabric allows you to deploy assets like warehouses, datasets, and reports between different workspaces (such as from Workspace1 to Workspace2). One of the key features of a deployment pipeline is the ability to check for invalid references before deployment. This can help identify issues with assets, such as broken links or dependencies, ensuring the deployment is successful without introducing errors. This is the most efficient way to verify references and manage the deployment with minimal development effort.
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process
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.