DRAG DROP You administer a Microsoft SQL Server instance. An application executes a large volume of dynamic queries. You need to reduce the amount of memory used for cached query plans. Which three Transact-SQL segments should you use to develop…
DRAG DROP You administer a Microsoft SQL Server database. The database contains a schema named PRODUCT. PRODUCT contains several tables and views with sensitive data, as well as various stored procedures and functions. In order to configure security for PRODUCT,…
This question-is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question-in the series. You administer a Microsoft SQL Server database server that hosts a…
You are the senior database administrator for a Microsoft SQL Server environment that uses Microsoft Azure SQL Database. You need to grant a junior database administrator only the permissions required to create new logins. Which Microsoft Azure SQL Database role…
You need to install SQL Server on a server. The server must meet the following requirements: Include SQL Server Integration Services (SSIS) Be able to run 32-bit SSIS legacy packages You add the Integration Services shared feature to the installation.…
You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance. You need to ensure that users can create subscriptions. What should you configure? A. cache refresh options B. site security for service account…
You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance. You need to create a TCP endpoint to be used only by a login…
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services. You are configuring snapshot replication from…
You have a server named SQL1 that has SQL Server installed. SQL1 hosts several applications. You plan to deploy a third-party application to SQL1. The application must have the following: • A vendor-provided password for the sa account • A…
You administer a Microsoft SQL Server database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs…