TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P163

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P163: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Self Test Appendix Appendix 115 A. ALTER PARTION FUNCTION. SPLIT B. ALTER TABLE . SWITCH C. ALTER TABLE . SPLIT D. Denormalize the table to 5th Normal Form Answer A is correct. The partition function controls the boundary between partitions and will allow a new partition to be created. Alter table switch will transfer data but won t change the active partition for inserts. Alter table split is not a valid option. Schema changes are not necessary. 8. When a new SQL Server session is started that meets none of the criteria defined in the Classifier function to which resource pool is the session assigned A. Internal B. Default C. Custom-1 D. None The correct answer is B all nonassigned sessions are executed by resources in the default resource pool. Internal is resource pool for SQL Server internal operations. Answers C and D are also incorrect. 9. You re the Administrator for a SQL Server used by a number of departments within your organization. At the end of each month the Accounts department runs a number of reports that calculate complex ratios and analytics. During this time other users frequently receive timeouts and poor performance. What s the best solution to limit the impact of these CPU-intensive reports run by Accounts A. Implement table partitioning. B. Separate data and log files. C. Use Resource Governor. D. Request Accounting users run reports only at night. The correct answer is C. Use Resource Governor to configure a maximum CPU threshold for Accounting users. Answers A and B are good practice but won t necessary limit the impact of accounts reports. Answer D is a nice idea but couldn t guarantee this would actually happen. 116 Appendix Self Test Appendix 10. You re a Systems Engineer responsible for SQL Server and a case had been escalated via the helpdesk where a user reported an exception in an application the error included deadlock victim. You d like to implement monitoring to capture details of the deadlocked processes and locks held with .

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.