Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 認定 070-457 試験問題:
1. You administer a Microsoft SQL Server 2012 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the root cause of the issue by retrieving the error message. What should you do?
A) Create a SQL Profiler session to capture all ErrorLog and EventLog events.
B) Create an Extended Events session by using the sqlserver.error_reported event.
C) Flag all stored procedures for recompilation by using sp_recompile.
D) Execute sp_who.
2. You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A) Use the Data Quality Client to configure the application.
B) Start the SQL Server Browser Service.
C) Start the SQL Server Integration Services Service.
D) Use the Master Data Services Configuration Manager to configure the application.
3. You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?
A) Stored procedure
B) Scalar user-defined function
C) Inline user-defined function
D) Table-valued user-defined function
4. You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node 2. Node 1 fails and the cluster fails over to Node 2. You need to replace Node 1 and add it to the cluster. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:
5. You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?
A) Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
B) SQL Server that includes an application database configured to perform snapshot replication
C) Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode
D) Two servers configured in the same data center A primary server configured to perform log-shipping every 10 minutes A backup server configured as a warm standby
E) Two servers configured in different data centers SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
F) Two servers configured in the same data center SQL Server Availability Group configured in Asynchronous-Commit Availability Mode One server configured as an Active Secondary
G) SQL Server that includes an application database configured to perform transactional replication
H) Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary
質問と回答：
| 質問 # 1 正解： B | 質問 # 2 正解： B | 質問 # 3 正解： D | 質問 # 4 正解： メンバーにのみ表示されます | 質問 # 5 正解： G |
960 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
