QUESTION 3 You oversee a very large Sales database with a table named Transactio

Question

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.

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

Explanation / Answer

SOLUTION:-

(3):- Partition the Transactions table. Create a separate ArchiveTransactions partitioned table. On a quarterly basis use SPLIT, SWITCH, and MERGE functions to archive the data.

Explanation:-SPLIT, SWITCH, and MERGE functions will be utilized on partitioned table with respect to managed archiving solution. Import the Transactions table into the ArchiveTransactions table will not delete the archive records. Create a copy of the current database will not work because data has to be kept in same database. So "Partition the Transactions table. Create a separate ArchiveTransactions partitioned table. On a quarterly basis use SPLIT, SWITCH, and MERGE functions to archive the data" is the correct answer.

(4):- A CHECK

Explanation:- A CHECK constraints will be utilized for examining the range. If a value is not given then default value will be used via A DEFAULT. A DDL TRIGGER can not examine the range data because it will be utilized only with CREATE, ALTER AND DROP. PK applies unique identifier constraint in a database table. So "A CHECK" is the correct answer.

(5):- Implement horizontal partitioning

Explanation:- horizontal partitioning will be implemented to isolate the longstanding,minimum utilized data in one table to a distinct table. vertical partitioning utilizes views for permitting the entrance with respect to the columns of select set. distinct partitioned tables grips on distinct servers via implementation of distributed partitioning. So "Implement horizontal partitioning" is the correct answer.

(6):- Create a partitioning scheme that partitions the data by date

Explanation:- via creating a partitioning scheme that partitions the data by date, we can store several years of data on distinct physical drive and recent data on small partition. Create a partition function will not work because it will generate the range and partitions will be mapped to filegroups via partition scheme.Vertically partition the table means construct a VIEW, that will not do the task. So "Create a partitioning scheme that partitions the data by date" is the correct answer.

(7):- Create a State table with valid entries. Configure a FOREIGN KEY on the Customer table pointing to the State table

Explanation:- Invalid data will not get in via configuration of a constraint. By Configure a FOREIGN KEY on the Customer table pointing to the State table, the verification of a state presence is done by SQL before permitting the data to get in. Triggers executes after the data is entered so it will not do the required task. So "Create a State table with valid entries. Configure a FOREIGN KEY on the Customer table pointing to the State table" is the correct answer.

(9):- Add the two columns with a default of . 10 for the PreferredCustomerDiscount and a default of 0 for the PreferredCustomer

Explanation:- PreferredCustomers are not identified so PreferredCustomers default will be set to 0. The identified customers will get a discount of 10% so PreferredCustomers discount will be set to .10.

================================================================

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.