70-463 Question #217: Real Exam Question with Answer & Explanation

The correct answer is A: An ODBC connection manager. SQL Server 2012 supports multiple connectivity standards, and SSIS provides corresponding connection managers for each. An OLE DB connection manager uses the native SQL Server OLE DB provider and is the most common way to connect to SQL Server. An ODBC connection manager uses DSN

Question

You need to extract data from a table in a SQL Server 2012 database. What connection manager types can you use? (Choose all that apply.)

Options

AAn ODBC connection manager
BAn OLE DB connection manager
CA File connection manager
DAn ADO.NET connection manager

Explanation

SQL Server 2012 supports multiple connectivity standards, and SSIS provides corresponding connection managers for each. An OLE DB connection manager uses the native SQL Server OLE DB provider and is the most common way to connect to SQL Server. An ODBC connection manager uses DSN or driver-based connectivity and also supports SQL Server. An ADO.NET connection manager uses the .NET SqlClient data provider and fully supports SQL Server. A File connection manager, however, is used to reference files or directories on the filesystem - it has no capability to connect to a database server or query a table. Therefore, A, B, and D are correct, and C is not.

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice