Question

Point out the correct statement.

(a) SSMS for Access converts Access database objects to SQL Server or SQL Azure database object

(b) Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab

(c) SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

(d) None of the mentioned

I have been asked this question at a job interview.

This question is from Access With Sql Server in portion Data Connectivity of SQL Server

Answer 1

Correct choice is (c) SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

For explanation I would say: SSMA loads those objects into SQL Server or SQL Azure, and then migrates data from Access to SQL Server or SQL Azure.