Question

Point out the wrong statement.

(a) SQL Server Migration Assistant is an environment that helps you quickly migrate Access databases to SQL Server or SQL Azure

(b) By using SSMA, you can review Access and SQL Server or SQL Azure database objects

(c) When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata

(d) None of the mentioned

This question was posed to me during an interview.

I would like to ask this question from Access With Sql Server in section Data Connectivity of SQL Server

Answer 1

Right choice is (c) When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata

The explanation is: Jet database engine stores connection information and table metadata.