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)

You work as the database administrator at 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_Products that contains 60 lookup tables. The lookup tables should remain static at all times and users should not be able to alter the static data. You discover that some of the data in the lookup tables have been altered. You need to ensure that users cannot change any of the data in the lookup tables.
What should you do?

You work as the database administrator at 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_Sales that stores sales data for the company.
You create a maintenance named JobA that is run manually by Domain.com users in the Sales department. A month later you become concerned that Sales department users may neglect running JobA and want determine when JobA was last run.
What should you do? (Each correct answer presents a complete solution. Choose two.)