QUESTION 3

You oversee a very large Sales database with a table named Transactions. You are asked to create an archiving solution where records with a TransactionDate older than three months can be removed from the table but still kept in the database where users can access them. What do you suggest?

		Partition the Transactions table. Create a separate ArchiveTransactions partitioned table. On a quarterly basis use SPLIT, SWITCH, and MERGE functions to archive the data.
		This cannot be done.
		Partition the transactions table. Create a separate ArchiveTransactions partitioned table. On a quarterly basis import the Transactions table into the ArchiveTransactions table.
		Create a copy of the current database every three months, and delete records older than three months in the original

QUESTION 4

You need to ensure that any data that is entered into the Salary column of the Employee table falls within a range from $15,000 to $150,000. What should you create?

		A Stored Procedure
		A DEFAULT
		A DDL TRIGGER
		A CHECK

QUESTION 5

You manage an SQL Server database named Hurricanes. It has a table of wind and temperature data by date and time and holds over 10 million rows. You are tasked with partitioning the data on a single server to increase performance and optimize maintenance. What should you do?

		Implement horizontal partitioning.
		Implement distributed partitioning.
		Implement a VIEW partition.
		Implement vertical partitioning.

QUESTION 6

You manage a database for an online retailer that has thousands of orders a day stored in an Orders table. The Orders table holds several years of data and has become quite slow. Is there any way to make it more efficient?

		No.
		Create a partition function that maps filegroups to files.
		Vertically partition the table.
		Create a partitioning scheme that partitions the data by date.

QUESTION 7

You manage a SQL Server database that contains a Customer table with a column named State. You need to ensure that only valid states are added. What's the best way to do this?

		Create a State table with valid entries. Configure a FOREIGN KEY on the State table pointing to the Customer table.
		Implement a DML TRIGGER that verifies the entered state against a list of valid states.
		Create a State table with valid entries. Configure a FOREIGN KEY on the Customer table pointing to the State table.
		Configure a DDL TRIGGER that verifies the entered state against a list of valid states.

QUESTION 9

You are asked to add two new columns to the Customers table named PreferredCustomer (bit) and PreferredCustomerDiscount (decimal). Any preferred customers (the PreferredCustomer bit is a 1) should automatically get a discount (defined in the PreferredCustomerDiscount column). Currently there aren't any PreferredCustomers identified. Preferred customers should automatically get a 10 percent discount. What should you do?

		Add the two columns with a default of. 10 for the PreferredCustomer and a default of 0 for the PreferredCustomerDiscount.
		Add the two columns with a default of . 10 for the PreferredCustomerDiscount and a default of 0 for the PreferredCustomer.
		Add the two columns with a default of. 10 for the PreferredCustomer and a default of 1 for the PreferredCustomerDiscount.
		Add the two columns with a default of . 10 for the PreferredCustomerDiscount and a default of I for the PreferredCustomer.