PrepAway - Latest Free Exam Questions & Answers

Category: 70-458

Exam 70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

Which of the following is the replication type being discussed?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing replication type that distributes data exactly as it appears at a specific moment in time
and does not monitor for updates to the data.
Which of the following is the replication type being discussed?

Which of the following is the required endpoint?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has several instances of SQL server in their environment. You have been instructed to
make sure that AlwaysOn Availability Groups are supported.
You need to configure a certain endpoint on each instance.
Which of the following is the required endpoint?

Which of the following is the replication agent being discussed?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing replication agent that has a “slow link” profile designed for low bandwidth connections.
Which of the following is the replication agent being discussed?

Which of the following is TRUE with regards to the AlwaysOn Availability Groups feature?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of AlwaysOn Availability Groups feature.
Which of the following is TRUE with regards to the AlwaysOn Availability Groups feature? (Choose
all that apply.)

Which of the following is TRUE with regards to the use of a Database mirroring strategy?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of a Database mirroring strategy.
Which of the following is TRUE with regards to the use of a Database mirroring strategy? (Choose
all that apply.)

Which of the following is TRUE with regards to this discussion?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing what the purpose of assigning the db_owner fixed database-level role to a user.
Which of the following is TRUE with regards to this discussion?

Which of the following is TRUE with regards to contained databases?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing contained databases.
Which of the following is TRUE with regards to contained databases? (Choose all that apply.)

Which of the following is TRUE with regards to DTA?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the Database Engine Tuning Advisor (DTA).
Which of the following is TRUE with regards to DTA? (Choose all that apply.)

Which of the following actions should you take NEXT?

You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has a database that hosts highly classified information. You have received instructions
to configure page level encryption for the database files. Your solution should also allow for
transaction log files to be encrypted.
You start by creating a master key. You then create a certificate in the master database, which is
protected by the master key.
Which of the following actions should you take NEXT?

Which of the following is the recovery model being discussed?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing a recovery model that does not make use of log backups.
Which of the following is the recovery model being discussed?


Page 1 of 512345