[2026] Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

문제1

You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?

A. STATISTICS_NORECOMPUTE = ON

B. STATISTICS_NORECOMPUTE = OFF

C. FILLFACTOR = 0

D. FILLFACTOR = 80

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제2

You plan to design an application that temporarily stores data in a SQL Azure database.
You need to identify which types of database objects can be used to store data for the application. The solution must ensure that the application can make changes to the schema of a temporary object during a session.
Which type of objects should you identify?

A. Temporary stored procedures

B. Temporary tables

C. Common table expressions (CTEs)

D. Table variables

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제3

You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

A. GRANT SELECT on CustProduct TO public.

B. GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.

C. Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.

D. Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.

E. Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.

F. GRANT ALL on CustProduct TO OurDomain\CustomerSupport

정답: B,C

설명: (Fast2test 회원만 볼 수 있음)

문제4

You are troubleshooting an application that runs a query. The application frequently causes
deadlocks.
You need to identify which transaction causes the deadlock.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

A. Create a trace in SQL Server Profiler that contains the Deadlock graph event.

B. Query the sys.dm_exec_requests dynamic management view.

C. Create an extended events session to capture deadlock information.

D. Query the sys.dm_exec_sessions dynamic management view.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제5

You have a query that is used by a reporting dashboard.
Users report that the query sometimes takes a long time to run.
You need to recommend a solution to identify what is causing the issue.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

A. Enable trace flag 1204, and then create an alert.

B. Create a job that queries the sys.dm_os_waiting_tasks dynamic management view.

C. Set the blocked process threshold, and then create an alert.

D. Set the blocked process threshold, and then run SQL Server Profiler.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제6

-----
You administer a SQL Server 2014 instance.
Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues.
You want to write a query of the system views that will report the following:
Number of users that have a connection to the server Whether a user's connection is active Whether any connections are blocked What queries are being executed Whether the database restore is still executing and, if it is, what percentage of the restore is complete
Which system objects should you use in your query to best achieve this task?

A. sys.dm_exec_requests, sys.dm_exec_sessions, sys.objects

B. sys.dm_exec_sessions, sys.dm_exec_query_stats, sys.dm_exec_query_text,sys.objects

C. sys.sysprocesses, sys.dm_exec_query_text, sys.objects

D. sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제7

You have a SQL Azure database.
You need to identify which keyword must be used to create a view that will be indexed.
Which keyword should you identify?

A. DEFAULT

B. VIEW_METADATA

C. SCHEMABINDING

D. DISTINCT

정답: C

설명: (Fast2test 회원만 볼 수 있음)

Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform - 070-459무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트