Question

Point out the correct statement.

(a) You cannot create and save connections to re-use data sources, repeat experiments, or re-train models

(b) The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007

(c) The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data

(d) None of the mentioned

I had been asked this question at a job interview.

This interesting question is from Analyzing Data With Excel in portion Business Intelligence of SQL Server

Answer 1

Right choice is (c) The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data

To elaborate: To use the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007, you must be connected to a SQL Server 2005 Analysis Services database.