You want to check all the data blocks being written to the d

You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.

The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.

You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.

You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.

You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.

What should you do?

A．Select the commit on successful completion check box of the DTS package.

B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.

C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.

D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.

You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of documents.

You configure the new high-priority printer and want to set permissions for the groups shown in the exhibit. Note: The default settings have been cleared.

You select the check box to allow Print permission for the Executives group. You want only the Administrators, Print Operators, Server Operators, and Executives group to be able to print to the printer. What can you do? (Select all that apply).

A．Remove the Everyone group.

B．Select the check box to deny Print permission for the Everyone group.

C．Select the check box to deny Manage Documents permission for Everyone group.

D．Select all Deny check boxes for the Everyone group.

E．Clear all check boxes for Everyone group.

A. ALTER DISKGROUP data CHECK;

B. ALTER DISKGROUP data CHECK DISK;

C. ALTER DISKGROUP data CHECK FILE;

D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

A. The distribution of data written across all the memory DIMMs and the L1 cache

B. The distribution of data written across all the memory DIMMs in one bank

C. The distribution of data written across all the memory DIMMs and the processor

D. The distribution of data written across all the memory DIMMs and the L2 cache

You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.

You want to minimize changes to your security model and to your database applications. How should you modify the database?

A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.

B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.

C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.

D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.

A. Both tables have NULL values.

B. You want all unmatched data from one table.

C. You want all matched data from both tables.

D. You want all unmatched data from both tables.

E. One of the tables has more data than the other.

F. You want all matched and unmatched data from only one table.