You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com hosts an online analytical processing (OLAP) system for a customer. The customer requested that Domain.com provide data transformation and load support. They prefer the data load to be schedules to occur at noon every day. You need to accommodate this customer.
What should you do?
A.
Create an Integration Services package to provide data transformation and load support.
Run the package using the D T ExecUI command.
B.
Create an Integration Services package to provide data transformation and load support.
Run the package using SQL Server Agent.
C.
Create an Integration Services package to provide data transformation and load support.
Run the package using SQL Server Import and Export Wizard.
D.
Create an Integration Services package to provide data transformation and load support.
Run the package using Business Intelligence Development Studio.
Explanation:
The SQL Server Integration Services (SSIS) will meet the requirements. It is a platform for data integration and workflow solutions. It can be used to extract the data from the purchased lists, transform the data as required, validate against the Customers table, and load the data into the Contacts table. Further you need to make use of SQL Server Agent to run the package by creating a SQL Server Agent job and then executing the package as a job step. SQL Server Agent jobs can be scheduled for execution. This includes the ability to schedule recurring execution.
Incorrect Answers:
A: This is possible, but the DT ExecUI command does not make provision for scheduling recurring execution.
C: Though is it possible to make use of SQL Server Import and Export Wizard, it does not allow one to schedule recurring execution.
D: Though is it possible to make use of Business Intelligence Development Studio, it does not allow one to schedule recurring execution.