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.
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)- A3% (1)
- B6% (2)
- C88% (29)
- D3% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.