Is it possible to insert into two tables at the same time? SQL Server Interview Question

SQL Server Interview Question: Is it possible to insert into two tables at the same time?

In one statement: No.
In one transaction: Yes
BEGIN TRANSACTION
   DECLARE @DataID int;
   INSERT INTO DataTable (Column1 ...) VALUES (....);
   SELECT @DataID = scope_identity();
   INSERT INTO LinkTable VALUES (@ObjectID, @DataID);
COMMIT