nerdexam
Microsoft

70-463 · Question #241

Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases. You need that the business applications can access c

The correct answer is C. SQL Server Integration Services (SSIS). SSIS provides the ETL pipeline needed to extract data from source databases, apply validation and transformation logic, and deliver curated data that business applications can consume.

Configure and deploy SSIS solutions

Question

Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases. You need that the business applications can access curated and validated data from the databases. Which features should you deploy to the server?

Options

  • AData Quality Services (DQS)
  • BSQL Server Analysis Services (SSAS) dimension hierarchies.
  • CSQL Server Integration Services (SSIS)
  • DMaster Data Services (MDS) subscriptions.

How the community answered

(33 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    88% (29)
  • D
    3% (1)

Why each option

SSIS provides the ETL pipeline needed to extract data from source databases, apply validation and transformation logic, and deliver curated data that business applications can consume.

AData Quality Services (DQS)

Data Quality Services provides a rule-based engine for cleansing and matching data, but it is not an integration platform for extracting, transforming, and delivering operational data from multiple databases to business applications.

BSQL Server Analysis Services (SSAS) dimension hierarchies.

SSAS dimension hierarchies are OLAP modeling constructs used for analytical reporting and cube processing, not a mechanism for providing transactional or curated operational data to line-of-business applications.

CSQL Server Integration Services (SSIS)Correct

SQL Server Integration Services is the SQL Server ETL platform specifically designed to extract data from multiple source databases and apply transformation and data validation logic in a managed pipeline. The resulting clean, curated data is loaded to destination tables or views that line-of-business applications can query directly. This makes SSIS the appropriate feature for the requirement of providing curated and validated data access across multiple applications from a shared server.

DMaster Data Services (MDS) subscriptions.

MDS subscriptions publish master data changes to subscribing systems as part of master data governance workflows, but MDS is not a general-purpose data integration platform for serving curated data to line-of-business applications.

Concept tested: SSIS as ETL platform for curating application data

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

Topics

#SSIS#DQS#MDS#SQL Server features

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice