Choose DP-700 most accurate study material

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?

• A. " @{pipeline().parameters.paraml}-
• B. " @{pipeline().parameters.[paraml]} "
• C. " @{pipeline().parameters.paraml} "
• D. " @pipeline(). parameters. paraml "

DRAG DROP
You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData.
The following is a sample of the data in TaxiData.

You need to build two KQL queries. The solution must meet the following requirements:
One of the queries must partition RunningTotalAmount by VendorID.
The other query must create a column named FirstPickupDateTime that shows the first value of each hour from tpep_pickup_datetime partitioned by payment_type.
How should you complete each query? 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.

You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on- premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

• A. a Dataflow Gen1 dataflow
• B. a data pipeline
• C. a notebook
• D. a KQL queryset

You have a Microsoft Power Apps app named App1 that has data stored in Microsoft Dataverse. You need to access the App1 data by using Fabric. What should you use?

• A. a data pipeline
• B. Dataflow Gen2
• C. a shortcut
• D. mirroring

You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains the following columns that store string values:
* FirstName
* Phone
* Email
You have two Microsoft Entra security groups named Group1 and Group2. The members of both groups can query Table1 and see full values for FirstName, Phone, and Email.
You need to configure Table1 to meet the following requirements:
. The members of Group1 must see masked values for Phone, showing only the last three characters of each phone number.
. The Group1 members must see unmasked values for FirstName.
. The members of Group2 must see unmasked values for all the columns.
. The solution must use Fabric warehouse-supported permissions and T-SQL.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.