70-765 exam

Topic 2, Manage databases and instances HOTSPOT You need to ensure that a user named Admin2 can manage logins. How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area. View AnswerAnswer: Explanation: Step 1: CREATE LOGIN First you need to create a...

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

You administer a Microsoft SQL Server 2014 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written to tables under heavy system load. You need to limit the number of cores that handle I/O. What should you configure?A . Processor affinityB ....

HOTSPOT You need to create the contosodb1 database. How should you complete the Azure PowerShell command? To answer, select the appropriate Azure PowerShell segments in the answer area. View AnswerAnswer: Explanation: Box 1: New-AzureRmSqlDatabase New-AzureRmSqlDatabase creates a database or an elastic database. New-AzureRmSqlDatabase is a command with the Azure Resource...

You administer a single server that contains a Microsoft SQL Server 2014 default instance. You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. You need to ensure that the application login is unable to access other...

DRAG DROP You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. You plan to create a new security principal named User1. The principal must have access to select all current and future objects in a database named Reporting. The activity...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. You manage a Microsoft SQL Server environment with several databases. You need to ensure that queries use statistical data...

HOTSPOT You need to open the firewall ports for use with SQL Server environment. In table below, identify the firewall port that you must use for each service. NOTE: Make only one selection in each column. View AnswerAnswer: Explanation: Report Server: 80 By default, the report server listens for HTTP...

You administer a Microsoft SQL Server 2014 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?A . A Database Audit SpecificationB . A PolicyC...

HOTSPOT You need to set up the service accounts that the database engine and SQL Server Agent services will use. How should you design the solution? To answer, select the appropriate configuration options in the answer area. View AnswerAnswer: Explanation: Box 1: Domain Account The service startup account defines the...