You should do some research to try and understand. Us answering these questions for an interview doesn't help you or an employer. If you have specific questions on any of...

Congrats!

You'd need a way to measure the disk udsage for all VMs/processes at the same time. When you have a hypervisor in the way, it's possible that other processes are...

When you RDP, you have a Windows login. A SQL login, or that Windows Login needs to be added to the instnace.

We don't work from screenshots. That's a cumbersome way for us to examine data and test queries.

Read the link in Thom's signature and post DDL for tables and...

You could take the projects and data from these series:
http://www.sqlservercentral.com/stairway/72494/
http://www.sqlservercentral.com/stairway/72382/

What is missing here? What don't you see? What do you not understand about the lists? You've given some requirements (though not the results you expect given that data) and...

We are happy to help, but not do the work for you. What have you done?  There are some questions and notes in the post in the T-SQL forum.

Closing. Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Closing: Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Merry Christmas and Happy Holidays.  Everyone be safe and enjoy time with loved ones.

http://www.sqlservercentral.com/articles/T-SQL/71571/

with cmn as (
select
  a.a
from TableA a
inner join TableB b on a.a = b.a and a.b =...

Double check that the remote is running and listening on 1433. Check the errorlog.

The driver for connection is generic. 2014 should connect to 2016. Maybe try using the...

You might try grouping on the ID and ordering by the index, but as Thom noted, your description doesn't quite make sense.