Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 認定 70-458 試験問題:
1. You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?
A) Matching
B) Matching Policy
C) Cleansing
D) Knowledge Discovery
2. CORRECT TEXT
You are the data steward at your company.
Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQSJ knowledge base and matching policy to identify these duplicate customers.
You need to identify the duplicate customers.
Which option should you use? (To answer, select the appropriate option in the answer area.)
3. DRAG DROP
You are building a fact table In a data warehouse.
The table must have a columnstore index. The table cannot be partitioned.
You need to design the fact table and load it with data.
Which three 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.)
4. You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.
You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.
You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process,
Which Transact-SQL batch should you use?
A) CREATE INDEX IDX AccountTransactionAccountCode ON AccountTransaction.AccountCode WITH DROP EXISTING
B) ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REBUILD
C) ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZE
D) ALTER INDEX ALL ON AccountTransaction REBUILD
5. Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table: One of the hard disk drives chat stores the transactional database fails at 23:32 hours. Attempts to create a tail log backup are unsuccessful.
You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal,
What should you do?
A) Perform a partial restore.
B) Restore the latest full backup.
C) Perform a page restore.
D) Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
E) Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
F) Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
G) Restore the latest full backup. Then, restore the latest differential backup.
H) Perform a point-in-time restore.
質問と回答：
| 質問 # 1 正解： C | 質問 # 2 正解： メンバーにのみ表示されます | 質問 # 3 正解： メンバーにのみ表示されます | 質問 # 4 正解： D | 質問 # 5 正解： E |
1152 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
