70-764 exam

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory. Users need to be able to SELECT from all tables in the database and execute the stored procedure. You need to grant only the necessary permissions. What should you do?A . Grant EXECUTE...

Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site to optimize...

You manage database servers in a high security environment. Your company has the following auditing requirements: SQL Server auditing must be enabled on all server instances. Auditing results must be logged in the Windows Security even log. A routine review shows that a SQL Server is writing auditing entries to...

You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.A . Disable FILESTREAM on the Database.B . Enable FILESTREAM on the Server Instance.C . Configure the Database for Partial Containment.D . Create a non-empty...

You need to grant access to an OLTP database regardless of the user operating the application. Which strategy should you use?A . Application roleB . Database userC . Server loginD . Server roleView AnswerAnswer: A

You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured...

You use SQL Azure to store data used by an e-commerce application. You develop a stored procedure named sp1. Sp1 is used to read and change the price of all the products sold on the e-commerce site. You need to ensure that other transactions are blocked from updating product data...

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 contains a table named SalesInfo. You discover that some table has been deleted from the SalesInfo table. You are unable to find...

HOTSPOT You are planning to deploy log shipping for Microsoft SQL Server and store all backups on a dedicated fileshare. You need to configure the servers to perform each log shipping step. Which server instance should you configure to perform each action? To answer, select the appropriate server instances in...