Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance Set 7

You are managing a SQL Server 2008 instance for Company.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure shouldbe deployed which contains the Microsoft Clustering mining model. From Scalable K-Means to Non- scalable K-Means. You should alter the attribute of the mining model. Which is the correct answer?

You are managing a SQL Server 2008 sample which includes a database called Tester for the Company.com. There is a table named Production which owns a clustered primary key called ProductID on the ProductID column in the database and a single XML column called ProductXml which stores XML data. On the same XML column, there is an XML index. you increase a new column called ProductName to the Production table. You should make ProductId primary key. Which is the correct answer?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There is a text file named SQL.log on the E: drive. The job logs information to the text file. You get a report from users saying that the server doesn't make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn't function any longer. As the IT support, you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?

You are managing a SQL Server 2008 instance for Company.com.In order to clarify whether a database integrity check (DBCC CHECKDB) was implemented for a special database. Which is the correct answer?

You are managing a SQL Server 2008 instance for Company.com.A SQL Server Agent job runs each 4 minutes. The job logs information to a text file called Tester1.log exists on the F: drive. Users tell you that the server is not running normally. The questions are listed below:The SQL Server Agent job no longer functions.The SQL Server Agent service does not implement. You should make sure that you could find out the result of the SQL Server Agent service lost. Which is the correct answer?

You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory utilization. The network should be considered. the detailed information should be checked for the proper example of SQL Server2008.Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for Company.com. On the Products database, logged operations are executed. You should make sure that the database could be recovered to a special point in time. Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for Company.com. You have logged shipping the Products database to a remote SQL Server 2008 example. On Monday, the primary SQL Server instance required a restart. You find out that log shipping has stopped working after Monday. Youshould make sure that you could troubleshoot log shipping of the Products database. Which is the correct answer?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2000 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform?