What should you do?
You are hired as a database consultant at Domain.com. The Domain.com network contains a SQL Server database server named Certkiller -DB01. Certkiller -DB01 host a database named CK_Sales that stores line items from Domain.com’s online sales transactions. Domain.com processes about 40,000 transactions every day. An application that processes the sales transactions requires a clustered index on a column named TransID.
You need to create a table that supports an efficient reporting solution that queries the transactions by date.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
What actions should you execute?
You are employed as a database administrator at Domain.com. Your duties at Domain.com encompass administrating a SQL Server 2005 database named Certkiller -DB03.
The Domain.com Web site has a page for clients to send the comments about its products and the company. You received instruction from the CIO to use Certkiller -DB03 to store the comments in the Comments column of a table named CKFeedback. You implement full-text searching in order to run reports on the comments.
What actions should you execute? (Choose all that apply)
What statement should you use?
You work as the database developer for Domain.com. The Domain.com network contains a database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. Domain.com Sales Representatives should be allowed to check the current commissions due to them.
You need to optimize the indexing strategies for the CK_Sales database. You need to design the indexes for the Orders table. The following query is frequently executed, though it is not the most commonly executed query.
SELECT Salesrepresentative, SUM(Commission)
FROM Orders
WHERE Date BETWEEN @startDate AND @endDate
GROUP BY Salesrepresentative
ORDER BY Salesrepresentative
You need to use the appropriate statement to create the best index to accommodate this query.
What statement should you use?
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 include managing the database schema for an order entry application in a SQL Server 2005 database named Certkiller -DB04. A Domain.com employee named Mia Hamm works is part of the design review committee. Mia Hamm requests that a new column named CK_Commission to the CK_Product table. The actual commission rates for the products are not known at present. Therefore, every product has a default commission rate of 10 percent. The table allows you to modify the rate if required. You have received instruction from the CIO to add the new column.
You need to configure the table to assign the default value as efficiently as possible.
What should you do?
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 include administrating a SQL Server 2005 database named Certkiller -DB04. You have received instruction from the CIO that Certkiller -DB04 will support a new Web-based application. This Web-based application will handle approximately 1,500 users simultaneously. The application must display the results of calculation-intensive operations like calculating the instalment and amortization schedules as quick as possible.
What should you do?
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 include administrating a SQL Server 2005 database named Certkiller -DB04. It has come to your attention that schema changes were made on Certkiller -DB04. Due to these changes on Certkiller -DB04 your Web site stopped functioning. It is however unclear who made the changes. You have received mandate from the CIO that all changes to the database schema be tracked.
What should you do?
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. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Your duties include administrating Certkiller -DB01. Certkiller -DB01 is hosting Domain.com’s commercial Web sites. You are creating a database on Certkiller -DB01 to support a new Web-based application that will handle up to 2,000 simultaneous users. The application that will access this database must quickly display the results of calculation-intensive operations. You need to ensure that the database processes calculations as quickly and efficiently as possible.
What should you do?
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 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?
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)
What should you do?
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?