070-469無料問題集「Microsoft Recertification for MCSE: Data Platform」

質問 1

You need to implement security for the restore and audit process. What should you do?

（A）Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions.

（B）Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions.

（C）Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions.

（D）Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions.

正解：A 解答を投票する

質問 2

You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

（A）A FOREIGN KEY constraint

（B）A Data Definition Language (DDL) trigger

（C）A CHECK constraint

（D）A data manipulation language (DML) trigger

（E）A DEFAULT constraint

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

You have a database named Database1. You execute the following code:

You have the following query. (Line numbers are included for reference only.)

Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the query to complete.
Which code segment should you use to replace line 03?

（A）WHERE CONTAINS(notes,*%call%'> AND

（B）WHERE CONTAINS(notes, 'call*') AND

（C）WHERE FREETEXT(notes, '%call%') AND

（D）INNER JOIN FREETEXTTABLE(dbo.table1, notes, 'call') AS t2 ON dbo.table1.ID = t2.key WHERE

正解：C 解答を投票する

質問 4

You need to add a new column named Confirmed to the Attendees table.
The solution must meet the following requirements:
- Have a default value of false.
- Minimize the amount of disk space used.
Which code block should you use?

（A）ALTER TABLE Attendees
ADD Confirmed bit DEFAULT 1;

（B）ALTER TABLE Attendees
ADD Confirmed bit DEFAULT 0;

（C）ALTER TABLE Attendees
ADD Confirmed char(l) DEFAULT '1';

（D）ALTER TABLE Attendees
ADD Confirmed char(l) DEFAULT '1';

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

You execute IndexManagement.sql and you receive the following error message: "Msg
512, Level 16, State 1, Line 12
Subquery returned more than 1 value. This is not permitted when the subquery follows =,
!= ,<, <= , >, > = or when the subquery is used as an expression."
You need to ensure that IndexManagement.sql executes properly. Which WHILE statement should you use at line 18?

（A）WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable)

（B）WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable)

（C）WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)

（D）WHILE @counter < (SELECT SUM(RowNumber) FROM @indextable)

正解：C 解答を投票する

質問 6

DRAG DROP
You have two existing tables, one named COUNTRY and the other named STATES. The tables are defined as follows:

You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.

正解：

質問 7

You need to recommend a change to USP_3 to ensure that the procedure continues to execute even if one of the UPDATE statements fails.
Which change should you recommend?

（A）Set the XACT_ABORT option to on.

（B）Set the XACT_ABORT option to off.

（C）Set the IMPLICIT_TRANSACTIONS option to on.

（D）Set the IMPLICIT_TRANSACTIONS option to off.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

You need to modify the stored procedure usp_LookupConcurrentUsers.
What should you do?

（A）Add a clustered columnstore index to the summary table.

（B）Add a clustered index to the summary table.

（C）Use a table variable instead of the summary table.

（D）Add a nonclustered index to the summary table.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

070-469 無料問題集「Microsoft Recertification for MCSE: Data Platform」

弊社を連絡する

関連リンク

トップ試験