HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named DimCustomers. DimCustomers contains the following columns:-CustomerName-CustomerID-BirthDate-EmailYou need to configure security to meet the following requirements:-BirthDate in DimCustomer must be masked and display 1900-01-01.-Email in DimCustomer must be masked and display only the first leading character and the last five characters.How should you complete the statement? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: random(1900-01-01, 1900-01-01) BirthDate in DimCustomer must be masked and display 1900-01-01.Random A random masking function for use on any numeric type to mask the original value with a random value within a specified range. Example definition syntax: Account_Number bigint MASKED WITH (FUNCTION = 'random ([start range], [end range])')Example of alter syntax: ALTER COLUMN [Month] ADD MASKED WITH (FUNCTION = 'random(1, 12)')Box 2: 'partial(1,"@",5)' EmailAddress in DimCustomer must be masked and display only the first leading character and the last five characters.Custom String Masking method that exposes the first and last letters and adds a custom padding string in the middle. prefix,[padding],suffixIf the original value is too short to complete the entire mask, part of the prefix or suffix isn't exposed.xample definition syntax: FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(prefix, [padding],suffix)') NULLExample of alter syntax: ALTER COLUMN [Phone Number] ADD MASKED WITH (FUNCTION = 'partial (1,"XXXXXXX",0)')This turns a phone number like 555.123.1234 into 5XXXXXXX.Incorrect: * 'default()'Full masking according to the data types of the designated fields. default() displays XXXX.
https://learn.microsoft.com/en-us/fabric/data-warehouse/howto-dynamic-data-masking
You have a Fabric workspace named Workspace1 that contains the following items:-A Microsoft Power BI report named Report1-A Power BI dashboard named Dashboard1-A semantic model named Model1-A lakehouse name Lakehouse1Your company requires that specific governance processes be implemented for the items.Which items can you endorse in Fabric?
Answer(s): E
Not the Power BI dashboard Dashboard1.Note: Endorsement is a Fabric and Power BI feature that makes it easier for users in an organization to find high-quality, trust-worthy content and data. Endorsed items are clearly labeled in the UI with a badge, and in some lists they are given precedence and are listed first.Items can receive one of three endorsement badges - Promoted, Certified, or Master data:Promoted: When an item has the Promoted badge, it means that the item creators think the item is ready for sharing and reuse. Any Fabric or Power BI item except Power BI dashboards can be promoted. Any user with write permissions on an item can promote it.Certified: When an item has the Certified badge, it means that an organization-authorized reviewer has certified that the item meets the organization's quality standards, can be regarded as reliable and authoritative, and is ready for use across the organization. Any Fabric or Power BI item except Power BI dashboards can be certified. Any user can request certification for an item, but only users specified by a Fabric administrator can actually certify items.
https://learn.microsoft.com/en-us/fabric/governance/endorsement-overview
You have a Fabric workspace named Workspace1.Your company acquires GitHub licenses.You need to configure source control for Workpace1 to use GitHub. The solution must follow the principle of least privilege.Which permissions do you require to ensure that you can commit code to GitHub?
Answer(s): C
Microsoft Fabric Git integrationGit roles The following table describes the Git permissions needed to perform various common operations: If you're using a fine-grained access token, the following permissions are needed for common operations:* Commit workspace changes to Git Contents= Access: Read and write branch policy should allow direct commitNote: * Commit workspace changes to Git All of the following roles: Contributor in the workspace (WRITE permission on all items) Owner of the item (if the tenant switch blocks updates for nonowners) BUILD on external dependencies (where applicable)
https://learn.microsoft.com/en-us/fabric/cicd/git-integration/git-integration-process
You have a Fabric workspace named Workspace1.You plan to configure Git integration for Workspace1 by using an Azure DevOps Git repository.An Azure DevOps admin creates the required artifacts to support the integration of Workspace1.Which details do you require to perform the integration?
Microsoft Fabric Git integrationConnect to your new Azure DevOps git repository, then click on the Connect and sync button:
https://knowledge.bigenius-x.com/microsoft-fabric-stage-files-target-environment
You have a Fabric workspace that contains a lakehouse and a semantic model named Model1.You use a notebook named Notebook1 to ingest and transform data from an external data source.You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet the following requirements:-Run daily at 07:00 AM UTC.-Attempt to retry Notebook1 twice if the notebook fails.-After Notebook1 executes successfully, refresh Model1.Which three actions should you perform? Each correct answer presents part of the solution.Note: Each correct selection is worth one point.
Answer(s): A,B,C
Only execute the Semantic model refresh activity if Notebook1 is successful The pipeline is to be scheduled, not the notebook activity. Attempt to retry Notebook1 twice if the notebook fails.
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.