When you create a temporal table in Azure SQL Database, it automatically creates a history table in the same database for capturing the historical records. Which of the following statements are true about the temporal table and history table? [Select all options that are applicable]

Answer options:

A.A temporal table must have 1 primary key.
B.To create a temporal table, System Versioning needs to be set to On.
C.To create a temporal table, System Versioning needs to be set to Off.
D.It is mandatory to mention the name of the history table when you create the temporal table.
E.If you don`t specify the name for the history table, the default naming convention is used for the history table.
F.You can specify the table constraints for the history table.

Correct Answers: A, B and E 
Here are some key points to note before creating the temporal table: A temporal table must have 1 primary key.
The period for system time must be defined with appropriate valid from and to fields with datetime2 datatype.
Set System Versioning to ON.
If you don`t specify the name for the history table, the default naming convention is used for the history table.
Other optional parameters such as data consistency check and retention period etc can be declared in the syntax; if needed.
The history table is page compressed.
 history table can’t have any table constraints.
Option A is correct. A temporal table must have 1 primary key.
Option B is correct. To create a temporal table, System Versioning needs to be set to On.
Option C is incorrect. To create a temporal table, System Versioning needs to be set to On, not Off.
Option D is incorrect. It is up to you to specify the name for the history table or not.
Option E is correct. If you don`t specify the name for the history table, the default naming convention is used for the history table.
Option F is incorrect. The history table can’t have any table constraints. Although you can create statistics or indexes to optimize the performance.
Reference: 
To know more about temporal tables, please visit the below-given link: 

https://visualbi.com/blogs/microsoft/azure/designing-slowly-changing-dimension-scd-azure-data-factory-using-sql-server-temporal-tables/