70-450
QUESTION 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
Explanation/Reference:
Much of the data that is created every day is unstructured data, such as text documents, im
ages, and videos. This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management complexities. Or, if the data is associated with structured storage, the file streaming capabilities and performance can be limited.
FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data.
FILESTREAM uses the NT system cache for caching file data. This helps reduce any effect that FILESTREAM data might have on Database Engine performance. The SQL Server buffer pool is not used; therefore, this memory is available for query processing.
微软数据库认证
Note:
FILESTREAM data is not encrypted even when transparent data encryption is enabled.
QUESTION 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, utility should be utilized.
C.
To finish the task, SQL Server Profiler and utility should be utilized.
D.
To finish the task, SQL Server Profiler and System Monitor should be utilized.
Answer: D
Explanation/Reference:
SQL Server profiler displays data about a large number of SQL Server events. Whereas Windows System Monitor graphically displays information about the server internals. You can merge the two sets of information and walk through a scenario viewing both perspectives using SQL Server Profiler.


To set up the dual-perspective experience, you need to simultaneously capture server performance using both Performance Monitor’s Counter Logs and SQL Server Profiler. The steps to do this are listed below:
1. Configure System Monitor with the exact counters you want to view later. Be sure to get the scale and everything just right. Set up the Counter Log to the exact same configuration.
2. Configure Profiler with the right set of trace events. They must include the start and end time data columns so that Profiler can integrate the two logs later. Save the profiler and close profiler.
3. Manually start the Counter Log. Open SQL Profiler trace code to start the server-side trace.
4. When the test is complete, stop both the counter Log and the server side trace. You need to stop the SQL Profiler which is a negative point in this.
5. Open profiler and open the saved trace file.
6. Use the File->Import Performance Data menu command to import the Counter Log. You have the option of selecting only the important counters from the performance monitor. There will be performance issues if you select too many counters.

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。