You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

• A.an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse
• B.an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse
• C.an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse
• D.an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData that stores the following data.

You need to create a column named FirstPickupDateTime that will contain the first value of each hour from tpep_pickup_datetime partitioned by payment_type.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Row_Window_Session
Kusto, KQL Windowing Functions - Row_Window_Session
The row_window_session function can be used to group rows of data in a time range, and will return the starting time for that range of data in each row.
Box 2: !=
Here we are using an equation, which will compare the payment_type for the current row to the one of the previous row using the prev Windowing Function. If they are not equal, the comparison will return true and trigger Row_Window_Session to begin a Row_Window_Session grouping.

Comment: *

Name: *

Email: *

Verification: *

You are creating a semantic model in Microsoft Power Bl Desktop.
You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.
You need to save the semantic model to a file.
Which file format should you use?

• A.PBIP
• B.PBIX
• C.PBIT
• D.PBIDS

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains lakehouse named Lakehouse1. Lakehouse1 contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns.
You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements:
* Keep all the existing rows.
* Ensure that all the new data is added to the table.
How should you complete the code? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation:

o add new data to the Delta table while meeting the specified requirements:
You should use the append mode to ensure that all new data is added to the table without affecting the existing rows.
You should set the mergeSchema option to true to allow the schema of the Delta table to be updated with the new columns found in the DataFrame.
The completed code would look like this:
df.write.format( " delta " ).mode( " append " )
option( " mergeSchema " , " true " )
saveAsTable( " Lakehouse1.TableName " )

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a data pipeline.
You need to ensure that the pipeline runs every four hours on Mondays and Fridays.
To what should you set Repeat for the schedule?

• A.Daily
• B.By the minute
• C.Weekly
• D.Hourly

Comment: *

Name: *

Email: *

Verification: *