認証の方案はIT専門人員にもっと効率的に問題を解決する能力を備えさせます、その着眼点は取引先の実際の要求にあって、いくつかの具体的な製品の特性ではありません。ITマネージャー達もこの方案が持ってくるサービスの質と社員の生産効率を上げることから利益を収穫できます。以下は70-450 の問題集でございますみんなと一緒に勉強しましょう
1.You are a professional level SQL Sever 2008 Database Administrator in an international corporation named
Wiikigo. 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 included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are
stored in the column. The space utilized by the Profile column should be cut to the least. In addition, a
reasonable performance should be maintained to retrieve the content of the column. Which action will you
perform?
A.ROW compression should be utilized for the EmployeeData table.
B.The Profile column should be stored by utilizing filestream storage, and the NTFS file system
compression should be utilized.
C.PAGE LEVEL compression should be utilized for the EmployeeData table.
D.The Profile column should be implemented as a CLR user-defined type.
Answer:B
2.You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance should be managed.
It is reported by the customers that the server performance degraded due to a newly implemented
process. Dynamic Management Views is utilized to confirm that no long running queries exist. The
operating system performance data should be correlated with the actual query execution trace, and the
least administrative effort should be utilized. Which action will you perform to finish the task?
A.To finish the task, Data Collector should be utilized.
B.To finish the task, the SQLdiag.exe utility should be utilized.
C.To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
D.To finish the task, SQL Server Profiler and System Monitor should be utilized.
Answer:D
3.You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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. There is a database in the instance, and the day-to-day business of your company requires the
database. When reports are executed, slow response time will be experienced by Users. A performance
monitoring strategy will be implemented by you so as to have three aspects of data captured and stored:
Blocking and deadlock information, Executed Transact-SQL statements and query activity and Counters
for disk, CPU, and memory. You are required to utilize the least amount of administrative effort to
implement the monitoring process. Which action will you perform to finish the task?
A.To finish the task, the client-side profiler trace should be utilized.
B.To finish the task, the dynamic management views should be utilized.
C.To finish the task, the data collector should be utilized.
D.To finish the task, the System Monitor counter log trace should be utilized.
Answer:C
4.You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance should be managed
by you. The computer on which the instance run has the following three features: a 64-GB RAM, four
quad-core processors, and several independent physical raid volumes A transactional database will be
implemented on the instance. In addition, the database should have a high volume of INSERT, UPDATE,
and DELETE activities. Creation of new tables is contained by the activities. You need to maximize disk
bandwidth and decrease the contention in the storage allocation structures so as to have the performance
of the database optimized. Which action will you perform to finish the task?
A.To finish the task, database and log files should be placed on the same volume.
B.To finish the task, the affinity mask option should be configured properly.
C.To finish the task, multiple data files should be create for the database.
D.To finish the task, the affinity I/O mask option should be configured properly.
Answer:C