최신Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu - 070-450무료샘플문제
문제1
You are a professional level SQL Sever 2008 Database.
A new database application is hosted by the instance. The security requirements should be designed for the application. A unique login to the SQL Server 2008 server is assigned to each application user. Stored procedures are included by the application database to execute stored procedures in the MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be executed by utilizing the security context of the application user.
Which action should you perform?
You are a professional level SQL Sever 2008 Database.
A new database application is hosted by the instance. The security requirements should be designed for the application. A unique login to the SQL Server 2008 server is assigned to each application user. Stored procedures are included by the application database to execute stored procedures in the MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be executed by utilizing the security context of the application user.
Which action should you perform?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
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?
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?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
You are a professional level SQL Sever 2008 Database Administrator.
You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining
the
database life cycle. In the company, your job is to implement solutions on security, troubleshooting,
deployment
and optimization. A SQL Server 2008 infrastructure is managed by you.
A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000
transactions
are processed by the application every minute. A column is contained by a table in the database, and the
column is
utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored
with the
highest security level. In addition, the least amount of memory space and processor time should be
utilized.
From the following four encryption types, which one should you utilize?
You are a professional level SQL Sever 2008 Database Administrator.
You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining
the
database life cycle. In the company, your job is to implement solutions on security, troubleshooting,
deployment
and optimization. A SQL Server 2008 infrastructure is managed by you.
A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000
transactions
are processed by the application every minute. A column is contained by a table in the database, and the
column is
utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored
with the
highest security level. In addition, the least amount of memory space and processor time should be
utilized.
From the following four encryption types, which one should you utilize?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
You are a professional level SQL Sever 2008 Database Administrator.
All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented.
The business requirements listed below should be satisfied:
Point-in-time recovery for failure is supported by the backup strategy at any time of day.
The least amount of disk space should be utilized by the transaction log.
Which action should you perform to finish the task?
You are a professional level SQL Sever 2008 Database Administrator.
All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented.
The business requirements listed below should be satisfied:
Point-in-time recovery for failure is supported by the backup strategy at any time of day.
The least amount of disk space should be utilized by the transaction log.
Which action should you perform to finish the task?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
You administer a SQL Server 2008 instance.
The instance hosts a database that contains sensitive data. You plan to implement a database backup strategy for the database.
You need to ensure that all backups of the database are encrypted. You also need to prevent unauthorized access of the backups.
What should you do?
You administer a SQL Server 2008 instance.
The instance hosts a database that contains sensitive data. You plan to implement a database backup strategy for the database.
You need to ensure that all backups of the database are encrypted. You also need to prevent unauthorized access of the backups.
What should you do?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
You are a professional level SQL Sever 2008 Database Administrator.
A large financial database is hosted by the instance. The backup strategies listed below are contained by
the database:
First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day.
Thirdly, the performance of a transaction log backup is implemented every hour.
An end-of-year batch process should be implemented, and the process takes two hours to run.
About five percent of data within the database will be changed by the batch process.
Since you are the technical support, you are required to make sure that the batch operation can be rolled
back
in the shortest time, if the batch process is not approved by the Finance department.
What should you do first before start the batch process?
You are a professional level SQL Sever 2008 Database Administrator.
A large financial database is hosted by the instance. The backup strategies listed below are contained by
the database:
First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day.
Thirdly, the performance of a transaction log backup is implemented every hour.
An end-of-year batch process should be implemented, and the process takes two hours to run.
About five percent of data within the database will be changed by the batch process.
Since you are the technical support, you are required to make sure that the batch operation can be rolled
back
in the shortest time, if the batch process is not approved by the Finance department.
What should you do first before start the batch process?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
You are a professional level SQL Sever 2008 Database Administrator.
A new database should be deployed, and the capacity requirements listed below should be satisfied.
There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports
RAID levels 0, 1, 5, and 10.
Since you are the technical support, you are required to maximize the write performance of the transaction
log. In addition, you should protect the database and transaction log files,
when a drive fails.
The storage system should be designed.
From the following four storage configuration, which one should you utilize?
You are a professional level SQL Sever 2008 Database Administrator.
A new database should be deployed, and the capacity requirements listed below should be satisfied.
There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports
RAID levels 0, 1, 5, and 10.
Since you are the technical support, you are required to maximize the write performance of the transaction
log. In addition, you should protect the database and transaction log files,
when a drive fails.
The storage system should be designed.
From the following four storage configuration, which one should you utilize?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제8
You administer a SQL Server 2008 infrastructure.
You implement log shipping for several databases on three SQL Server instances. The logs are shipped to a fourth SQL Server instance. You plan a manual failover.
You need to ensure that the database applications use the secondary server after failover. You also need to ensure that users can access the most recent data.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
You administer a SQL Server 2008 infrastructure.
You implement log shipping for several databases on three SQL Server instances. The logs are shipped to a fourth SQL Server instance. You plan a manual failover.
You need to ensure that the database applications use the secondary server after failover. You also need to ensure that users can access the most recent data.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
정답: C,D,E
설명: (KoreaDumps 회원만 볼 수 있음)