Explanation/Reference:
Explanation:
A partitioned view is a view defined by a UNION ALL of member tables structured in the same way, but
stored separately as multiple tables in either the same instance of SQL Server or in a group of autonomous
instances of SQL Server servers, called federated database servers.
Conditions for Creating Partitioned Views Include:
The select list

All columns in the member tables should be selected in the column list of the view definition.

The columns in the same ordinal position of each select list should be of the same type, including
collations. It is not sufficient for the columns to be implicitly convertible types, as is generally the case for
UNION.
Also, at least one column (for example <col>) must appear in all the select lists in the same ordinal
position. This <col> should be defined in a way that the member tables T1, ..., Tn have CHECK constraints
C1, ..., Cn defined on <col>, respectively.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql
Recent Comments (The most recent comments are at the top.)
@Arnold Nowak, its not exactly the same question. Pay attention for last requirement on TBL2, its different. I am not sure for answers in both cases, BTW :/
The same question with different answer:
https://www.freecram.com/question/Microsoft.70-762.v2019-06-21.q78/note-this-question-is-part-of-a-series-of-questions-that-use-the-same-or-similar-answer-choices-as