184 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE
184 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE C. Disable the Enforce Relationship for INSERTs and DELETEs option to enable an AFTER TRIGGER to handle the necessary changes. D. Define an INSTEAD OF UPDATE TRIGGER to perform the necessary updates to all related tables. 3. A large organization needs to maintain IMAGE data on a database server. The data is scanned in from documents received from the federal government. Updates to the images are infrequent. When a change occurs, usually the old row of data is archived out of the system and the new document takes its place. Other column information that contains key identifiers about the nature of the document is frequently queried by an OLAP system. Statistical information on how the data was queried is also stored in additional columns. The actual document itself is rarely needed except in processes that print the image. Which of the following represents an appropriate storage configuration? A. Place the IMAGE data into a filegroup of its own, but on the same volume as the remainder of the data. Place the log onto a volume of its own. B. Place all the data onto one volume in a single file. Configure the volume as a RAID parity set and place the log into a volume of its own. C. Place the IMAGE onto one volume in a file of its own and place the data and log files together on a second volume. D. Place the IMAGE into a separate filegroup with the log on one volume and the remainder of the data on a second volume. 4. You are the administrator of a SQL Server 2000 computer. The server contains your company s Accounts database. Hundreds of users access the database each day. You have been experiencing power interruptions, and you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations. What should you do? A. Enable the torn page detection database option for each database. B. Disable write caching on all disk controllers. C. Create a database maintenance plan to check database integrity and make repairs each night. D. Ensure that the write caching disk controllers have battery backups. 5. An Internet company sells outdoor hardware online to over 100,000 clients in various areas of the globe. Servicing the web site is a SQL Server whose performance is barely adequate to meet the needs of the site. You would like to apply a business rule to the existing system that will limit the outstanding balance of each customer. The outstanding balance is maintained as a denormalized column within the customer table. Orders are collected in a second table containing a trigger that updates the customer balance based on INSERT, UPDATE, and DELETE activity. Up to this point, care has been taken to remove any data from the table if the client balance is too high, so all data should meet the requirements of your new process. How would you apply the new data check? A. Modify the existing trigger so that an order that allows the balance to exceed the limit is not permitted.
For high quality website hosting services please check java web hosting website.