nerdexam
Microsoft

70-463 · Question #101

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project…

The correct answer is B. Create an Integration Services catalog. The Project Deployment Model in SSIS 2012 requires an Integration Services catalog (SSISDB) to store packages, parameters, environments, and execution logs on the SQL Server instance.

Configure and deploy SSIS solutions

Question

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?

Options

  • ACreate SSIS configuration files for the packages.
  • BCreate an Integration Services catalog.
  • CInstall Data Quality Services.
  • DInstall Master Data services.

How the community answered

(60 responses)
  • A
    2% (1)
  • B
    90% (54)
  • C
    5% (3)
  • D
    3% (2)

Why each option

The Project Deployment Model in SSIS 2012 requires an Integration Services catalog (SSISDB) to store packages, parameters, environments, and execution logs on the SQL Server instance.

ACreate SSIS configuration files for the packages.

SSIS configuration files (.dtsconfig or XML) are associated with the older Package Deployment Model, not the Project Deployment Model, and do not support Integration Services environment variables.

BCreate an Integration Services catalog.Correct

Creating an Integration Services catalog provisions the SSISDB database on the SQL Server instance, which is the mandatory server-side infrastructure for the Project Deployment Model. Without SSISDB, projects using parameters and environment variable references cannot be deployed or executed on the server. The catalog also provides the stored procedures and views used to manage environments, configure parameter mappings, and monitor executions.

CInstall Data Quality Services.

Data Quality Services is a separate SQL Server component for data cleansing and matching and has no role in deploying or executing SSIS packages.

DInstall Master Data services.

Master Data Services provides master data management capabilities and is entirely unrelated to SSIS package deployment infrastructure.

Concept tested: SSIS Project Deployment Model and Integration Services catalog setup

Source: https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog

Topics

#SSIS catalog#project deployment model#environment variables#configuration

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice