Question 1 : The supported storage types for data files are :
1. RAM
2. Hard Storage
3. SMB File Share
4. None of the mentioned
View Answer   Discuss with Members

Question 2 : 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
View Answer   Discuss with Members

Question 3 : 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
View Answer   Discuss with Members

Question 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
View Answer   Discuss with Members

Question 5 : 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
View Answer   Discuss with Members

Question 6 : 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
View Answer   Discuss with Members

Question 7 : Which components of SQL Server 2014 require 1182 Mb ?
1. SSIS
2. SSAS
3. Client components
4. SSRS
View Answer   Discuss with Members

Question 8 : 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
View Answer   Discuss with Members

Question 9 : 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
View Answer   Discuss with Members

Question 10 : Which is minimum processor speed for SQL Server 2008 ?
1. 1.4 GHz
2. 2.4 GHz
3. 3.4 GHz
4. 4.4 GHz
View Answer   Discuss with Members