Get Microsoft DP-203 Exam Dumps

Answer : A, B

Answer : B

According to Microsoft Purview Data Catalog lineage user guide1, data lineage in Microsoft Purview is a core platform capability that populates the Microsoft Purview Data Map with data movement and transformations across systems2.Lineage is captured as it flows in the enterprise and stitched without gaps irrespective of its source2.

Answer : D

Tumbling window self-dependency properties

In scenarios where the trigger shouldn't proceed to the next window until the preceding window is successfully completed, build a self-dependency. A self-dependency trigger that's dependent on the success of earlier runs of itself within the preceding hour will have the properties indicated in the following code.

Example code:

'name': 'DemoSelfDependency',

'properties': {

'runtimeState': 'Started',

'pipeline': {

'pipelineReference': {

'referenceName': 'Demo',

'type': 'PipelineReference'

}

},

'type': 'TumblingWindowTrigger',

'typeProperties': {

'frequency': 'Hour',

'interval': 1,

'startTime': '2018-10-04T00:00:00Z',

'delay': '00:01:00',

'maxConcurrency': 50,

'retryPolicy': {

'intervalInSeconds': 30

},

'dependsOn': [

{

'type': 'SelfDependencyTumblingWindowTriggerReference',

'size': '01:00:00',

'offset': '-01:00:00'

}

]

}

}

}

Answer : B, D

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching

Answer : B

Need a minimum 1 million rows per distribution. Each table is 60 distributions. 30 millions rows is added each month. Need 2 months to get a minimum of 1 million rows per distribution in a new partition.

Note: When creating partitions on clustered columnstore tables, it is important to consider how many rows belong to each partition. For optimal compression and performance of clustered columnstore tables, a minimum of 1 million rows per distribution and partition is needed. Before partitions are created, dedicated SQL pool already divides each table into 60 distributions.

Any partitioning added to a table is in addition to the distributions created behind the scenes. Using this example, if the sales fact table contained 36 monthly partitions, and given that a dedicated SQL pool has 60 distributions, then the sales fact table should contain 60 million rows per month, or 2.1 billion rows when all months are populated. If a table contains fewer than the recommended minimum number of rows per partition, consider using fewer partitions in order to increase the number of rows per partition.

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition