Questions and answers for exam Preparation

MCQs

Total Questions : 10

Question 1. 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

Discuss Question

Answer: Option C. -> Resource database is part of System database

Resource database is added to SQL Server 2012.

Question 2. 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

Discuss Question

Answer: Option B. -> Support for 32-bit and 64-bit processors

SQL Server 2008 R2 Datacenter provides the complete feature set available in SQL Server 2008.

Question 3. 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

Discuss Question

Answer: Option C. -> SQL Server books online needs to be downloaded separately

SQL Server Online 2008 books occupy 157 Mb.

Question 4. 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

Discuss Question

Answer: Option B. -> The Datacenter edition is priced at $11,990 per processor

The Datacenter edition is priced at $13,748 if you have Software Assurance (SA).

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

SSIS
SSAS
Client components
SSRS

Discuss Question

Answer: Option C. -> Client components

Client components does not include SSIS tools.

Question 6. 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

Discuss Question

Answer: Option D. -> In memory database

In-memory database capability is provided by 2012.

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

Discuss Question

Answer: Option D. -> All of the mentioned

These are minimum operating system requirements for the SQL Server 2014.

Question 8. 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

Discuss Question

Answer: Option B. -> Named Pipes

SQL Server Setup will block installations on read-only or compressed drives.

Question 9. Which is minimum processor speed for SQL Server 2012 ?

1.4 GHz
2.4 GHz
3.4 GHz
4.4 GHz

Discuss Question

Answer: Option A. -> 1.4 GHz

The minimum processing requirement is a 1.0GHz CPU for a 32-bit x86 implementation and a 1.4GHz CPU for a 64-bit x64 implementation. Microsoft's recommended minimum processor speed is 2.0GHz.

Question 10. The supported storage types for data files are :