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]
