Relativity Infrastructure Specialist Exam 10.1 Study
Resources with verified answers passed
1. How do you setup an Index Opti- There are 10 steps:
mize Script- SQL Server 1. Login to SQL MGMT Studio with Windows
mainte- nance plan? Authentication.
2. Click the (+) to expand the Management
section.
3. Right-click, select Maintenance Plans | New
Maintenance Plan.....
4. Include the Execute T-SQL Statement Task. If you
don't see this option, you can find it under View |
Toolbox.
5. Right-click, select Execute T-SQL Statement Task
| Edit...
6. Paste in the Index Optimize SQL script. This
script is available on the Relativity Community
Portal
7. Create a schedule for the new maintenance
plan.
8. Schedule the maintenance plan to run nightly.
9. Save the maintenance plan and create an
2. What allows the Database
identical job on any Distributed Relativity SQL
En- gine to recognize that
servers.
this ad hoc batch has
10. Check the maintenance plan. Right-click on it and
been previously compiled,
select View History to see how long it takes to
but has only stored a
complete in your environment. Additionally, include
compiled plan stub?
the Notify Operator Task to notify via email of job
3. Which statement is executed completion or failure.
to enable the optimize for
ad hoc workloads option The compiled plan stub
on each SQL instance?
1/
10
, Relativity Infrastructure Specialist Exam 10.1 Study
Resources with verified answers passed
P_CONFIGURE 'show advanced options',1 SP_CONFIGURE 'optimize for ad hoc workloads',1
RECONFIGURE GO RECONFIGURE GO
4. What is parallelism? Parallelism is the number of processor cores
employed to
run a single statement for each parallel plan
execution.
2/
10
Resources with verified answers passed
1. How do you setup an Index Opti- There are 10 steps:
mize Script- SQL Server 1. Login to SQL MGMT Studio with Windows
mainte- nance plan? Authentication.
2. Click the (+) to expand the Management
section.
3. Right-click, select Maintenance Plans | New
Maintenance Plan.....
4. Include the Execute T-SQL Statement Task. If you
don't see this option, you can find it under View |
Toolbox.
5. Right-click, select Execute T-SQL Statement Task
| Edit...
6. Paste in the Index Optimize SQL script. This
script is available on the Relativity Community
Portal
7. Create a schedule for the new maintenance
plan.
8. Schedule the maintenance plan to run nightly.
9. Save the maintenance plan and create an
2. What allows the Database
identical job on any Distributed Relativity SQL
En- gine to recognize that
servers.
this ad hoc batch has
10. Check the maintenance plan. Right-click on it and
been previously compiled,
select View History to see how long it takes to
but has only stored a
complete in your environment. Additionally, include
compiled plan stub?
the Notify Operator Task to notify via email of job
3. Which statement is executed completion or failure.
to enable the optimize for
ad hoc workloads option The compiled plan stub
on each SQL instance?
1/
10
, Relativity Infrastructure Specialist Exam 10.1 Study
Resources with verified answers passed
P_CONFIGURE 'show advanced options',1 SP_CONFIGURE 'optimize for ad hoc workloads',1
RECONFIGURE GO RECONFIGURE GO
4. What is parallelism? Parallelism is the number of processor cores
employed to
run a single statement for each parallel plan
execution.
2/
10
