Microsoft 70-433 Real Exam Questions
TS: Microsoft SQL Server 2008, Database Development
Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles.
1: 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
Correct Answers: D
2: 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
Correct Answers: C
3: You need to capture and record a workload for analysis by the Database Engine Tuning Advisor (DTA). Which tool should you use?
A.DTA utility
B.Activity Monitor
C.SQL Server Profiler
D.Performance Monitor
Correct Answers: C
4: 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
Correct Answers: B
5: 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;
Correct Answers: B
6: You have a single CLR assembly in your database. The assembly only references blessed assemblies from the Microsoft .NET Framework and does not access external resources.You need to deploy this assembly by using the minimum required permissions. You must ensure that your database remains as secure as possible.Which options should you set?
A.PERMISSION_SET = SAFE TRUSTWORTHY ON
B.PERMISSION_SET = SAFE TRUSTWORTHY OFF
C.PERMISSION_SET = UNSAFE TRUSTWORTHY ON
D.PERMISSION_SET = EXTERNAL_ACCESS TRUSTWORTHY OFF
Correct Answers: B
7: You need to create a stored procedure that accepts a table-valued parameter named @Customers.Which code segment should you use?
A.CREATE PROCEDURE AddCustomers (@Customers varchar(max))
B.CREATE PROCEDURE AddCustomers (@Customers Customer READONLY)
C.CREATE PROCEDURE AddCustomers (@Customers CustomerType OUTPUT)
D.CREATE PROCEDURE ADDCUSTOMERS (@Customers varchar (max))ASEXTERNAL NAME Customer.Add.NewCustomer
Correct Answers: B
8: You are creating a function that references a table.You need to prevent the table from being dropped.Which option should you use when you create the function?
A.WITH ENCRYPTION
B.WITH EXECUTE AS
C.WITH SCHEMABINDING
D.WITH RETURNS NULL ON NULL INPUT
Correct Answers: C
9: You are using TRY…CATCH error handling.You need to raise an error that will pass control to the CATCH block.Which severity level should you use?
A.0
B.9
C.10
D.16
Correct Answers: D
10: You need to ensure that tables are not dropped from your database.What should you do?
A.Create a DDL trigger that contains COMMIT.
B.Create a DML trigger that contains COMMIT.
C.Create a DDL trigger that contains ROLLBACK.
D.Create a DML trigger that contains ROLLBACK.
Correct Answers: C
Download | Password: ciscobibles.com