Exam 70-767 topic 1 question 79 discussion

Actual exam question from Microsoft's 70-767

Question #: 79
Topic #: 1

HOTSPOT -
You are a data warehouse developer.
You need to create a Microsoft SQL Server Integration Services (SSIS) catalog on a production SQL Server instance.
Which features are needed? To answer, select the appropriate options in the answer area.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Yes -
"Enable CLR Integration" must be selected because the catalog uses CLR stored procedures.

Box 2: Yes -
Once you have selected the "Enable CLR Integration" option, another checkbox will be enabled named "Enable automatic execution of Integration Services stored procedure at SQL Server startup". Click on this check box to enable the catalog startup stored procedure to run each time the SSIS server instance is restarted.

Box 3: No -
References:
https://www.mssqltips.com/sqlservertip/4097/understanding-the-sql-server-integration-services-catalog-and-creating-the-ssisdb-catalog/

by Slava_bcd81 at Oct. 8, 2020, 9:56 a.m.

Comments

Submit Cancel

mate_farkas

4 years, 5 months ago

Task mentions "Automatic SSIS Package Execution" but this is not a name of a feature or setting of SSIS. The screenshot show an option "automatic execution of Integration Services stored procedure", which is a different thing.

upvoted 1 times

...

Lukis92

4 years, 6 months ago

The instruction relates to indicating features needed to CREATE an SSIS catalog. "To create and use the catalog only CLR integration must be enabled ." -Yes -No -No An "Automatic SSIS Package Execution" is not needed to create a catalog. Tested locally and only was required CLR and password.

upvoted 1 times

...

Slava_bcd81

4 years, 8 months ago

-Yes -No (the feature is optional) -No

upvoted 3 times

kimalto452

4 years, 7 months ago

But you need it...

upvoted 1 times

...