최신 DP-700 무료덤프 - Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric
You have a Fabric workspace that contains a lakehouse named Lakehousel.
You plan to create a data pipeline named Pipeline! to ingest data into Lakehousel. You will use a parameter named paraml to pass an external value into Pipeline1!. The paraml parameter has a data type of int You need to ensure that the pipeline expression returns param1 as an int value.
How should you specify the parameter value?
You plan to create a data pipeline named Pipeline! to ingest data into Lakehousel. You will use a parameter named paraml to pass an external value into Pipeline1!. The paraml parameter has a data type of int You need to ensure that the pipeline expression returns param1 as an int value.
How should you specify the parameter value?
정답: D
You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table 1 has a column named EmailAddress. All users have access to Warehouse1.
You need to configure dynamic data masking for the EmailAddress column. The solution must meet the following requirements:
* The solution must NOT change the data in Warehouse1.
* The solution must NOT require changes to the queries that access Table1.
* The solution must NOT require changes to the security or permissions granted to Warehouse1.
What should you use?
You need to configure dynamic data masking for the EmailAddress column. The solution must meet the following requirements:
* The solution must NOT change the data in Warehouse1.
* The solution must NOT require changes to the queries that access Table1.
* The solution must NOT require changes to the security or permissions granted to Warehouse1.
What should you use?
정답: C
You have a Fabric workspace that contains 10 data pipelines named Pipeline1 through Pipeline10. The data pipelines load, transform, and publish data to a lakehouse named Lakehouse1.
Each data pipeline takes 30 minutes to run. The data pipelines must run in numerical sequence based on their names. The end-to-end process must start every eight hours.
You need to configure orchestration to ensure that all the data pipelines run in the correct order. The solution must minimize the number of schedules and administrative effort.
What should you do?
Each data pipeline takes 30 minutes to run. The data pipelines must run in numerical sequence based on their names. The end-to-end process must start every eight hours.
You need to configure orchestration to ensure that all the data pipelines run in the correct order. The solution must minimize the number of schedules and administrative effort.
What should you do?
정답: D
You have a Fabric data warehouse that contains the following tables.
You need to refresh the tables by using an automated pipeline. The solution must ensure that table updates occur in the correct order to maintain referential integrity.
Which two tables should you refresh first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to refresh the tables by using an automated pipeline. The solution must ensure that table updates occur in the correct order to maintain referential integrity.
Which two tables should you refresh first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: B,D
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.
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.
정답:
Explanation:
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns.
You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: B,E,F
설명: (DumpTOP 회원만 볼 수 있음)
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.
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.
정답:
Explanation:
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 a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:
Does this meet the goal?
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 a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:
Does this meet the goal?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
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?
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?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have a Fabric workspace that contains a warehouse named Warehouse1 Warehousel contains a table named DimCustomers. DimCustomers contains the following columns:
* CustomerName
* CustomerlD
* Birth Date
* Email
You need to configure security to meet the following requirements:
* Birth Date in DimCustomer must be masked and display 1960-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.
* CustomerName
* CustomerlD
* Birth Date
You need to configure security to meet the following requirements:
* Birth Date in DimCustomer must be masked and display 1960-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.
정답:
Explanation:
