한 번의 불합격은 재응시 비용과 준비 기간 연장으로 이어집니다. Fast2test의 70-458 예상 문제 90문항으로 약점을 미리 점검하시면 Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 응시에 드는 비용과 시간을 아끼실 수 있습니다.

Microsoft 70-458 시험 개요:

Microsoft 70-458 시험 요강 주제:

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2에 대해 수험생이 가장 많이 묻는 질문

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

문제 #1

DRAG DROP
You administer several Microsoft SQL Server 2012 servers. Your company has a number
of offices across the world connected by using a wide area network (WAN).
Connections between offices vary significantly in both bandwidth and reliability.
You need to identify the correct replication method for each scenario.
What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.)

문제 #2

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide complete details for each record. The data retrieved from each data source is sorted in ascending order by the ProductID column.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)

문제 #3

DRAG DROP
All database traffic to the SQL Server must be encrypted by using secure socket layer (SSL) certificates or the connection must be refused.
Network administrators have deployed server certificates to the Windows store of all Windows servers on the network from a trusted Certificate Authority. This is the only Certificate Authority allowed to distribute certificates on the network.
You enable the Force Encryption flag for the MSSQLServer protocols, but client computers are unable to connect. They receive the following error message:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake, (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server)"
You notice the following entry in the SQL Server log:
"A self-generated certificate was successfully loaded for encryption."
You need to configure SQL Server to encrypt all client traffic across the network. You also need to ensure that client computers are able to connect to the server by using a trusted certificate.
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 two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts for all SQL Services.
You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.
The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
"Cannot access the file. Operating system error code 5 (Access is denied.)."
You need to configure the distribution agent by granting only the minimum required access to all accounts.
What should you do?

A. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1.
B. Configure the SQL Server Agent service to run under the Local System account. Configure the Subscriber to use the SQL Server Agent service account.
C. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1.
D. Configure the Subscriber to use the Local System account.

문제 #5

You are designing a data warehouse with two fact tables. The first table contains sales per
month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

A. Merge the fact tables.
B. Create a time dimension that can join to both fact tables at their respective granularity.
C. Create a time mapping table.
D. Join the two fact tables.

질문과 대답: