70-764

Question 46

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?

1. RETURNS varchar(20)WITH Schemabinding
2. RETURNS dbo.CustomersORDER BY @salesPerson
3. RETURNS tableORDER BY @salesPerson
4. RETURNS tableWITH Schemabinding

Question 47

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?

1. a certificate
2. an MD5 hash
3. a DES key
4. an AES 256-bit key

Question 48

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?

1. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL)
2. ALTER DATABASE DB1SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 50)
3. ALTER DATABASE DB1SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14));
4. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = NONE)

Question 49

You deploy a Microsoft SQL Server instance to support a global sales application. The instance includes the following tables: TableA and TableB. TableA is a partitioned table that uses an incrementing integer number for partitioning. The table has millions of rows in each partition. Most changes to the data in TableA affect recently added data. The UPDATE STATISTICS for TableA takes longer to complete than the allotted maintenance window. Thousands of operations are performed against TableB each minute. You observe a large number of Auto Update Statistics events for TableB. You need to address the performance issues with each table. In the table below, identify the action that will resolve the issues for each table. NOTE: Make only one selection in each column. Hot Area:

Question 50

You administer a database that is used for reporting purposes. The database has a large fact table that contains three hundred million rows. The table includes a clustered columnstore index and a nonclustered index on the ProductID column. New rows are inserted into the table every day. Performance of queries that filter the Product ID column have degraded significantly. You need to improve the performance of the queries. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: