Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

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» C. Estimate
Discussion
2.

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» B. SSMS
Discussion
3.

Scenario Analysis tool allows you to model _______ types of scenarios?

A. 2
B. 3
C. 4
D. 5
Answer» B. 3
Discussion
4.

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» E.
Discussion
5.

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» B. Detect Categories
Discussion
6.

___________ 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» B. Detect Categories
Discussion
7.

_____________ 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» C. Data Mining Client for Excel
Discussion
8.

_____________ 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» C. SQL Server 2014 Data Mining Add-ins
Discussion