Question 1 : The _________ wizard helps you build a classification model based on existing data in an Excel table.
1. Associate
2. Classify
3. Estimate
4. Aggregate
View Answer   Discuss with Members

Question 2 : In order to use the Analyze in Excel feature, you must have ___________ installed on the system.
1. SSDT
2. SSMS
3. SSMA
4. None of the mentioned
View Answer   Discuss with Members

Question 3 : Scenario Analysis tool allows you to model _______ types of scenarios.
1. 2
2. 3
3. 4
4. 5
View Answer   Discuss with Members

Question 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 ?
1. Exceptions
2. Highlight
3. Scenario Analysis
4. Highlight Exceptions
View Answer   Discuss with Members

Question 5 : Fill From Example tool also produces a patterns report similar to :
1. Analyze Key Influencers
2. Detect Categories
3. Fill From Example
4. None of the mentioned
View Answer   Discuss with Members

Question 6 : ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.
1. Analyze Key Influencers
2. Detect Categories
3. Fill From Example
4. None of the mentioned
View Answer   Discuss with Members

Question 7 : _____________ allows you to analyze your spreadsheet data in powerful ways.
1. Data Mining Templates for Visio
2. Table Analysis Tools for Excel
3. Data Mining Client for Excel
4. All of the mentioned
View Answer   Discuss with Members

Question 8 : _____________ for Office is a lightweight set of tools for predictive analytics.
1. SQL Server 2008 Data Mining Add-ins
2. SQL Server 2012 Data Mining Add-ins
3. SQL Server 2014 Data Mining Add-ins
4. SQL Server 2012 Data Mining Excel
View Answer   Discuss with Members

Question 9 : Which of the following statement is used to retrieve rows from the view ExecutionLog3 ?
1. select * from ExecutionLog3 order by TimeStart DESC
2. select * from ExecLog3 order by TimeStart DESC
3. select * from ExecutionLog4 order by TimeStart DESC
4. None of the mentioned
View Answer   Discuss with Members

Question 10 : The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.
1. FireEvent
2. FireEventdata
3. Eventdata
4. None of the mentioned
View Answer   Discuss with Members