70-469 Exam
Approved 70-469 answers Reviews & Tips
Ucertify offers free demo for 70-469 exam. "Recertification for MCSE: Data Platform", also known as 70-469 exam, is a Microsoft Certification. This set of posts, Passing the Microsoft 70-469 exam, will help you answer those questions. The 70-469 Questions & Answers covers all the knowledge points of the real exam. 100% real Microsoft 70-469 exams and revised by experts!
Q41. You execute the following code:
You create a nonclustered index named IX_CustomerName on the CustomerName column.
You execute the following query:
You need to reduce the amount of time it takes to execute the query.
What should you do?
A. Partition the table and use the CustomerName column for the partition scheme.
B. Replace IX_CustomerName with a clustered index.
C. Replace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
D. Replace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
Answer: C
Q42. You need to modify the function in CountryFromID.sql to ensure that the country name is returned instead of the country ID.
Which line of code should you modify in CountryFromID.sql?
A. 04
B. 05
C. 06
D. 19
Answer: D
Q43. 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
Q44. You have a text file that contains an XML Schema Definition (XSD).
You have a table named Schema1.Table1.
You have a stored procedure named Schema1.Proc1 that accepts an XML parameter named Param1.
You need to store validated XML data in Schema1.Table1. The solution must ensure that only valid XML data is accepted by Param1. What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A. Define an XML column in Table1 by using an XML schema collection.
B. Create an XML schema collection in the database from the text file.
C. Declare Param1 var1 as type XML and associate the variable to the XML schema collection.
D. use the modify method to insert the XML schema into each row of the XML column in Table1.
Answer: ABD
Q45. You need to modify the Orders table to store the XML data used by the retailers.
Which statement should you execute?
A. ALTER Orders
ADD originalOrder XML (ValidateOrder);
B. ALTER Orders
ADD originalOrder XML;
C. ALTER Orders
ADD originalOrder varchar(max);
D. ALTER Orders
ADD originalOrder varbinary(max);
Answer: D
Q46. You need to create a script that automates the export of the XML data. The script must meet the integration requirements.
What should you include in the script?
A. The CREATE SERVER ROLE command and the sp_reassign_proxy, sp_add_job, sp_add_jobstep, and sp_grant_login_to_proxy system stored procedures.
B. The CREATE CREDENTIAL command and the sp_add_proxy, sp_add_job, sp_add_jobstep, and sp_grant_proxy_to_subsystem system stored procedures.
C. The CREATE CREDENTIAL command and the sp_reassign_proxy, sp_add_job, sp_add_jobstep, and sp_grant_login_to_proxy system stored procedures.
D. The CREATE SERVER ROLE command and the sp_add_proxy, sp_add_job, sp_add_jobstep, and sp_grant_proxy_to_subsystem system stored procedures.
Answer: B
Q47. You need to recommend an isolation level for usp_UpdateOrderDetails.
Which isolation level should recommend?
A. Read committed
B. Repeatable read
C. Read uncommitted
D. Serializable
Answer: B
Q48. You have a table named Table1 that stores customer data.
Each customer has a credit limit that can only be discovered by querying multiple tables.
You need to ensure that the value of the credit limit is returned by executing a query on Table1.
What should you create?
A. A trigger that uses a ranking function
B. A trigger that uses a table-valued function
C. A calculated column that uses a table-valued function
D. A calculated column that uses a scalar function
Answer: C
Q49. You have two SQL Server 2014 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev even if they do not have a login on the SQLDev instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Triggers
B. Contained database
C. SQL Server Analysis Services (SSAS) scripts
D. Extended Events
E. SQL Server Integration Services (SSIS) scripts
Answer: B
Q50. You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort.
What should you include in the recommendation?
A. Indexed views
B. Filegroups
C. Table partitioning
D. Indexes
Answer: B