Question 1

Describe Enterprise, Standard, Datacenter, Azure and Parallel Data Warehouse 
editions of SQL Server available in the market.  Elaborate on the version, functions
and unique features. Draw a table to compare their attributes.     
        [25 marks]
 
Question 2

In a multi-national industry company’s yearly planning, as the data manager, you are
tasked to oversee the upgrade process of the company Database system.  

(a) List all the steps a database administrator (DBA) should take in order to 
Upgrading Database Engine to SQL server.                                          [15 marks] 

(b) Explain the purpose of running SQL Server Upgrade Advisor.            [10 marks]


Question 3

 
a) Describe in detail the new features of SQL Full Text Search.  Differentiate Fulltext
catalog
and
Full-text
Index.





Give
a
scenario
example
for
each
types
of
the
Full
Text
Search.

[10 marks]
 
b) Demonstrate the process of Full Text Catalog backing up and recovery.  Give
the detail snapshot of the process with the commands used 
[15 marks]
 

Question 4
 

 
a) Describe the importance of backup and provide a scenario to support your
description. 
[10 marks]
 
b) Compare and differentiate the three (3) recovery method used by SQL server. 
Draw a table to show their distinct models. 
[15 marks]