9AbunəçiləriAbunə ol
QUESTION 13 You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using the following script: Each order is tracked by using one of the following statuses: Fulfilled Shipped Ordered Received You need to design the database to ensure that you can retrieve the status of an order on a given date. The solution must ensure that new statuses can be added in the future. What should you do? More than one answer choice may achieve the goal. Select the BEST answer. A. Implement change data capture on the Sales.Orders table. B. To the Sales.Orders table, add a column named Status that will store the order status. Update the Status column as the order status changes. C. Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes. D. To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate. Update the value of each column from null to the appropriate date as the order status changes. Correct Answer: B Explanation
QUESTION 14 You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements. What should you recommend? A. Create a user-defined database role and add users to the role. B. Create stored procedures that use EXECUTE AS clauses. C. Create a Policy-Based Management Policy. D. Create functions that use EXECUTE AS clauses. Correct Answer: B Explanation QUESTION 15 Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments. You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files must be encrypted. You need to grant the correct permission to the service account that backs up the HRDB database. Which permission should you grant? A. DDLAdmin B. db_datawriter C. dbcreator D. dbo E. View Database State F. View Server State G. View Definition H. sysadmin Correct Answer: G Explanation Explanation/Reference:Restoring the encrypted backup: SQL Server restore does not require any encryption parameters to be specified during restores. It does require that the certificate or the asymmetric key used to encrypt the backup file be available on the instance that you are restoring to. The user account performing the restore must have VIEW DEFINITION permissions on the certificate or key. References: https://docs.microsoft.com/en-us/sql/relational-databases/backup- restore/backup-encryption
Индекс цитирования