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

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