Microsoft
70-459 · Question #70
You are evaluating the table design. You need to recommend a change to Tables.sql that reduces the amount of time it takes for usp_AttendeesReport to execute. What should you add at line 14 of Tables.
The correct answer is C. FullName AS (FirstName + ' ' + LastName) PERSISTED,. See the full explanation below for the reasoning.
Question
You are evaluating the table design. You need to recommend a change to Tables.sql that reduces the amount of time it takes for usp_AttendeesReport to execute. What should you add at line 14 of Tables.sql?
Options
- AFullName AS (FirstName + ' ' + LastName),
- BFullName nvarchar(100) NOT NULL DEFAULT
- CFullName AS (FirstName + ' ' + LastName) PERSISTED,
- DFullName nvarchar(100) NOT NULL CONSTRAINT DF_FullName DEFAULT
How the community answered
(44 responses)- A14% (6)
- B7% (3)
- C75% (33)
- D5% (2)
Community Discussion
No community discussion yet for this question.