You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include the administration of a SQL Server 2005 database named Certkiller -DB02.
Certkiller -DB02 hosts a database named CK_Sales that stores sales transactions for the company. Domain.com wants to provide customers real-time delivery tracking information using data retrieved from Certkiller -DB02 and data from a parcel tracking Web service provided by a third party. You need to ensure that the real-time tracking information is current when queries are executed. You need to create the appropriate objects that support the queries.
What should you do?

You work as a database administrator at Domain.com. Your duties at Domain.com encompass administrating a SQL Server computer named Certkiller -DB03.
You have received instruction from the CIO to retrieve data concerning a user who is currently logged in on Certkiller -DB03. You create a function that returns scalar information about the activity time for a particular user.
What should you do? (Choose all that apply)

You work as the database administrator for an IT training company named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Training that stores training data for the company. You are instructed to create checklists that lecturers can use to prepare training courses. You must use information from text files stored on Certkiller -DB01’s hard disk drive to create the checklists for the different certifications that Domain.com offers training for. You want to use Visual Studio .NET 2005 to build the checklists by implementing a common language runtime (CLR) function.
What should you do?

You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB06.
Certkiller -DB06 hosts a database that contains a trigger named trg_InsertOrders. The trigger, trg_InsertOrders is configured to fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You want to use the minimum amount of administrative effort to configure the trigger to prevent it from firing during the data import process? Which of the following Transact-SQL statements can be used? (Each answer presents a complete solution. Choose TWO.)

Diagram:-
Column name Type

ClientID int

CompanyName varchar(50)

FirstName varchar(20)

LastName varchar(20)

Picture varbinary(max)

Address1 varchar(30)

Address2 varchar(30)

City varchar(30)

StateProvince char(2)

PostalCode varchar(10)

CountryCode char(2)
You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB01.
Certkiller -DB01 contains a table named CK_Clients. The CK_Clients table comprises of the columns that are illustrated in the diagram. You have received instruction from the CIO to create a view named v_Client by using the following Transact-SQL statement:
CREATE VIEW v_ClientASSELECT ClientID, CompanyName, FirstName, LastName,
PictureFROM Clients
You want to create an index on the v_Client view.
You need to modify the Transact-SQL statement before he creates the index. What actions should you execute? (Choose all that apply)

You work as a database administrator at Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB03. You have received instruction from the CIO to create a view to join the Customers and Orders tables in Certkiller -DB03. You make sure that the view cannot be affected by modifications to underlying table schemas. You need to accomplish this objective by using the minimal amount of overhead.
How can you accomplish this?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com encompass administrating SQL Server 2005 database named Certkiller -DB08.
You have received instruction from the CIO to implementing a series of views that are used in ad hoc queries. The views are used to put into effect the Domain.com security policy of abstracting data. You notice that some of these views perform slowly therefore you create indexes on those views to increase the performance. You do this whilst maintaining the company’s security policy. The current date is returned by one of the views as one of the columns. The current date returned by the view is returned by using the GETDATE() function. This view does not permit you to create an index. You need to create an index on the view. What actions should you execute? (Choose all that apply)

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include maintaining a SQL Server 2005 database named Certkiller -DB06.
Analysts in the Sales department of Domain.com usually make use of a view named v_ClientSales to join the Clients and the Sales tables in the Certkiller -DB06. The analysts make use of this view to combine the total sales by clients per month. You want to increase the performance of the view.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com encompass administrating SQL Server 2005 database named Certkiller -DB08.
You have received instruction from the CIO to implementing a series of views that are used in ad hoc queries. The views are used to put into effect the Domain.com security policy of abstracting data. You notice that some of these views perform slowly therefore you create indexes on those views to increase the performance. You do this whilst maintaining the company’s security policy. The current date is returned by one of the views as one of the columns. The current date returned by the view is returned by using the GETDATE() function. This view does not permit you to create an index. You need to create an index on the view.
What should you do? (Choose all that apply)

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administration of a SQL Server 2005 database named Certkiller -DB01.
Certkiller -DB01 stores line items from the sales transactions from clients. The sales department processes 50,000 transactions daily. You have been informed by the CIO that the application requires a clustered index on the TransactionID column. You create a table that will support an efficient reporting solution that queries the transactions by date.
How can you accomplish this? (Choose all that apply)