SQL Server Administración Basica 2

You have a server that has SQL Server 2016 installed. The server contains 100 user databases.

You need to recommend a backup solution for the user databases.

The solution must meet the following requirements:

-> Perform a transaction log backup every hour.

-> Perform a full backup of each database every week.

-> Perform a differential backup of each database every day.

-> Ensure that new user databases are added automatically to the backup solution.

What should you recommend?

More than one answer choice may achieve the goal. Select the BEST answer.

• Policy-Based Management

• A Data Definition Language (DDL) trigger

• SQL Server Agent jobs

• A maintenance plan

You plan to create a database.

The database will be used by a Microsoft .NET application for a special event that will last for two days.

During the event, data must be highly available.

After the event, the database will be deleted.

You need to recommend a solution to implement the database while minimizing costs. The solution must not affect any existing applications.

What should you recommend?

More than one answer choice may achieve the goal. Select the BEST answer.

• SQL Server 2016 Enterprise

• SQL Server 2016 Standard

• SQL Azure

• SQL Server 2016 Express with Advanced Services

You deploy a database by using SQL Server 2016. The database contains a table named

Table1.

You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.

What should you recommend?

• Change data capture

• Statistics

• A trigger

• Master Data Services

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.

You plan to synchronize SQLDev and SQLProd.

You need to recommend a solution that meets the following requirements:

-> The database schemas must be synchronized from SQLDev to SQLProd.

-> The database on SQLDev must be deployed to SQLProd by using a package.

-> The package must support being deployed to Windows Azure SQL Database.

What should you recommend?

More than one answer choice may achieve the goal. Select the BEST answer.

• A database snapshot

• SQL Server Integration Services (SSIS)

• Change data capture

• A data-tier application

You need to diagnose deadlocks that happen when executing a specific set of store procedures by recording events and playing them back on a different test server. What should you créate?

• An Extended Event session

• A Policy

• A SQL Profiler Trace

• A Resource Pool

The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured to allow remote connections even if SQL Server is unresponsive to client connections. What should you do? Choose all that apply.

• Enable inbound connections on TCP port 1434 in the firewall on the server

• Execute the following T-SQL command: sp_configure 'remote admin connections'

• Restart the SQL Server Agent Service

• Enable inbound connections on TCP por 135 in the Windows Firewall on the server.