The solution must ensure that new statuses can be

This preview shows page 11 - 14 out of 16 pages.

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. 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. B. 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. C. Implement change data capture on the Sales.Orders table. 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: A QUESTION 9 Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 VCE Dumps 11 / 16
Image of page 11
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download Filegroup FG1 is read only. You set FG1 to read only and create a full backup. The maintenance plan does not identify any errors after the backup. However, you observe the following error in the logs: You need to resolve the database corruption issue. A. Restore FG1 from the most recent backup. B. Drop and rebuild index ID 3 in Table1. C. Change FG1 from read-only to read/write. D. Update the statistics on index ID 3 in Table1. E. Backup the tail-logs in DB1. Correct Answer: A QUESTION 10 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_options You 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? A. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL) B. ALTER DATABASE DB1SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 50) C. ALTER DATABASE DB1SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14)); D. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = NONE) Correct Answer: C Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 VCE Dumps 12 / 16
Image of page 12
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download Stale Query Threshold (Days): Time-based cleanup policy that controls the retention period of persisted runtime statistics and inactive queries. By default, Query Store is configured to keep the data for 30 days which may be unnecessarily long for your scenario. Avoid keeping historical data that you do not plan to use. This will reduce changes to read- only status. The size of Query Store data as well as the time to detect and mitigate the issue will be more predictable. Use Management Studio or the following script to configure time-based cleanup policy: ALTER DATABASE [QueryStoreDB] SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14)); References:- practice-with-the-query-store QUESTION 11 Your company stored customer data, including credit card numbers, in a Microsoft SQL Server database. The
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 16 pages?

  • Fall '19
  • Microsoft SQL Server

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors