70-465 Exam Questions

You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation?

You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?

You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort. What should you recommend?

You need to recommend a solution that reduces the time it takes to import the supplier data. What should you include in the recommendation?

You need to recommend a solution that addresses the file storage requirements. What should you include in the recommendation?

You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?

You need to recommend a solution that addresses the security requirement. What should you recommend?

Drag and Drop Question You need to recommend which statement should be used to update SalesOrder. How should you recommend completing the statement? To answer, drag the appropriate...

What should you recommend for the updates to Sales.TransactionHistory?

You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?

You need to recommend a solution to minimize the amount of time it takes to execute USP_5. What should you include in the recommendation?

You need to recommend a solution to meet the security requirements of the junior database administrators. What should you include in the recommendation?

You need to recommend a change to USP_3 to ensure that the procedure continues to execute even if one of the UPDATE statements fails. Which change should you recommend?

You need to recommend a disaster recovery solution for the Dev database. What should you include in the recommendation?

You need to recommend a solution for the planned changes to the customer classifications. What should you recommend? (Each correct answer presents part of the solution. Choose all...

You need to recommend a change to USP_3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?

You need to recommend a solution for the error handling of USP_3. The solution must minimize the amount of custom code required. What should you recommend?

You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?

You need to recommend a solution to minimize the amount of time it takes to execute USP_2. What should you recommend?

You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for USP_4. What should you recommend?

You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you recommend replacing Table1?

You need to recommend a solution to ensure that USP_4 adheres to the security requirements. What should you include in the recommendation?

You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you recommend replacing Table1?

You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?

You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing...

You need to recommend a solution to meet the recovery requirements for the manufacturing database. Your solution must minimize costs. What should you recommend?

You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?

You need to enable users to modify data in the database tables using UPDATE operations. You need to implement a solution that meets the design requirements. What should you configu...

You need to ensure that the account used to generate reports can only connect during certain hours. What should you configure?

You need to meet the design requirement for the ProductTypes table in the Product database. Which of the following would be the best solution?

You need to plan the SQL Server 2012 deployment that meets the design requirements. Which of the following steps should you perform? (Choose all that apply)

You need to recommend a solution to meet the design requirement of logging all failed authentication requests. What should you recommend?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. The sales and marketing departments contain a t...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring a highly-available database...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring a highly-available database...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. A full backup...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contai...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contai...

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. You plan to c...

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The company has a database named Products. Tables in the Produc...

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. You are developing a custom CRM application named CorpCRM. The...

You need to ensure that a stored procedure fails if an INSERT statment within the stored procedure fails. What action should you take?

You need to grant access to a OLTP database regardless of the user operating the application. Which strategy should you use? Select the BEST answer.

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the data...

You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sal...

You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution to ensure that all of the statements in the stored procedur...

You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week: - Rebuild the indexes by using a new fill fact...

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs...

You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries that read data and pr...

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create...