Online Access Free 070-765 Exam Questions

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 production databases.
What should you do?

• A.Use the SQL Server default instance and configure an affinity mask.
• B.Use the SQL Server default instance and enable Contained Databases.
• C.Install a new named SQL Server instance on the server.
• D.Install a new default SQL Server instance on the server.

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 the stated goals.
You deploy the virtual machine (VM) by using the following settings:

The workload on this instance has a very high tempdb load.
You need to maximize the performance of the tempdb database.
Solution: You use an A8 compute-intensive instance and store the tempdb database in Standard storage.
Does the solution meet the goal?

• A.Yes
• B.No

You administer a Microsoft SQL Server 2014 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application.
Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify Application.Events without requiring any changes to the applications that utilize Application.Events.
Which type of solution should you use?

• A.Change tracking
• B.Change data capture
• C.Online index rebuild
• D.Partitioned tables

You are building the database platform for a multi-tenant application. The application will have one database per tenant and there will be 30 tenants. The application will require at least 10 GB of In-Memory OLTP per tenant database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory#additional-resources
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

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 and do not initialize values for local variables.
Solution: You enable the QUERY_OPTIMIZER_HOTFIXES option for the databases.
Does the solution meet the goal?

• A.Yes
• B.No