HOTSPOT -You manage a Microsoft SQL Server instance. You have a user named User1.You need to grant the minimum permissions necessary to allow User1 to review audit logs.For each action, which option should you use? To answer, select the appropriate options in the answer area.Hot Area:
DRAG DROP -You administer a Microsoft SQL Server database named Contoso. You create a stored procedure named Sales.ReviewInvoice by running the following Transact-SQL statement:You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch can run the Sales.ReviewInvoices stored procedure.Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.Select and Place:
You have a database that stores information for a shipping company. You create a table named Customers by running the following Transact-SQL statement.(Line numbers are included for reference only.)You need to ensure that salespeople can view data only for the customers that are assigned to them.Which Transact-SQL segment should you insert at line 07?
You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups.You need to configure the encryption options for backups.What should you configure?
You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour.Queries on DB1 are taking longer than normal to complete.You run the following Transact-SQL statement:SELECT * FROM sys.database_query_store_optionsYou determine that the Query Store is in Read-Only mode.You need to maximize the time that the Query Store is in Read-Write mode.Which Transact-SQL statement should you run?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
