Implementing a Data Warehouse using SQL – Microsoft: 70-767 exam. Share the latest 70-767 dumps and Practice test questions for free. Real and effective exam questions and answers. 70-767 pdf online Download, Examthings share 40 Practice test questions for FREE! Get the full 70-767 exam dumps: https://www.leads4pass.com/70-767.html (Total questions:372 Q&A)
[PDF] Free Microsoft MCSA 70-767 pdf dumps download from Google Drive: https://drive.google.com/open?id=1NKCEjU9z6NU6YK89sShYlQZF0NCeVCH6
[PDF] Free Full Microsoft pdf dumps download from Google Drive: https://drive.google.com/open?id=1AwBFPqkvdpJBfxdZ3nGjtkHQZYdBsRVz
Exam 70-767: Implementing a Data Warehouse using SQL – Microsoft: https://www.microsoft.com/en-us/learning/exam-70-767.aspx
Latest effective Microsoft MCSA 70-767 Exam Practice Tests
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
Server 2008 R2 and SQL Server 2016.
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?
A. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
B. Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
C. Replace the SSIS Excel source with a SSIS Flat File source.
D. Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
Correct Answer: D
Explanation: XLSX files, the new file type in Excel 2007/2010 cannot be opened with Excel Source/Destination in SSIS.