SQL Server Mock Test 10

10%

Question 1 of 10

1. Which of the following holds temporary data?

Master

Tempdb

Msdb

Northwind

Question 1 of 10

Question 2 of 10

2. The _________ wizard helps you build a classification model based on existing data in an Excel table.

Associate

Aggregate

Estimate

Classify

Question 2 of 10

Question 3 of 10

3. The Schedule and Delivery Processing feature must be enabled through the ____________ property.

All of the mentioned

ScheduleEventsAndReportDelivery

ScheduleEventsDeliveryEnabled

ScheduleEventsAndReportDeliveryEnabled

Question 3 of 10

Question 4 of 10

4. By default, in a ________ schema, all attributes are directly related to the key attributes.

Snowflake

Star

None of the mentioned

Relational

Question 4 of 10

Question 5 of 10

5. __________ are portable, multipurpose items that contain ready-to-use schedule information.

Shared schedules

None of the mentioned

Report-specific schedule

File schedules

Question 5 of 10

Question 6 of 10

6. Which of the following is a feature of SQL Server 2008 R2 Datacenter?

All of the mentioned

Support for up to 256 logical CPUs

Support for 32-bit and 64-bit processors

StreamInsight Premium real-time event processing

Question 6 of 10

Question 7 of 10

7. An ___________ report is a fully paged report saved in a specific file format.

all of the mentioned

fully processed

compiled

exported

Question 7 of 10

Question 8 of 10

8. Point out the correct statement.

The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007

You cannot create and save connections to re-use data sources, repeat experiments, or re-train models

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 8 of 10

Question 9 of 10

9. If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?

Weight_Expression = <leaf cell value> / <existing value>

Weight_Expression = <leaf cell value> - <existing value>

Weight_Expression = <leaf cell value> * <existing value>

Weight_Expression = <leaf cell value> + <existing value>

Question 9 of 10

Question 10 of 10

10. Scenario Analysis tool allows you to model _______ types of scenarios.

Question 10 of 10