Microsoft
70-463 · Question #166
70-463 Question #166: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
Question
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012. The package fails when executed on the production server. You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal. What should you do?
Options
- AInstall a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
- BEnable Address Windowing Extensions (AWE) for the local SQL Server instance.
- CReplace the SSIS Excel source with a SSIS Flat File source.
- DInstall a 64-bit ACE driver and replace the Excel source with an OLE DB source.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.