250+ TOP MCQs on Analyzing Data With Excel and Answers

SQL Server Multiple Choice Questions on “Analyzing Data With Excel”.

1. _____________ for Office is a lightweight set of tools for predictive analytics.
a) SQL Server 2008 Data Mining Add-ins
b) SQL Server 2012 Data Mining Add-ins
c) SQL Server 2014 Data Mining Add-ins
d) SQL Server 2012 Data Mining Excel

Answer: b
Clarification: SQL Server 2012 Data Mining Add-ins lets you use data in Excel to build analytical models for prediction, recommendation, or exploration.

2. 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

Answer: c
Clarification: 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.

3. _____________ allows you to analyze your spreadsheet data in powerful ways.
a) Data Mining Templates for Visio
b) Table Analysis Tools for Excel
c) Data Mining Client for Excel
d) All of the mentioned

Answer: b
Clarification: Table Analysis Tools for Excel is available in Data Mining Add-ins for Office 2007 package.

4. ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.
a) Analyze Key Influencers
b) Detect Categories
c) Fill From Example
d) None of the mentioned

Answer: a
Clarification: Analyze Key Influencers can analyze the factors that are key to determining which customers will spend the most money.

5. Point out the wrong statement.
a) The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories
b) The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values
c) The Detect categories tool predicts future values based on trends in existing time series data
d) All of the mentioned

Answer: c
Clarification: The Forecast tool predicts future values based on trends in existing time series data.

6. Fill From Example tool also produces a patterns report similar to ___________
a) Analyze Key Influencers
b) Detect Categories
c) Fill From Example
d) None of the mentioned

Answer: a
Clarification: Analyze Key Influencers tool describes the rules that were applied to fill in the missing values.

7. Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table?
a) Exceptions
b) Highlight
c) Scenario Analysis
d) Highlight Exceptions

Answer: d
Clarification: Highlight Exceptions not only highlights exception rows, but it also highlights the specific column value in each row that is likely to be the cause of the exception.

8. Scenario Analysis tool allows you to model _______ types of scenarios.
a) 2
b) 3
c) 4
d) 5

Answer: a
Clarification: Scenario Analysis tool report the effect on either a single row or the entire table of input data.

9. In order to use the Analyze in Excel feature, you must have ___________ installed on the system.
a) SSDT
b) SSMS
c) SSMA
d) None of the mentioned

Answer: a
Clarification: SQL Server Data Tools (SSDT) is a toolset that provides an integrated environment for database developers to carry out all their data analysis.

10. The _________ wizard helps you build a classification model based on existing data in an Excel table.
a) Associate
b) Classify
c) Estimate
d) Aggregate

Answer: b
Clarification: A classification model extracts patterns in your data that indicate similarities and helps you make predictions based on groupings of values.