🧪 SSAS MCQ Quiz Hub

1. An ___________ report is a fully paged report saved in a specific file format. a)
exported
fully processed
compiled
All of the mentioned

2. Which of the following is a list type in RDL with base 64 encoded value?
Boolean
Binary
Enum
Name

3. Point out the wrong statement.
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
A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
All of the mentioned

4. You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.
Native, Sharepoint
Sharepoint, Native
Native, Native
Sharepoint, Sharepoint

5. ____ are portable, multipurpose items that contain ready-to-use schedule information.
Report-specific schedule
Shared schedules
File schedules
None of the mentioned

6. The Schedule and Delivery Processing feature must be enabled through the ____________ property.
ScheduleEventsDeliveryEnabled
ScheduleEventsAndReportDeliveryEnabled
ScheduleEventsAndReportDelivery
All of the mentioned

7. 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.
FireEvent
FireEventdata
Eventdata
None of the mentioned

8. Which of the following statement is used to retrieve rows from the view ExecutionLog3?
select * from ExecutionLog3 order by TimeStart DESC
elect * from ExecLog3 order by TimeStart DESC
select * from ExecutionLog4 order by TimeStart DESC
none of the mentioned

9. __________ 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

10. 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

11. _____________ 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

12. _____ 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

13. Fill From Example tool also produces a patterns report similar to ________
Analyze Key Influencers
Detect Categories
Fill From Example
None of the mentioned

14. 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

15. Scenario Analysis tool allows you to model _______ types of scenarios.
2
3
4
5

16. In order to use the Analyze in Excel feature, you must have ___________ installed on the system.
SSDT
SSMS
SSMA
None of the mentioned

17. The _________ wizard helps you build a classification model based on existing data in an Excel table.
Associate
Classify
Estimate
Aggregate

18. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?
811 Mb
711 Mb
611 Mb
511 Mb

19. Point out the correct statement.
SQL Server books online is part of Microsoft SQL Server
SQL Server books online is not a part of Microsoft SQL Server
SQL Server books online needs to be downloaded separately
None of the mentioned

20. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?
SSIS
SSAS
Client components
SSRS

21. Which of the following is a feature of SQL Server 2008 R2 Datacenter?
StreamInsight Premium real-time event processing
Support for 32-bit and 64-bit processors
Support for up to 256 logical CPUs
All of the mentioned

22. Point out the wrong statement.
The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions
The Datacenter edition is priced at $11,990 per processor
There are several different editions of SQL Server
None of the mentioned

23. Which of the following is not a feature of SQL Server 2008 R2 Enterprise?
Hot-add CPU
Hot-add RAM
Database partitioning
In memory database

24. Which of the following operating system is Supported by IA-64 Edition?
Windows Server 2003 R2 SP2 64-bit Itanium Datacenter
Windows Server 2003 SP2 64-bit x64 Datacenter
Windows Server 2003 SP2 64-bit x64 Enterprise
Windows Server 2003 SP2 64-bit x64 Standard

25. What does the SQL Server setup program require?
Named Pipes
Shared Memory
Microsoft Windows Installer 4.5
All of the mentioned

26. Which is the minimum processor speed for SQL Server 2008?
1.4 GHz
2.4 GHz
3.4 GHz
4.4 GHz

27. The main memory requirements for SQL Server 2008 includes ___________
Minimum:512 MB
Minimum:1 GB
Maximum:252 MB
Maximum:512 MB

28. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?
811 Mb
711 Mb
611 Mb
511 Mb

29. Point out the correct statement.
SQL Server books online is part of Microsoft SQL Server 2012
SQL Server books online is not a part of Microsoft SQL Server 2008
Resource database is part of System database
None of the mentioned

30. . Which of the following is a feature of SQL Server 2014?
Column oriented database
Support for 32-bit and 64-bit processors
In memory database
All of the mentioned

31. Point out the wrong statement related to SQL Server 2014.
SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine
SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments
SQL Server 2014 CTP 1 is only available in the English language
None of the mentioned

32. Which of the following is a feature of SQL Server 2012 R2 Enterprise?
In memory database
Hot-add RAM
Database partitioning
All of the mentioned

33. Which of the following is a feature of SQL Server 2012 R2 Enterprise?
In memory database
Hot-add RAM
Database partitioning
In memory database b) Hot-add RAM c) Database partitioning d) All of the mentioned

34. Which of the following operating system is supported by SQL Server 2014?
Windows Server 2012
Windows 8 RTM
Windows Vista SP2
All of the mentioned

35. Which of the following component is not installed by SQL Server setup 2012 required by the product?
NET Framework 3.5 SP11
Named Pipes
SQL Server Setup support files
All of the mentioned

36. Which is the minimum processor speed for SQL Server 2012?
1.4 GHz
2.4 GHz
3.4 GHz
4.4 GHz

37. The supported storage types for data files are ___________
RAM
Hard Storage
SMB File Share
None of the mentioned