Braindump2go Guarantees Your Microsoft 70-469 Exam 100% Success with Our Unique Official 70-469 Exam Questions Resources! Braindump2go’s 70-469 Braindumps are Developed by Experiences IT Certifications Professionals Working in Today’s Prospering Companies and Data Centers! Braindump2go 70-469 Exam Dumps are Checked by Our Experts Team every day to ensure you have the Latest Updated Exam Dumps!
Vendor: Microsoft
Exam Code: 70-469
Exam Name: Recertification for MCSE: Data Platform
Keywords: 70-469 Exam Dumps,70-469 Practice Tests,70-469 Practice Exams,70-469 Exam Questions,70-469 PDF,70-469 VCE Free,70-469 Book,70-469 E-Book,70-469 Study Guide,70-469 Braindump,70-469 Prep Guide
QUESTION 201
You have a SQL Server 2012 database named Database1.
Database1 has a table named Customers. Customers contains more than 1 million rows.
The database has a stored procedure that was created by using the following script:
You need to ensure that up_customers returns rows when the following statement is executed:
EXECUTE up_customers’1,2,3,4,5′;
What should you do?
A. Update @CustcmerTypelist to use the int data type.
B. Convert @CustomerTypeList to a table variable.
C. Convert @CustomerTypeList to an XML variable.
D. Update @CustomerTypeList to use the XML data type.
Answer: B
QUESTION 202
Drag and Drop Questions
You have a SQL Server 2012 database named database1.
Users report that queries that usually take less than one second to execute, take more than 30 seconds to execute.
You need to view the server resource consumption when the queries are executed.
What should you do? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
QUESTION 203
Drag and Drop Questions
You have a SQL Server 2012 database named Database1.
Database1 has a data file named Database1_data.mdf and a transaction log named Database1jog.ldf.
Database1_data.mdf is 1.5 GB. Database1jog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file.
The solution must ensure that you can perform transaction log backups in the future.
Which code segment should you execute? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Answer:
QUESTION 204
You need to identify which long running transactions use an index.
Which dynamic management view should you use?
A. sys.dm_exec_query_optimizer_info
B. sys.dm_exec_connections
C. sys.dm_exec_query_stats
D. sys.dm_exec_sessions
Answer: A
QUESTION 205
You create a table named Customers by using the following code segment:
You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:
You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?
A. Replace LEFT(name,3) = ‘smi’ by using name like ‘smi%’
B. Replace LEFT(name,3) = ‘smi’ by using substring(name,l,3) = ‘smi’
C. Recreate IX_Name as a unique index
D. Recreate IX Name as a clustered index
Answer: A
QUESTION 206
You plan to execute the following code:
You need to identify how many rows will be in dbo.Table1 after you execute the code.
How many rows should you identify?
A. 0
B. 1
C. 2
D. 3
Answer: A
QUESTION 207
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. Common table expressions (CTEs)
B. Temporary stored procedures
C. Temporary tables
D. Table variables
Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/en-us/library/ms189084.aspx
http://msdn.microsoft.com/en-us/library/ms175010.aspx
http://msdn.microsoft.com/en-us/library/bb510489.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx http://zacksfiasco.com/post/2010/01/21/SQL-Server-Temporary-Stored-Procedures.aspx
QUESTION 208
Drag and Drop Questions
You have a table named Customers that has a clustered index defined on the ID column.
You write a script to create a stored procedure.
You need to complete the script for the stored procedure.
The solution must minimize the number of locks and deadlocks.
What should you do? To answer, drag the appropriate option to the correct location in the answer area. (Answer choices may be used once, more than once, or not at all.)
Answer:
QUESTION 209
You execute the following code:
You have a stored procedure that includes the following SELECT statement:
You need to create a covering index on UserInfo.
Which code segment should you execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
QUESTION 210
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 = OFF
B. FILLFACTOR = 80
C. FILLFACTOR = 0
D. STATISTICS_NORECOMPUTE = ON
Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms177459.aspx
http://msdn.microsoft.com/en-us/library/ms188783.aspx
Want to be 70-469 certified? Using Braindump2go New Released 70-469 Exam Dumps Now! We Promise you a 100% Success Passing Exam 70-469 Or We will return your money back instantly!
