26.
The STUDENTS table contains name, address, and contact information for students at a
local college. Columns include Student_Name, DOB, Telephone, Email, Street_Address,
Town, State, and Zip Code. IDX1 is an index on the Student_Name column. Given this information, which of the following statements will provide the greatest reduction in the amount of space required to store data for the STUDENTS table?
- A.ALTER TABLE STUDENTS REBUILD WITH (DATA_COMPRESSION=ROW)
- B.ALTER TABLE STUDENTS REBUILD WITH (DATA_COMPRESSION=PAGE)
- C.ALTER INDEX IDX1 ON STUDENTS REBUILD PARTITION ALL WITH (DATA_COMPRESSION=ROW)
- D.ALTER INDEX IDX1 ON STUDENTS REBUILD PARTITION ALL WITH (DATA_COMPRESSION=PAGE)
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect. Implementing page-level compression will provide a greater reduction
in the amount of space used than implementing row-level compression will, given
the properties of the table. B. Correct. Unless the table data is unique, page-level compression provides the greatest compression but has a cost in CPU usage. C. Incorrect. In this case, compressing the index using row compression will not provide the space savings that compressing the entire table will. D. Incorrect. In this case, compressing the index using page compression will not provide the space savings that compressing the entire table will. |
27.
Which of the following must you do before enabling Transparent Data Encryption for a
database? (Each correct answer presents part of the complete solution. Choose three.)
- A.Create a master encryption key.
- B.Create a certificate.
- C.Create a database encryption key.
- D.Enable page-level compression.
- Answer & Explanation
- Report
Answer : [A, B, C]
Explanation :
Explanation :
|
A. Correct. You must create a master encryption key prior to enabling TDE on a
database. B. Correct. You must create a certificate prior to enabling TDE on a database. C. Correct. You must create a database encryption key prior to enabling TDE on a database. D. Incorrect. You do not need to enable page-level compression prior to enabling TDE on a database. |
28.
Which command would you run if you wanted to check the physical and logical integrity
of all objects within a specific database?
- A.DBCC CHECKFILEGROUP
- B.DBCC CHECKDB
- C.DBCC SQLPERF
- D.DBCC SHRINKDATABASE
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect. DBCC CHECKFILEGROUP verifies the allocation and structural integrity
of indexed views and tables for a specific filegroup but not for the entire database. B. Correct. DBCC CHECKDB checks the physical and logical integrity of all objects within a specific database. C. Incorrect. DBCC SQLPERF provides transaction log space statistics. D. Incorrect. DBCC SHRINKDATABASE shrinks the size of all data and log files for the specified database. |
29.
Which of the following can you upgrade to SQL Server 2012 Standard edition without
having to apply additional service packs? (Each correct answer presents a complete
solution. Choose all that apply.)
- A.SQL Server 2005 SP4 Standard edition installed on Windows Server 2008 with Service Pack 2
- B.SQL Server 2008 SP2 Standard edition installed on Windows Server 2003 R2
- C.SQL Server 2008 SP2 Enterprise edition installed on Windows Server 2008 R2 SP1
- D.SQL Server 2008 R2 SP1 Standard edition installed on Windows Server 2008 R2 SP1
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: You can upgrade SQL Server 2005 SP4 to SQL Server 2012 if the host
operating system is running Windows Server 2008 with Service Pack 2. B. Incorrect: You cannot install SQL Server 2012 on a computer running the Windows Server 2003 R2 operating system. C. Incorrect: You cannot upgrade the Enterprise edition of SQL Server 2008 with Service Pack 2 to the Standard edition of SQL Server 2012. You can upgrade it to the Enterprise or Business Intelligence editions. D. Correct: You can upgrade SQL Server 2008 R2 SP1 Standard edition to SQL Server 2012 Standard edition on a host running Windows Server 2008 R2 SP1. |
30.
To which of the following editions and versions of SQL Server 2012 can you upgrade
SQL Server 2008 R2 Datacenter edition (x64)? (Each correct answer presents a complete
solution. Choose all that apply.)
- A.SQL Server 2012 Enterprise edition (x86)
- B.SQL Server 2012 Enterprise edition (x64)
- C.SQL Server 2012 Business Intelligence edition (x64)
- D.SQL Server 2012 Standard edition (x64)
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
|
A. Incorrect: You cannot upgrade an x64 version of SQL Server 2008 R2 to an x86
version of SQL Server 2012. B. Correct: You can upgrade the Datacenter edition of SQL Server 2008 R2 to the Enterprise edition of SQL Server 2012 if they share the same processor architecture. C. Correct: You can upgrade the Datacenter edition of SQL Server 2008 R2 to the Business Intelligence edition of SQL Server 2012 if they share the same processor architecture. D. Incorrect: You cannot upgrade the Datacenter edition of SQL Server 2008 R2 to the Standard edition of SQL Server 2012. |
|
|
||||||||||||||||||||||||||||
