70-463 · Question #217
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.)
The correct answer is A. An ODBC connection manager B. An OLE DB connection manager D. An ADO.NET 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
How the community answered
(45 responses)- A93% (42)
- C7% (3)
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.
Topics
Community Discussion
No community discussion yet for this question.