nerdexam
Microsoft

70-467 · Question #53

You need to configure package execution logging to meet the requirements. What should you do?

The correct answer is B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance.. 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.

Design an ETL solution (Extract, Transform, and Load)

Question

You need to configure package execution logging to meet the requirements. What should you do?

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

How the community answered

(34 responses)
  • B
    94% (32)
  • D
    3% (1)
  • E
    3% (1)

Why each option

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.

AConfigure logging in each ETL package to log the OnError, Onlnformation, and

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.

BSet the SSIS catalog's Server-wide Default Logging Level property to Performance.Correct

The Performance logging level in the SSIS catalog records component-level pipeline execution statistics including rows processed, execution duration, and data flow engine counters, which satisfies requirements for performance monitoring. It provides substantially more diagnostic detail than Basic while avoiding the high storage and I/O cost of Verbose, making it the appropriate level for production performance tracking across all package executions.

CSet the SSIS catalog's Server-wide Default Logging Level property to Basic.

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.

DSet the SSIS catalog's Server-wide Default Logging Level property to Verbose.

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.

EConfigure logging in each ETL package to log the OnError, OnPreExecute, and

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

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

Topics

#SSIS logging#SSIS catalog#execution logging#logging level

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice