This is open question and answers will vary but the candidate might say ETL (SSIS), Data Warehouse and Cubes (SSAS) and Reporting (SSRS). This list can be longer and can include data mining, master data management, data profiling, data cleansing, analysis and data gathering also can be added here.