70-467 Question #53: Real Exam Question with Answer & Explanation

Question

Options

• AConfigure logging in each ETL package to log the OnError, Onlnformation, and
• BSet the SSIS catalog's Server-wide Default Logging Level property to Performance.
• CSet the SSIS catalog's Server-wide Default Logging Level property to Basic.
• DSet the SSIS catalog's Server-wide Default Logging Level property to Verbose.
• EConfigure logging in each ETL package to log the OnError, OnPreExecute, and

Explanation

Setting the SSIS catalog Server-wide Default Logging Level to Performance captures pipeline execution statistics and data flow metrics centrally without incurring the overhead of Verbose logging.

Common mistakes.

• A. Configuring per-package logging for OnError and OnInformation events requires modifying every individual package and does not utilize the centralized catalog-level logging capability that the requirement implies.
• C. The Basic logging level records only high-level execution start and end events, which is insufficient for capturing the component-level performance metrics needed for meaningful performance analysis.
• D. The Verbose logging level captures all events including row-level operations, generating excessive data volume and I/O overhead that makes it impractical and disproportionate for standard performance monitoring.
• E. Configuring per-package logging for OnError and OnPreExecute requires modifying each package individually and does not deliver the centralized, catalog-wide performance data that the requirement targets.

Concept tested. SSIS catalog server-wide default logging level configuration

Reference. https://learn.microsoft.com/en-us/sql/integration-services/performance/integration-services-ssis-logging

No community discussion yet for this question.