70-762 무료 덤프문제 온라인 액세스

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 os independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database named DB1. There is no memory-optimized filegroup in the database.
You run the following query:

The following image displays the execution plan the query optimizer generates for this query:

Users frequently run the same query with different values for the local variable @lastName. The table named Person is persisted on disk.
You need to create an index on the Person.Person table that meets the following requirements:
- All users must be able to benefit from the index.
- FirstName must be added to the index as an included column.
What should you do?

• A.Create a nonclustered columnstoreindex on the table.
• B.Create a clustered index on the table.
• C.Create a nonclustered filtered index on the table.
• D.Create a nonclustered index on the table.
• E.Create a clustered columnstore index on the table.
• F.Create a hash index on the table.

Note: This question is part of a series of questions that present the same scenario. Each question in this series contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
- Employee ID
- date and time employee checked in to work
- date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

• A.No
• B.Yes

You have a table stores transactions partitions by year.
Users occasionally experience performance issues when they access the table. The table is located exclusively when the records are updated.
You need to prevent exclusive locks on the table and maintain data integrity.
What should you do?

• A.Set the DATA COMPRESSION property to RW at the partition level.
• B.Set the LOCK_EXCALATION property to TABLE.
• C.Set the LOCK_EXCALATION property to DISABLE.
• D.Set the LOCK_EXCALARTION property to AUTO.
• E.Set the DATA_COMPRESSION property to PAGE at the partition level.

You have a database with multiple tables. You must insert data into the tables by using views.
Which of the following two statements best describes an updatable view?
NOTE: Each correct selection is worth one point.

• A.The view may include a composite field.
• B.The view may include GROUP BY or HAVING statements.
• C.The view must not include subqueries.
• D.The view must not include the primary key of the table.
• E.Each view must reference columns from one table.

You have a database with tables. You must insert data into the table by using views.
Which of the following two statements best describes an updatable view?
NOTE: Each correct selection is worth on point.

• A.The view must not include subqueries.
• B.Each view must reference columns for one table.
• C.The view must include GROUP By or HAVING statements.
• D.The view may include a composite filed.
• E.The view must not include the primary key of the table.