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.putSecret and specify the key vault URL and key vault secret.Does this meet the goal?
Answer(s): B
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
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 the name of a linked service.Does this meet the goal?
DRAG DROP (Drag and Drop is not supported) (Drag and Drop is not supported)You have two Fabric notebooks named Load_Salesperson and Load_Orders that read data from Parquet files in a lakehouse. Load_Salesperson writes to a Delta table named dim_salesperson. Load_Orders writes to a Delta table named fact_orders and is dependent on the successful execution of Load_Salesperson.You need to implement a pattern to dynamically execute Load_Salesperson and Load_Orders in the appropriate order by using a notebook.How should you complete the code? To answer, drag the appropriate values the correct targets. Each value 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:
Answer(s): A
Box 1: activities The following is an example of running notebooks with topological structure using mssparkutils.notebook.runMultiple(). Use this method to easily orchestrate notebooks through a code experience.# run multiple notebooks with parameters DAG = { "activities": [ { "name": "NotebookSimple", # activity name, must be unique "path": "NotebookSimple", # notebook path "timeoutPerCellInSeconds": 90, # max timeout for each cell, default to 90 seconds "args": {"p1": "changed value", "p2": 100}, # notebook parameters }, { "name": "NotebookSimple2", "path": "NotebookSimple2", "timeoutPerCellInSeconds": 120, "args": {"p1": "changed value 2", "p2": 200} }, { "name": "NotebookSimple2.2", "path": "NotebookSimple2", "timeoutPerCellInSeconds": 120, "args": {"p1": "changed value 3", "p2": 300}, "retry": 1, "retryIntervalInSeconds": 10, "dependencies": ["NotebookSimple"] # list of activity names that this activity depends on } ], "timeoutInSeconds": 43200, # max timeout for the entire DAG, default to 12 hours "concurrency": 50 # max number of notebooks to run concurrently, default to 50 } mssparkutils.notebook.runMultiple(DAG, {"displayDAGViaGraphviz": False}) Box 2: dependenciesBox 3: runMultiple Reference run multiple notebooks in parallel This feature is in preview.The method mssparkutils.notebook.runMultiple() allows you to run multiple notebooks in parallel or with a predefined topological structure. The API is using a multi-thread implementation mechanism within a spark session, which means the compute resources are shared by the reference notebook runs.With mssparkutils.notebook.runMultiple(), you can:* Execute multiple notebooks simultaneously, without waiting for each one to finish.*-> Specify the dependencies and order of execution for your notebooks, using a simple JSON format.* Etc. Here's a simple example of running a list of notebooks in parallel using this method:mssparkutils.notebook.runMultiple(["NotebookSimple", "NotebookSimple2"])
https://learn.microsoft.com/en-us/fabric/data-engineering/microsoft-spark-utilities
HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse2.A team of data analysts has Viewer role access to Workspace1.You create a table by running the following statement.You need to ensure that the team can view only the first two characters and the last four characters of the CreditCard attribute.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:
Box 1: ALTER How to implement dynamic data masking in Fabric Data WarehouseConfigure dynamic data maskingManage and modify dynamic data masking rules To manage or modify existing dynamic data masking rules, create a new SQL script.You can add a mask to an existing column, using the MASKED WITH FUNCTION clause:ALTER TABLE dbo.EmployeeData ALTER COLUMN [email] ADD MASKED WITH (FUNCTION = 'email()'); GOBox 2: ALTERBox 3: PARTIAL As for the SSN column in the example below.Note: In your SQL script, define dynamic data masking rules using the MASKED WITH FUNCTION clause. For example:CREATE TABLE dbo.EmployeeData ( EmployeeID INT ,FirstName VARCHAR(50) MASKED WITH (FUNCTION = 'partial(1,"-",2)') NULL ,LastName VARCHAR(50) MASKED WITH (FUNCTION = 'default()') NULL ,SSN CHAR(11) MASKED WITH (FUNCTION = 'partial(0,"XXX-XX-",4)') NULL ,email VARCHAR(256) NULL ); GO INSERT INTO dbo.EmployeeData VALUES (1, 'TestFirstName', 'TestLastName', '123-45-6789','email@youremail.com'); GO INSERT INTO dbo.EmployeeData VALUES (2, 'First_Name', 'Last_Name', '000-00-0000','email2@youremail2.com'); GO The FirstName column shows only the first and last two characters of the string, with - in the middle. The LastName column shows XXXX. The SSN column shows XXX-XX- followed by the last four characters of the string.
https://learn.microsoft.com/en-us/fabric/data-warehouse/howto-dynamic-data-masking
HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)You are building a data orchestration pattern by using a Fabric data pipeline named Dynamic Data Copy as shown in the exhibit. (Click the Exhibit tab.)Dynamic Data Copy does NOT use parametrization.You need to configure the ForEach activity to receive the list of tables to be copied.How should you complete the pipeline expression? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: Lookup Schema and Table Copy multiple tables in bulk by using Azure Data Factory in the Azure portalThe ForEach activity iterates through a list of tables, and passes one by one to the Copy activity.Example [replace LookupTableList with Lookup Schema and Table]: In the Parameters section, click the input box under VALUE -> select the Add dynamic content below -> enter @activity('LookupTableList').output.value as table name value -> select Finish. You're setting the result list from the Lookup activity as an input to the second pipeline. The result list contains the list of tables whose data needs to be copied to the destination.Box 2: output.value
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal
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.