70-469試験番号:70-469 試験問題集
試験科目:「Recertification for MCSE: Data Platform」


074-409日本語試験番号:074-409日本語 試験過去問
試験科目:「Server Virtualization with Windows Server Hyper-V and System Center (074-409日本語版)」






NO.1 You need to recommend a solution to synchronize Database2 to App1_Db1.
What should you recommend?
A. Change data capture
B. Snapshot replication
C. Master Data Services
D. Transactional replication
Answer: D

Microsoft学校   70-469学校   70-469過去問
*Data from Database2 will be accessed periodically by an external application named Application1.
The data from Database2 will be sent to a database named App1_Db1 as soon as changes occur to
the data in Database2.
*All data in Database2 is recreated each day and does not change until the next data creation
process. Transactional Replication

Your network contains a server named Server1 that runs SQL Server 2012. Server1 contains an
instance named Instance1. Instance1 contains a database named ContentDatabase.
ContentDatabase uses transaction log backups.
The recovery model of ContentDatabase is set to FULL.
You need to shrink the ContentDatabase_Log log file to 10 MB. The solution must ensure that you
can continue to back up the transaction log.
Which three code segments 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.

NO.3 You plan to create a database.
The database will be used by a Microsoft .NET application for a special event that will last
for two days.
During the event, data must be highly available.
After the event, the database will be deleted.
You need to recommend a solution to implement the database while minimizing costs. The
solution must not affect any existing applications.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. SQL Server 2014 Enterprise
B. SQL Server 2014 Standard
C. SQL Azure
D. SQL Server 2014 Express with Advanced Services
Answer: B

Microsoft   70-469認定証   70-469   70-469短期   70-469入門
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) supported by Standard and Enterpirse
editions only.
Reference: Features Supported by the Editions of SQL Server 2014

NO.4 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

Microsoft   70-469赤本   70-469   70-469取得

NO.5 You need to implement a change to usp_ExportOpenings that meets the integration
What should you modify in usp_ExportOpenings? (Each correct answer presents part of the solution.
Choose all that apply?)
A. To the end of line 04, add [Opening].
B. To the end of line 05, add [Opening! title].
C. To line 10, add FOR XML RAW.
D. To line 10, add FOR XMLEXPLICIT.
E. To line 10, add FOR XML AUTO.
F. To the end of line 04, add [Opening!ELEMENT].
G. To the end of line 06, add [Opening!salary!ELEMENT].
H. To the end of line 05, add [Opening!title!ELEMENT].
I. To the end of line 06, add [Opening! salary].
Answer: A,B,E,I

Microsoft入門   70-469   70-469   70-469特典
The AUTO mode generates nesting in the resulting XML by using heuristics based on the way the
SELECT statement is specified. You have minimal control over the shape of the XML generated. The
nested FOR XML queries can be written to generate XML hierarchy beyond the XML shape that is
generated by AUTO mode heuristics.

NO.6 You need to optimize the index structure that is used by the tables that support the fraud
detection services.
What should you do?
A. Add a hashed nonclustered index to CreateDate.
B. Add a not hash nonclustered index to CreateDate.
C. Add a not hash clustered index on POSTransactionId and CreateDate.
D. Add a hashed clustered index on POSTransactionId and CreateDate.
Answer: A

Microsoft通信   70-469特典   70-469練習問題   70-469費用
The fraud detection service will need to meet the following requirement (among others):
* Detect micropayments that are flagged with a StatusId value that is greater than 3 and that
occurred within the last minute.

NO.7 You need to recommend a solution that meets the data recovery requirement. What should
you include in the recommendation?
A. A differential backup
B. A transaction log backup
C. Snapshot isolation
D. A database snapshot
Answer: D

Microsoft過去問   70-469   70-469   70-469
How Database Snapshots Work

NO.8 You deploy a database by using SQL Server 2014. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1.
The solution must minimize the amount of custom code required.
What should you recommend?
A. Change data capture
B. Statistics
C. A trigger
D. Master Data Services
Answer: A

Microsoft種類   70-469赤本   70-469合格点   70-469教材   70-469教本
Change data capture is designed to capture insert, update, and delete activity applied to SQL Server
tables, and to make the details of the changes available in an easily consumed relational format. The
change tables used by change data capture contain columns that mirror the column structure of a
tracked source table, along with the metadata needed to understand the changes that have
occurred. About Change Data Capture (SQL Server)

投稿日: 2014/12/9 16:04:12  |  カテゴリー: Microsoft  |  タグ: 70-469認定074-409J割引Microsoft