Answer Q no 2

Answer Q no 2

Correct Answer:

INSERT dbo.mytable (col1, col2) VALUES (‘Test’, ‘Test2’), (‘Test3’, ‘Test4’), (‘test5’, ‘test6’);

You can use the Transact-SQL row constructor (also called a table value constructor) to specify multiple rows in a single INSERT statement. The row constructor consists of a single VALUES clause with multiple value lists enclosed in parentheses and separated by a comma. For more information, see Table Value Constructor (Transact-SQL).

Back to Question

Question no 2

Question no 2

In SQL Server 2008 R2, if I want to insert multiple rows in one statement, which format should I use?

1. INSERT dbo.mytable (col1, col2) VALUES (‘Test’, ‘Test2’), (‘Test3’, ‘Test4’), (‘test5’, ‘test6’);

2. INSERT dbo.mytable (col1, col2) SELECT (‘Test’, ‘Test2’), (‘Test3’, ‘Test4’), (‘test5’, ‘test6’);

3. INSERT dbo.mytable (col1, col2) VALUES ((‘Test’, ‘Test2’), (‘Test3’, ‘Test4’), (‘test5’, ‘test6’));

4. INSERT dbo.mytable (col1, col2) VALUES [(‘Test’, ‘Test2’), (‘Test3’, ‘Test4’), (‘test5’, ‘test6’)];

Go To The Answer

Answer Q no 1

Answer Q no 1

Correct Answer:
Enable backup compression, Create a user that is classified into a limited CPU workload group in Resource Governor.

Enable backup compression –> To reduce the disk space used for backup operations.

Create a user that is classified into a limited CPU workload group in Resource Governor –> minimize the impact to your production systems’ performance when performing backups

By default, backing up using compression significantly increases CPU usage, and the additional CPU consumed by the compression process can adversely impact concurrent operations.

Therefore, you might want to create a low-priority compressed backup in a session whose CPU usage is limited by Resource Governor when CPU contention occurs.

Back to Question

Question no 1

Question no 1

You would like to reduce the disk space used for backup operations on your SQL Server 2008 R2 databases. You also want to minimize the impact to your production systems’ performance when performing backups. Which two of the following items should you perform to meet these requirements? (select 2)

1. Enable backup compression

2. Add the WITH LOW_PRIORITY option to your backup command

3. Create a user that is classified into a limited CPU workload group in Resource Governor

4. Create a user that is classified into a limited I/O workload group in Resource Governor

Go To The Answer