Passing exam with 70-450 latest training materials

You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database.
The database uses the simple-recovery model.
The database contains the following three additional filegroups:
FileGroupA that is read/write
FileGroupB that is read-only
FileGroupC that is read-only
FilegroupB contains less critical data than FilegroupC.
You discover that the PRIMARY filegroup and FileGroupB have failed.
You need to recover the database in the minimum possible time. You also need to ensure that
data is available as soon as possible.
What should you do?

• A. Perform a full database restore.
• B. Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupC, and then perform an online restore of FileGroupB.
• C. Perform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
• D. Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupB, and then perform an online restore of FileGroup

You administer a SQL Server 2008 infrastructure.
The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports.
You plan to design a performance monitoring strategy that captures and stores the following data:
Executed Transact-SQL statements and query activity.
Blocking and deadlock information.
Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort.
What should you do?

• A. Use the System Monitor counter log trace.
• B. Use the client-side profiler trace.
• C. Use the dynamic management views.
• D. Use the data collector

You are a professional level SQL Sever 2008 Database Administrator.
Log shipping should be implemented for several databases on three SQL Server instances. The logs are
migrated
to a fourth SQL Server instance. A manual failover will be implemented.
You need to ensure that the database applications utilize the secondary server after failover.
Since you are the technical support, you are required to confirm that the latest data should be available to
users.
Which actions should you perform to achieve the goal? (Choose more than one)

• A. To achieve the goal, you should utilize the WITH RECOVERY option on the last log to apply any unapplied transaction log backups in sequence to each secondary database.
• B. To achieve the goal, you should redirect client computers to the secondary instance.
• C. To achieve the goal, you should back up all databases on the secondary instance.
• D. To achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail of the transaction log of primary databases.
• E. To achieve the goal, you should replicate all log shipping network shares to the secondary instance.

You are a professional level SQL Sever 2008 Database Administrator.
A database is hosted by the instance, and sensitive data is included in the database.
A database backup strategy will be implemented for the database.
You need to have all backups of the database encrypted.
The backups should not be accessed by unauthorized users.
Which action will you perform?

• A. Windows BitLocker Drive Encryption technology should be utilized.
• B. The BACKUP statement should be utilized along with the PASSWORD option.
• C. The BACKUP statement should be utilized along with the MEDIAPASSWORD option.
• D. Transparent database encryption should be utilized.

You are a professional level SQL Sever 2008 Database Administrator.
The security requirements should be designed for a new database application. A code segment is utilized by the application, and the code segment includes the following components:
A method that the registry is accessed on the SQL Server
A method that the file system is accessed on a network file server
A class definition that public static fields are utilized
SQL CLR integration is utilized by the code segment
The code segment is implemented as a single assembly.
Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.
Which action will you perform?

• A. All public static fields should be replaced with public fields.
• B. The SAFE code access security should be utilized for the assembly.
• C. All public static fields should be utilized with public static read-only fields. And then the assembly should be registered by utilizing the regasm.exe utility before deployment.
• D. All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.