Note: This question is part of a series of questions that use the same or similar answer choices. An
answer choice may be correct for more than one question in the series. Each question is independent
of the other questions in this series. Information and details provided in a question apply only to that
question.
You create a table by running the following Transact-SQL statement:
You need to audit all customer data.
Which Transact-SQL statement should you run?
A.
B.
C.
D.
E.
F.
G.
H.
Explanation:
The FOR SYSTEM_TIME ALL clause returns all the row versions from both the Temporal and History table.
Note: A system-versioned temporal table defined through is a new type of user table in SQL Server 2016, here
defined on the last line WITH (SYSTEM_VERSIONING = ON…, is designed to keep a full history of data
changes and allow easy point in time analysis.
To query temporal data, the SELECT statement FROM<table> clause has a new clause FOR SYSTEM_TIME
with five temporal-specific sub-clauses to query data across the current and history tables.
https://msdn.microsoft.com/en-us/library/dn935015.aspx
b