Does the solution meet the goal?

A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instancethat hosts a database named DB1. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to a named instance on a server...

April 22, 2018 No Comments READ MORE +

What should you include in the recommendation?

Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...

April 20, 2018 No Comments READ MORE +

What should you do?

You administer a Microsoft SQL Server 2016 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...

April 19, 2018 No Comments READ MORE +

To which role should you add UserA?

You administer a Microsoft SQL Server 2016 database instance. You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs. To which role should you add UserA? A. Securityadmin B. RSExecRole C. SQLAgentUserRole...

April 18, 2018 No Comments READ MORE +

What should you do?

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create database mirroring endpoints on both servers. What should you do?A . Configure the SQL Server service account to use Network Service.B...

April 16, 2018 No Comments READ MORE +

What should you configure?

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...

April 16, 2018 No Comments READ MORE +

What should you recommend?

You are creating a database that will store usernames and passwords for an application. You need to recommend a solution to store the passwords in the database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.A . One-way encryptionB . Transparent Data...

April 14, 2018 No Comments READ MORE +

Which three files should you restore in sequence?

DRAG DROP You have a database. The existing backups for the database and their corresponding files are listed in the following table. You purchase a new server. You must restore the database to the new server. You need to restore the data to the most recent time possible. Which three...

April 13, 2018 No Comments READ MORE +

Which technologies should you recommend?

DRAG DROP You are designing an authentication strategy for a new server that has SQL Server 2014 installed. The strategy must meet the following business requirements: The account used to generate reports must be allowed to make a connection during certain hours only. Failed authentication requests must be logged. You...

April 12, 2018 No Comments READ MORE +

Which set of tools should you install?

You install a Microsoft SQL Server 2016 instance. The instance will store data extracted from two databases running on Windows Azure SQL Database. You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database. You need to ensure that the data steward...

April 12, 2018 No Comments READ MORE +