[Free] Download New Updated (February 2016) Microsoft 70-458 Practice Tests 91-100

Ensurepass

QUESTION 91

You administer a Microsoft SQL Server 2012 database. The database has a table named

Customers owned by UserA and another table named Orders owned by UserB. You also have a

stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects

data from both tables. You create a new user named UserC. You need to ensure that UserC can

call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum

required permissions to UserC. Which permission or permissions should you assign to UserC?

Choose all that apply.

 

A.     The Select permission on Customers.

B.     The Execute permission on GetCustomerOrderInfo.

C.     The Take Ownership permission on Customers.

D.     The Control permission on GetCustomerOrderInfo.

E.      The Take Ownership permission on Orders.

F.      The Select permission on Orders.

 

Correct Answer: AB

 

 

QUESTION 92

You create an availability group named HaContoso that has replicas named Server01/HA,

Server02/HA, and Server03/HA. Currently, Server01l/HA is the primary replica. You need to

ensure that the following requirements are met:

 

Ÿ   Backup operations occur on Server02/HA.

Ÿ   If Server02/HA is unavailable, backup operations occur on Server03/HA.

Ÿ   Backup operations do not occur on Server01/HA.

 

How should you configure HaContoso?

 

A.       Set the backup preference of HaContoso to Prefer Secondary.

Set the backup priority of Server02/HA to 20.

Set the backup priority of Server03/HA to 10.

B.       Set the backup preference of HaContoso to Secondary only.

Set the backup priority of Server02/HA to 20.

Set the backup priority of Server03/HA to 10.

C.       Set the backup preference of HaContoso to Secondary only.

Set the backup priority of Server02/HA to 10.

Set the backup priority of Server03/HA to 20.

D.       Set the exclude replica of Server01/HA to true.

Set the backup priority of Server02/HA to 10.

Set the backup priority of Server03/HA to 20.

 

Correct Answer: B

 

 

QUESTION 93

DRAG DROP

You administer a Microsoft SQL Server database. You want to import data from a text file to the

database. You need to ensure that the following requirements are met:

 

Ÿ   Data import is performed by using a stored procedure.

Ÿ   Data is loaded as a unit and is minimally logged.

 

Which data import command and recovery model should you choose?

 

To answer, drag the appropriate data import command or recovery model to the appropriate

location or locations in the answer area. Each data import command or recovery model may be

used once, more than once, or not at all. You may need to drag the split bar between panes or

scroll to view content.

 

Select and Place:

clip_image002

 

Correct Answer:

clip_image004

 

QUESTION 94

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS)

installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project

Deployment Model together with parameters and Integration Services environment variables.

You need to configure the SQL Server environment to support these packages. What should you

do?

 

A.     Create SSIS configuration files for the packages.

B.     Create an Integration Services catalog.

C.     Install Data Quality Services.

D.     Install Master Data services.

 

Correct Answer: B

 

 

QUESTION 95

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.

The Sales database is configured as shown in the following table.

 

clip_image006

 

You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data

in the minimum amount of time. What should you do?

 

A.     Perform a restore from a full backup.

B.     Perform a transaction log restore.

C.     Perform a file restore.

D.     Perform a filegroup restore.

 

Correct Answer: A

 

 

 

 

QUESTION 96

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:

 

clip_image008

 

A.     Restore the latest full backup, and restore the latest differential backup. Then, restore the

latest log backup.

B.     Perform a point-in-time restore.

C.     Restore the latest full backup.

D.     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.

E.      Restore the latest full backup. Then, restore the latest differential backup.

F.      Restore the latest full backup. Then, restore each differential backup taken before the time of

failure from the most recent full backup.

G.     Perform a page restore.

H.     Perform a partial restore.

 

Correct Answer: C

 

 

QUESTION 97

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:

 

clip_image009

 

One of the hard disk drives that stores the reporting database fails at 16:40 hours. You need to

ensure that the reporting database is restored. You also need to ensure that data loss is minimal.

What should you do?

 

A.       Restore the latest full backup. Then, restore each differential backup taken before the time

of failure from the most recent full backup.

B.       Perform a partial restore.

C.       Restore the latest full backup, and restore the latest differential backup. Then, restore the

latest log backup.

D.       Restore the latest full backup.

E.       Perform a page restore.

F.        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.

G.       Restore the latest full backup. Then, restore the latest differential backup.

H.       Perform a point-in-time restore.

 

Correct Answer: G

 

 

QUESTION 98

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:

 

clip_image010

 

At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are

corrupted on the transactional database. 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, and restore the latest differential backup. Then, restore each

log backup taken before the time of failure from the most recent differential backup.

C.       Perform a point-in-time restore.

D.       Restore the latest full backup.

E.       Restore the latest full backup, and restore the latest differential backup. Then, restore the

latest log backup.

F.        Perform a page restore.

G.       Restore the latest full backup. Then, restore each differential backup taken before the time

of failure from the most recent full backup.

H.       Restore the latest full backup. Then, restore the latest differential backup.

 

Correct Answer: F

 

 

QUESTION 99

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:

clip_image011

At 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are

corrupted on the reporting database. You need to ensure that the databases are 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, and restore the latest differential backup. Then, restore each

log backup taken before the time of failure from the most recent differential backup.

C.       Restore the latest full backup.

D.       Restore the latest full backup, and restore the latest differential backup. Then, restore the

latest log backup.

E.       Perform a page restore.

F.        Restore the latest full backup. Then, restore each differential backup taken before the time

of failure from the most recent full backup.

G.       Perform a point-in-time restore.

H.       Restore the latest full backup. Then, restore the latest differential backup.

 

Correct Answer: H

 

 

QUESTION 100

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that

supports a retail sales application. The application generates hundreds of transactions per second

and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the

database. You need to ensure that the following requirements are met:

 

No more than 5 minutes worth of transactions are lost.

Data can be recovered by using the minimum amount of administrative effort.

 

What should you do? Choose all that apply.

 

A.     Configure the database to use the SIMPLE recovery model.

B.     Create a DIFFERENTIAL database backup every 4 hours.

C.     Create a LOG backup every 5 minutes.

D.     Configure the database to use the FULL recovery model.

E.      Create a FULL database backup every 24 hours.

F.      Create a DIFFERENTIAL database backup every 24 hours.

 

Correct Answer: BCDE

 

Free VCE & PDF File for Microsoft 70-458 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…