QUESTION 21
Your company exchanges information with other companies by using XML and Web services. Your manager asks you to remove a schema collection that is no longer used. Before dropping the schema, you should confirm that it is no longer in use.
You need to use a catalog view to determine if the schema collection is being used. Which catalog view should you use?
A. sys.xml_schema_components
B. sys.xml_schema_namespaces
C. sys.xml_schema_collections
D. sys.column_xml_schema_collection_usages
Answer: D
QUESTION 22
You have an XML schema that you must use to validate XML data in your database. You need to store this XML schema. Which code segment should you use?
A. CREATE SCHEMA CustomerSchema
B. CREATE DEFAULT CustomerSchema AS ‘XML’
C. CREATE PRIMARY XML INDEX CustomerSchema
D. CREATE XML SCHEMA COLLECTION CustomerSchema
Answer: D
QUESTION 23
You have a table named Customers that has an XML column named CustomerData. There are currently no indexes on the table.
You use the following WHERE clause in a query:
WHERE CustomerData.exist (‘/CustomerDemographic/@Age[.>=”21″]’) = 1
You need to create indexes for the query.
Which Transact-SQL statements should you use?
A. CREATE CLUSTERED INDEX CL_IDX_Customer ON Customers(CustomerID);
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR PATH;
B. CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR VALUE;
C. CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR PATH;
D. CREATE CLUSTERED INDEX CL_IDX_Customer ON Customers(CustomerID);
CREATE PRIMARY XML INDEX PXML_IDX_Customer ON Customers(CustomerData);
CREATE XML INDEX SXML_IDX_Customer_Property ON Customer(CustomerData)
USING XML INDEX PXML_IDX_Customer FOR VALUE;
Answer: A
QUESTION 24
You need to capture the execution plan for a query. Which statement should you use?
A. SET FORCEPLAN ON;
B. SET SHOWPLAN_XML ON;
C. SET STATISTICS IO ON;
D. SET STATISTICS TIME ON;
Answer: B
QUESTION 25
You are troubleshooting query performance on SQL Server 2008. You are tasked to create an estimated execution plan by using Transact-SQL. You should be able to view the plan graphically in SQL Server Management Studio. You need to ensure that the execution plan can be saved as a .sqlplan file.
Which Transact-SQL setting should you use?
A. SET SHOWPLAN_ALL ON;
B. SET SHOWPLAN_XML ON;
C. SET STATISTICS XML ON;
D. SET STATISTICS PROFILE ON;
Answer: B
QUESTION 26
You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a graphical execution plan. You need to save the plan to a file that can be used by SQL Server Management Studio to display the graphical execution plan.
Which file extension should you use?
A. .gif
B. .xml
C. .psql
D. .sqlplan
Answer: D
QUESTION 27
You have run a server side trace that created 45 trace files. You want to load the trace files on your workstation in a database table called PerfData for further analysis. You need to load three files starting at c:\my_trace_38.trc.
Which Transact-SQL statement should you use?
A. SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:\my_trace.trc’, 3)
B. SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:\my_trace_38.trc’, 3)
C. SELECT * INTO PerfData
FROM ::fn_trace_gettable(‘c:\my_trace38.trc’, default)
D. SELECT * INTO PerfData
FROM ( SELECT * FROM ::fn_trace_gettable (‘c:\my_trace_38.trc’, default)
UNION ALL
SELECT * FROM ::fn_trace_gettable (‘c:\my_trace_39.trc’, default)
UNION ALL
SELECT * FROM ::fn_trace_gettable (‘c:\my_trace_40.trc’, default) ) Trc
Answer: B
QUESTION 28
You are using SQL Server Profiler to gather deadlock information. You need to capture an XML description of a deadlock. Which event should you use?
A. Lock:Deadlock
B. Showplan XML
C. Deadlock Graph
D. Lock:Deadlock Chain
Answer: C
QUESTION 29
You are troubleshooting query performance on SQL Server 2008. You have profiler trace data in a table named PerfData. You need to determine which events are taking longer than one second of CPU time or run for more than two seconds.
Which Transact-SQL statement should you use?
A. SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000 OR Duration > 2000 )
B. SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000 OR Duration > 2000000 )
C. SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000000 OR Duration > 2000 )
D. SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000000 OR Duration > 2000000 )
Answer: B
QUESTION 30
You are using the Database Engine Tuning Advisor (DTA) to analyze a workload. You need to save the recommendations generated by the DTA. Which command should you use?
A. Preview Workload Table
B. Export Session Results
C. Import Session Definition
D. Export Session Definition
Answer: B
If you want to pass Microsoft 70-433 successfully, donot missing to read latest lead2pass Microsoft 70-433 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.