Microsoft 70-767 Online Practice Questions and Exam Preparation

Microsoft 70-767 Online Questions & Answers

• Question 401:

  You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2016. The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter. You need to create a solution to meet the requirements by using the least amount of administrative effort.

  What should you do?

  A. Add a SQLMOBILE connection manager to each package.
  B. Add an ADO.NET project connection manager.
  C. Add a SQLMOBILE project connection manager.
  D. Add an ADO.NET connection manager to each data flow task.
  E. Add a SQLMOBILE connection manager to each data flow task.
  F. Add an ADO.NET connection manager to each package.
  B. Add an ADO.NET project connection manager.

  ---

  Ref: http://www.databasejournal.com/features/mssql/windows-azure-sql-database- uploading-data-by-using-sql-server-integration-services.html

• Question 402:

  A SQL Server Integration Services (SSIS) 2016 package currently downloads sales data from a Windows Azure SQL Database database.

  To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma- separated values (CSV) file that contains one row per currency.

  You need to download the CSV file to the environment.

  What should you use to retrieve the document from the website?

  A. a Script component
  B. a Web Service task
  C. a Web Service source
  D. a Script task
  D. a Script task