Module assessment

1.

You need to create a table to store user profile data that changes over time. You want to maintain a full history of changes without creating a separate history table manually. Which table type should you implement?

In-memory optimized table

Temporal table

Graph table

External table

2.

You need to design a table that will store product information. The ProductID must uniquely identify each row, and the Category must not allow null values. Which constraints should you implement?

PRIMARY KEY on ProductID and DEFAULT on Category

UNIQUE constraint on ProductID and CHECK constraint on Category

PRIMARY KEY on ProductID and NOT NULL on Category

FOREIGN KEY on ProductID and UNIQUE constraint on Category

3.

You have a large sales table with millions of rows. You want to improve query performance and maintenance by splitting the table data based on date ranges. Which feature should you implement?

Clustered index

JSON columns

Table partitioning

In-memory optimization

Feedback