1 / 246

Exam

Exam. 70-432. QUESTION.

devi
Download Presentation

Exam

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exam 70-432

  2. QUESTION • You work as the network administrator at CertKiller.com. CertKiller.com has acquired an enterprise application that runs SQL Server 2008. The stored procedures that the application uses make use of the EXECUTE AS clause that makes use of the Microsoft Windows accounts. A new CertKiller.com security policy requires that all enterprise applications must run under the context of a service account. It is imperative that this account complies with the company policy that states all accounts must have the least amount of privileges whilst allowing duties to be carried out. Consequently this service account must have as little privileges as possible. You have received instructions to configure the SQL Server service to be used in a suitable context for the installation of the new enterprise application.

  3. ANSWER • A. You should consider running the SQL Server service under the domain user account. • B. You should consider running the SQL Server service under the local system account. • C. You should consider running the SQL Server service under the local Administrator account. • D. You should consider running the SQL Server service under the local service account.

  4. QUESTION • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. The SQL Server 2008 instance contains a database named CK_DB. CK_DB has its data file and the transaction log file on drive D. You have received instructions to move both the data file and the transaction log file to drive G.

  5. ANSWER A. You should consider adding the following Transact-SQL statement: ALTER DATABASE CK_DB SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; B. You should consider moving the data file and use the following Transact-SQL statement: ALTER DATABASE CK_DB MODIFY FILE(NAME = CK_DB_Data, FILENAME = mdf'); ALTER DATABASE CK_DB SET MULTI_USER; C. You should consider adding the following Transact-SQL statement: ALTER DATABASE CK_DB SET OFFLINE WITH ROLLBACK_IMMEDIATE; ALTER DATABASE CK_DB mdf'; ALTER DATABASE CK_DB SET ONLINE; D. You should consider moving the data file and then start the SQL Server service with the following Transact-SQL statement: IEXEC sp_attach_single_file_db @dbname = N' CK_DB ',@physname = N'v:\SQLServer\CK_DB_Data.mdf'; E. You should consider moving the data file and transaction log file and then start the SQL Server service with the following Transact-SQL statement: EXEC sp_attach_db @dbname = N' CK_DB ',@filename1 = N'G:\SQLServer\CK_DB_Data.mdf',@filename2 = ldf'; F. You should consider moving the data file and transaction log file and then start the SQL Server service with the following Transact-SQL statement: EXEC sp_attach_db @dbname = N' CK_DB ',@filename1 = N'G:\SQLServer\CK_DB_Data.mdf',@filename2 = N 'g:\SQLServer \CK_DB_log.ldf';

  6. Configure SQL Server instances. (4 questions) Part 2

  7. QUESTION • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. Management wants the prefix usp_ on all instances using all user-defined stored procedures; however, they do not want you to develop stored procedures which do not include this prefix.

  8. A. You should consider using a method that will point to the stored procedure which is evaluated on demand. B. You should consider using a method that will point to the stored procedure which is evaluated on change. C. You should consider using a method where the condition targets point to the stored procedure which is evaluated on demand. D. You should consider using a method where the policy targets point to the stored procedure which is evaluated on demand.

  9. Question • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. You have received instructions from management to allow the users at CertKiller.com on the SQL Server sample to use the OPENROWSET() function to search remote information sources.

  10. Answer A. You should consider configuring the Transaction Logs for sp_configure configuration. B. You should consider configuring the Ad Hoc Distributed Queries for sp_configure configuration. C. You should consider configuring the router control for sp_configure configuration. D. You should consider configuring the Ad Lib Distributed Queries for sp_configure configuration.

  11. Question • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server2008 instance. Because of a new application, you installed a second SQL Server 2008 instance that will work with the new application. However, these two instances should be functional with their respective applications without changing the environment of the application and with the minimal amount of cost.

  12. Answer – Choose 2 A. You should consider changing the SQL Server 2000 application to use SQL Server 2008. B. You should consider installing the new SQL Server 2008 as a named instance. C. You should consider changing the SQL Server 2000 instance to a SQL Server 2008 instance. D. You should consider setting set the new application to use the new instance. E. You should consider modifying the SQL Server 2008 to run as the default instance.

  13. QUESTION • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server2008 instance. You have received instructions from management to move a web application from Microsoft SQL Server 2005 to Microsoft SQL Server 2008. Be reminded that when a web application is moved then the features will be stopped and you need to control the sample to remember the use of features

  14. Answer A. You should consider using a SQL server-side trace which gets the Deprecation Announcement and Deprecation Final Support event classes. B. You should consider using a store procedure which gets the Deprecation Announcement and Deprecation Final Support event classes. C. You should consider using Transaction Log. D. You should consider using a SQL Server Profiler which gets the Deprecation Announcement and Deprecation Final Support event classes.

  15. Configure SQL Server services. (1 question) Part 3

  16. QUESTION You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server2008 instance. The SQL Server 2008 instance contains a database named CK_DB. Management wants CK_DB to have the following characteristics. * I/O streaming access should be enabled on CK_DB. * The data on CK_DB should be accessible to remote clients. * Ensure that CK_DB is enabled.

  17. Answer A. You should consider configuring the IIS Service. B. You should consider configuring the SQL Server service. C. You should consider configuring the SQL Server VSS Writer. D. You should consider configuring the Web Service.

  18. Configure addtionalSQL Server components. (5 questions) Part 4

  19. QUESTION You work as a database administrator at CertKiller.com. CertKiller.com is using SQL Server 2008.CertKiller.com contains a SQL Server 2008 server named CERTKILLER-DB04. CERTKILLERDB04 will be used to run the Reporting Services. However, the Reporting Services must be able to run the database backups and other maintenance job automatically. Because CertKiller.com has no other SQL systems, you need to make use of the SQL's DNS name. What should you do?

  20. A. You should consider using the SQL Server Web Service and the Microsoft Distributed Transaction Coordinator technology. • B. You should consider using the SQL Server Browser and the SQL Server Web Service technology. • C. You should consider using the Microsoft Distributed Transaction Coordinator and the SQL Server Browser technology. • D. You should consider using the Internet Information Services and the Microsoft Distributed Transaction Coordinator technology.

  21. QUESTION • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 database that makes use of the Analysis Services and Reporting Services. However, installed components at CertKiller.com adhere to the CertKiller.com security policy. You have received instruction to ensure that you adhere to the ertKiller.com security policy.

  22. You should consider developing policies based on the security policy before applying the policies against a server group which contains the database servers which need to be set.

  23. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. You have received instructions to publish an instance of SQL Server Reporting Services (SSRS) that will keep the old information to the same machine, and as default as possible. Microsoft 70-432: Practice Exam"

  24. You should consider using the SharePoint integrated mode and update the SSRS database.

  25. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance that contains a database named CK_Prod. CertKiller.com is using Microsoft SQL Server 2005 Analysis Services (SSAS) that is accessed by an Internet Information Services • application by using anonymous access. However, management wants the SSAS sample to be processed by the application.

  26. You should consider setting the Security\RequireClientAuthentication server configuration to False.

  27. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2000 instance that contains a database named CK_DB1. One day you installed a SQL Server 2008 instance for business. anagementwants you to ensure that the third-party pplications can run on both database instances with the minimum amount of administrative effort.

  28. You should consider installing SQL Server 2008 as a named instance and set the new application to utilize the new instance.

  29. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. You are busy with the setting of the Database Mail profile. You want the Database Mail profile to send reports to all of the users at CertKiller.com. You then use the sp_send_dbmail stored procedure to send reports during office hours. However, this method will take its time to send delivery reports to management. Furthermore, management wants the reports as soon as possible

  30. You should consider setting a new Database Mail profile that will be used for the delivery • reports to management.

  31. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which make use of the Fulltext indexes. However, some of the records have the word 'root' in CK_Prod. This causes the Fulltext index, when searching for the root word, an empty resultset. You need to include 'root' in the query that returned.

  32. You should consider reproducing the full-text index.

  33. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance that contains a database named CK_Prod that has a table named CK_Tblthat keeps data about the entire catalogue of products. The users at CertKiller.com search CK_Tbl which is based on the TestPro column. The TestPro column owns the NULL value for the entire catalogue except products such as Televisions. However, there is no index on the TestProcolumn presently. You have received instructions from management to ensure that queries are performed • more efficiently while minimizing the effect your solution will have on the disk space.

  34. You should consider developing a filtered index on the TestPro column.

  35. You work as a database administrator at CertKiller.com. The CertKiller.com network contains a SQL Server 2008 computer named CERTKILLER-DB01. CERTKILLER-DB01 needs the SQL Server service and the SQL Server Agent service to start automatically. Besides that, it should also audit all user names and application names that access the system. Auditing should be on always and the result should be there for about a decade.

  36. You should consider create a SQL Server Agent job for the SQL Trace stored procedure. • You should consider configuring the job to start when the SQL Server Agent service starts.

  37. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. The SQL Server 2008 instance hosts quite a few applications. Furthermore, the Ser Test\Test account is used by the SQL Server Agent service. CertKiller.com also uses a file that can be stored to a log server, by using a job named CK_MTest. However, CK_MTestcannot access the log server as it should. You then decide to set the service of SQL Server Agent. You • need to ensure that the settings of the SQL Server Agent service can access the entire log server.

  38. You should consider using the Domain account.

  39. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. The SQL Server 2008 instance contains SQL Server Agent jobs. These SQL Server Agent jobs uses ten shared schedules that is used 24/7. You have received instructions to ensure that a job named CK_Tst does not execute on Sundays.

  40. You should consider deleting the schedule from CK_Tst for Sundays.

  41. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. You want the tasks in the database to have the following characteristics: Microsoft 70-432: Practice Exam "Pass Any Exam. Any Time." - www.actualtests.com 10 ctualTests.com • * Examining database integrity. * Reproducing indexes.* Stores a report to a text file. You have received instructions to ensure that you could change the SQL Server instance in such a way that an e-mail notification is sent to the developers when the maintenance plan could not run • normally.

  42. You should consider modifying the SQL Server Agent job so that it runs the database maintenance plan to send e-mail notifications to the developers. • You should consider enabling a fail-safe operator for the SQL Server Agent.

  43. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. CertKiller.com contains two SQL Server 2008 servers named CERTKILLER-DB1 • and CERTKILLER-DB2. CERTKILLER-DB1 does the transaction log backups and CERTKILLERDB2 • is to reset by using the SQL Server Surface Area Configuration. However one morning you notice that the CERTKILLER-DB2 did not run the maintenance tasks automatically.

  44. A. You should consider resetting a full backup of the master database manually. • B. You should consider resetting the Web service to only grant access to an administrator. • C. You should consider resetting CERTKILLER-DB1 to use Windows Integrated authentication • exclusively. • D. You should consider resetting CERTKILLER-DB2 so that the SQL Server Agent service starts • automatically.

  45. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. The SQL Server 2008 instance has a stored procedure which runs a database maintenance process. You were instructed to develop a SQL Server Agent job which implements the stored procedure; however it should delete the job when it is finished. Microsoft 70-432: Practice Exam • "

  46. You should consider developing a job that uses the automatically remove job option.

  47. Explanation: • Part 2, Manage SQL Server Agent alerts. (0 questions) Part 3, Manage SQL Server Agent • operators. (1 question)

  48. You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server 2008 instance. CertKiller.com contains a SQL Agent job that runs every 5 minutes. CertKiller.com also has a text file called CK_Tst.log on F: drive that logs all the information of the job. One morning during monitoring you notice the following: * The SQL Server Agent job does not function * The SQL Server Agent service does not execute. You need to make sure why the SQL Server Agent service got lost.

  49. You should consider checking the SQLAGENT.OUT log.

  50. Explanation: • Part 4, Implement the declarative management framework (DMF). (1 question

More Related