70-765

Topic 6, SQL Server Reporting Background You manage a Microsoft SQL Server environment that includes the following databases: DB1, DB2, Reporting. The environment also includes SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). All SSRS and SSAS servers use named instances. You configure a firewall rule for SSAS....

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

Topic 3, Deploy and migrate applications A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo. You plan to deploy a Microsoft Azure SQL Database instance to support a new application. You expect to have...

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

You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs. You need to ensure that reports do not use all available system resources. What should you do?A . Enable Auto Close.B . Increase the value for...

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

You administer a Microsoft SQL Server 2014 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?A . Execute sp_configure 'max log size', 2C . use the ALTER DATABASD . ..SET LOGFILE command along with the maxsize parameter.E...

DRAG DROP A new Azure Active Directory security principal named [email protected] should have access to select all current and future objects in the Reporting database. You should not grant the principal any other permissions. You should use your Active Directory Domain Services (AD DS) account to authenticate to the Azure...

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

You administer a Microsoft SQL Server 2014 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should you do?A . Modify tempdb location in startup parameters.B . Start SQL Server in minimal configuration mode.C . Start SQL...