gs gs116 Business Intelligence - Analyzing Data With Excel - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Business Intelligence. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: _____________ for Office is a lightweight set of tools for predictive analytics.
SQL Server 2008 Data Mining Add-ins
SQL Server 2012 Data Mining Add-ins
SQL Server 2014 Data Mining Add-ins
SQL Server 2012 Data Mining Excel
Question 2: Point out the correct statement.
You cannot create and save connections to re-use data sources, repeat experiments, or re-train models
The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007
The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data
None of the mentioned
Question 3: _____________ allows you to analyze your spreadsheet data in powerful ways.
Data Mining Templates for Visio
Table Analysis Tools for Excel
Data Mining Client for Excel
All of the mentioned
Question 4: ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.
Analyze Key Influencers
Detect Categories
Fill From Example
None of the mentioned
Question 5: Point out the wrong statement.
The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories
The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values
The Detect categories tool predicts future values based on trends in existing time series data
All of the mentioned
Question 6: Fill From Example tool also produces a patterns report similar to ___________
Analyze Key Influencers
Detect Categories
Fill From Example
None of the mentioned
Question 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?
Exceptions
Highlight
Scenario Analysis
Highlight Exceptions
Question 9: In order to use the Analyze in Excel feature, you must have ___________ installed on the system.
SSDT
SSMS
SSMA
None of the mentioned
Question 10: The _________ wizard helps you build a classification model based on existing data in an Excel table.
Associate
Classify
Estimate
Aggregate
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
