Microsoft
70-463 · Question #241
70-463 Question #241: Real Exam Question with Answer & Explanation
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.
Explanation
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.
Common mistakes.
- A. 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.
- B. 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.
- D. 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
Reference. https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services
Community Discussion
No community discussion yet for this question.