BenchMark Quizzes by MDFT Pro

Choose Tools for Dataset Processing

You work for MDFT Pro, a well-known training agency that offers certification preparation courses worldwide. Mark, the Database Administrator, is planning to process a dataset containing student enrollment records that need to be loaded into a Fabric warehouse.

Each enrollment record must have a unique identifier that automatically increments, starting from 1 and incrementing by 1 for each new record. This primary key will be used to link enrollments to other tables in the data warehouse. Mark wants to use built-in Fabric functionality to automatically generate these sequential identifiers without writing custom code, minimizing development effort and ensuring data integrity.

The solution should leverage native database features for generating unique, sequential primary keys during the data loading process.

What should Mark use to process the dataset?

Choose the correct answer from the options below.

Explanations for each answer:

A T-SQL statement is correct. T-SQL is the best choice because it provides built-in IDENTITY column support for auto-incrementing integer primary keys starting from 1 with an increment of 1. This minimizes development effort by using native database functionality without requiring custom code.
A Dataflow Gen2 dataflow is incorrect. Dataflow Gen2 is designed for data transformation using Power Query and doesn't natively support automatic generation of sequential integer primary keys. Implementing this functionality would require additional custom logic and increase development effort.
A Notebook is incorrect. While notebooks can generate sequential primary keys using PySpark, this requires writing custom code. T-SQL provides built-in IDENTITY column functionality that requires less development effort.
A KQL Queryset is incorrect. KQL (Kusto Query Language) is designed for real-time analytics on streaming data in eventhouses, not for managing structured tables with primary key constraints. It doesn't provide the necessary functionality for creating auto-incrementing primary keys.

Learn more about IDENTITY columns in Fabric:

IDENTITY Columns in Fabric

Practice Exam

Choose Tools for Dataset Processing

Discuss this question on social media: