Weekend Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric DP-700 Question # 14 Topic 2 Discussion

Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric DP-700 Question # 14 Topic 2 Discussion

DP-700 Exam Topic 2 Question 14 Discussion:
Question #: 14
Topic #: 2

You have an Azure SQL database named DB1. The data in DB1 is appended daily.

You have a Fabric workspace named Workspace1 that contains a semanlk model named Model!. Modell is sourced from DB1. You need to configure Model1 to refresh only new and changed data during scheduled refreshes What should you do?


A.

In Model1, manually partition large tables by using monthly partitions.


B.

For Model1, change storage mode to Import


C.

From Power Query, define the RangeStart and RangeEnd parameters and filter table rows by using the parameters.


D.

For Workspace1, select Large semantic model storage format


Get Premium DP-700 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.