바쁜 일정 속에서 Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 시험을 준비하고 계신가요? Fast2test의 070-458 연습문제 90문항은 핵심 지식만 골라 담아 짧은 시간에 효율적으로 실력을 점검할 수 있도록 도와드립니다. 2026년 최신 출제 경향을 반영한 자료로 지금 바로 시작해 보시기 바랍니다.

Microsoft 070-458 시험 개요:

Microsoft 070-458 시험 요강 주제:

Microsoft 070-458 관련 궁금증 해결 가이드

최신 MCSA 070-458 무료샘플문제

문제 #1

DRAG DROP
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.
You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.
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.)

문제 #2

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

A. Audit
B. Pivot
C. Merge
D. CDC Splitter

문제 #3

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

A. Use the Database Engine Tuning Advisor.
B. Query the sys.dm_db_missing_index_columns DMV.
C. Query the sys.dm_db_missing_index_details DMV.
D. Query the sys.dm_db_index_usage_stats DMV.

문제 #4

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

A. Pivot
B. Merge Join
C. DQS Cleansing
D. CDC Splitter

문제 #5

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
- A data file of 2 terabytes is located on a dedicated LUN (drive D).
- A transaction log of 10 GB is located on a dedicated LUN (drive E).
- Drive D has 1 terabyte of free disk space.
- Drive E has S GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failoverto this secondary database.
You need to ensure that all transactions will be replicated to the secondary database.
Which backup option should you use?

A. Transaction log
B. SIMPLE
C. COPY_ONLY
D. NORECOVERY
E. SKIP
F. NO_CHECKSUM
G. RESTART
H. CONTINUE_AFTER_ERROR
I. STANDBY
J. Differential
K. BULK_LOGGED
L. CHECKSUM
M. FULL
N. DBO_ONLY

질문과 대답: