Exam 70-761 topic 1 question 139 discussion

Actual exam question from Microsoft's 70-761

Question #: 139
Topic #: 1

You have a database named DB1 that contains a temporal table named Sales.Customers.
You need to create a query that returns the credit limit that was available to each customer in DB1 at the beginning of 2017.
Which query should you execute?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: B
AS OF: Returns a table with a rows containing the values that were actual (current) at the specified point in time in the past.
Incorrect Answers:
A, B: CONTAINED IN has two parameters: CONTAINED IN (<start_date_time> , <end_date_time>)
References:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/querying-data-in-a-system-versioned-temporal-table

by Anette at May 30, 2020, 7:49 p.m.