Olete.in – MCQs, Mock Tests & Government Job Prep | SSAS SQL Server Questions and Answers

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

1. exported
2. fully processed
3. compiled
4. All of the mentioned

✅ Correct Answer: 1

Which of the following is a list type in RDL with base 64 encoded value?

1. Boolean
2. Binary
3. Enum
4. Name

✅ Correct Answer: 2

Point out the wrong statement.

1. A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports
2. A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
3. A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
4. All of the mentioned

✅ Correct Answer: 2

You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.

1. Native, Sharepoint
2. Sharepoint, Native
3. Native, Native
4. Sharepoint, Sharepoint

✅ Correct Answer: 1

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

1. Report-specific schedule
2. Shared schedules
3. File schedules
4. None of the mentioned

✅ Correct Answer: 2

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

1. ScheduleEventsDeliveryEnabled
2. ScheduleEventsAndReportDeliveryEnabled
3. ScheduleEventsAndReportDelivery
4. All of the mentioned

✅ Correct Answer: 2

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

✅ Correct Answer: 1

Which of the following statement is used to retrieve rows from the view ExecutionLog3?

1. select * from ExecutionLog3 order by TimeStart DESC
2. elect * from ExecLog3 order by TimeStart DESC
3. select * from ExecutionLog4 order by TimeStart DESC
4. none of the mentioned

✅ Correct Answer: 1

__________ 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

✅ Correct Answer: 2

Point out the correct statement.

1. You cannot create and save connections to re-use data sources, repeat experiments, or re-train models
2. The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007
3. The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data
4. None of the mentioned

✅ Correct Answer: 3

_____________ 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

✅ Correct Answer: 2

_____ 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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

✅ Correct Answer: 4

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

1. 2
2. 3
3. 4
4. 5

✅ Correct Answer: 1

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

✅ Correct Answer: 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

✅ Correct Answer: 2

What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?

1. 811 Mb
2. 711 Mb
3. 611 Mb
4. 511 Mb

✅ Correct Answer: 2

Point out the correct statement.

1. SQL Server books online is part of Microsoft SQL Server
2. SQL Server books online is not a part of Microsoft SQL Server
3. SQL Server books online needs to be downloaded separately
4. None of the mentioned

✅ Correct Answer: 3

Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?

1. SSIS
2. SSAS
3. Client components
4. SSRS

✅ Correct Answer: 3

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

1. StreamInsight Premium real-time event processing
2. Support for 32-bit and 64-bit processors
3. Support for up to 256 logical CPUs
4. All of the mentioned

✅ Correct Answer: 2

Point out the wrong statement.

1. The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions
2. The Datacenter edition is priced at $11,990 per processor
3. There are several different editions of SQL Server
4. None of the mentioned

✅ Correct Answer: 2

Which of the following is not a feature of SQL Server 2008 R2 Enterprise?

1. Hot-add CPU
2. Hot-add RAM
3. Database partitioning
4. In memory database

✅ Correct Answer: 4

Which of the following operating system is Supported by IA-64 Edition?

1. Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
2. Windows Server 2003 SP2 64-bit x64 Datacenter
3. Windows Server 2003 SP2 64-bit x64 Enterprise
4. Windows Server 2003 SP2 64-bit x64 Standard

✅ Correct Answer: 1

What does the SQL Server setup program require?

1. Named Pipes
2. Shared Memory
3. Microsoft Windows Installer 4.5
4. All of the mentioned

✅ Correct Answer: 2

Which is the minimum processor speed for SQL Server 2008?

1. 1.4 GHz
2. 2.4 GHz
3. 3.4 GHz
4. 4.4 GHz

✅ Correct Answer: 1

The main memory requirements for SQL Server 2008 includes ___________

1. Minimum:512 MB
2. Minimum:1 GB
3. Maximum:252 MB
4. Maximum:512 MB

✅ Correct Answer: 1

What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?

1. 811 Mb
2. 711 Mb
3. 611 Mb
4. 511 Mb

✅ Correct Answer: 1

Point out the correct statement.

1. SQL Server books online is part of Microsoft SQL Server 2012
2. SQL Server books online is not a part of Microsoft SQL Server 2008
3. Resource database is part of System database
4. None of the mentioned

✅ Correct Answer: 3

. Which of the following is a feature of SQL Server 2014?

1. Column oriented database
2. Support for 32-bit and 64-bit processors
3. In memory database
4. All of the mentioned

✅ Correct Answer: 4

Point out the wrong statement related to SQL Server 2014.

1. SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine
2. SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments
3. SQL Server 2014 CTP 1 is only available in the English language
4. None of the mentioned

✅ Correct Answer: 4

Which of the following is a feature of SQL Server 2012 R2 Enterprise?

1. In memory database
2. Hot-add RAM
3. Database partitioning
4. All of the mentioned

✅ Correct Answer: 4

Which of the following is a feature of SQL Server 2012 R2 Enterprise?

1. In memory database
2. Hot-add RAM
3. Database partitioning
4. In memory database b) Hot-add RAM c) Database partitioning d) All of the mentioned

✅ Correct Answer: 4

Which of the following operating system is supported by SQL Server 2014?

1. Windows Server 2012
2. Windows 8 RTM
3. Windows Vista SP2
4. All of the mentioned

✅ Correct Answer: 4

Which of the following component is not installed by SQL Server setup 2012 required by the product?

1. NET Framework 3.5 SP11
2. Named Pipes
3. SQL Server Setup support files
4. All of the mentioned

✅ Correct Answer: 2

Which is the minimum processor speed for SQL Server 2012?

1. 1.4 GHz
2. 2.4 GHz
3. 3.4 GHz
4. 4.4 GHz

✅ Correct Answer: 1

The supported storage types for data files are ___________

1. RAM
2. Hard Storage
3. SMB File Share
4. None of the mentioned

✅ Correct Answer: 3

🧪 SSAS MCQ Quiz Hub

SQL Server Questions and Answers – Analysis Services Set 2