70-450 무료 덤프문제 온라인 액세스

You administer a SQL Server 2008 instance.
Customers report server performance degradation because of a newly implemented process. You use Dynamic Management Views to verify that there are no long running queries.
You need to correlate the operating system performance data with the actual query execution trace by using minimum administrative effort.
What should you do?

• A.Use SQL Server Profiler and System Monitor.
• B.Use Data Collector.
• C.Use the SQLdiag.exe utility.
• D.Use SQL Server Profiler and the tracerpt.exe utility.

You are a professional level SQL Sever 2008 Database Administrator.
The security requirements should be designed for a new database application, and the application will be deployed to the instance. A table is consisted by the new database, and the table is created by utilizing the following code segment:
TABLE EmpBonusPlan
Since you are the technical support, you should utilize the maximum secure method to protect the BonusPlan column from the access of unauthorized users.
Which action will you perform to finish the task?

• A.To finish the task, the Trustworthy option for the database should be utilized.
• B.To finish the task, the Advanced Encryption Standard encryption should be utilized on all columns in the database.
• C.To finish the task, Transparent data encryption should be utilized.
• D.To finish the task, the NTFS file system security should be utilized and the access of the database files should be limited to the SQL Server 2008 Service account.

You administer a SQL Server 2008 infrastructure.
You plan to design a solution to obtain hardware configurations, such as the number of processors on a computer and the processor type of all SQL Server 2008 computers.
The solution must meet the following requirements:
It is hosted on the central computer.
It can verify hardware configurations for multiple servers.
You need to select a technology that meets the requirements by using the minimum amount of development effort.
What should you do?

• A.Define policies based on conditions by using the ExecuteSql function.
• B.Use the Windows Management Instrumentation (WMI) provider for the server events.
• C.Use the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
• D.Define policies based on conditions by using the ExecuteWQL function.

You are a professional level SQL Sever 2008 Database Administrator.
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 is 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
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 System Monitor counter log trace should be utilized.
• D.To finish the task, the data collector should be utilized.

You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

• A.Transparent data encryption
• B.Certificate-based encryption
• C.Asymmetric key encryption
• D.Symmetric key encryption