SQL Server Questions and Answers – Analyzing Data With Excel

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses 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
View Answer

Answer: b
Explanation: 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
View Answer

Answer: c
Explanation: 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
View Answer

Answer: b
Explanation: 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
View Answer

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

advertisement
advertisement

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
View Answer

Answer: c
Explanation: 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
View Answer

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

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

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
View Answer

Answer: d
Explanation: 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
View Answer

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

advertisement

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
View Answer

Answer: a
Explanation: 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
View Answer

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

advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.