IT인증시험문제는 수시로 변경됩니다. 이 점을 해결하기 위해 Pass4Test의 Microsoft 70-464 (Developing Microsoft SQL Server 2012 Databases)덤프도 시험변경에 따라 업데이트하도록 최선을 다하고 있습니다. Microsoft 70-464 (Developing Microsoft SQL Server 2012 Databases)시험문제 변경에 초점을 맞추어 업데이트를 진행한후 업데이트된 Microsoft 70-464 (Developing Microsoft SQL Server 2012 Databases)덤프를 1년간 무료로 업데이트서비스를 드립니다.
Who should take this exam?
This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
NO.1 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?
A. FullName
nvarchar(100) NOT NULL CONSTRAINT DF_FuIlName DEFAULT
(dbo.CreateFullName
(FirstName, LastName)),
B. FullName AS (FirstName +'
'+ LastName),
C. FullName nvarchar(100) NOT NULL DEFAULT (dbo.CreateFullName
(FirstName, LastName)).
D. FullName AS (FirstName +' '+ LastName)
PERSISTED,
Answer:
D
NO.2
You are testing disaster recovery procedures.
You attempt to restore DB1 to a
different server and you receive the following error message: "Msg
33111.
Level 16, State 3, Line 1 Cannot find server certificate with
thumbprint
,0xA694FBEA88C9354E5E2567C30A2A69E8FB4C44A9\ Msg 3013, Level 16, State 1,
Line
1 RESTORE DATABASE is terminating abnormally."
You need to ensure
that you can restore DB1 to a different server.
Which code segment should you
execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer:
B
NO.3 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 SUM(@RowNumber) < (SELECT @counter
FROM @indextable)
B. WHILE @counter < (SELECT COUNT(RowNumber) FROM
@indextable)
C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM
@indextable)
D. WHILE @counter < (SELECT SUM(RowNumber) FROM
@indextabie)
Answer: B
NO.4 You execute usp_TestSpeakers.
You
discover that usp_SelectSpeakersByName uses inefficient execution plans.
You
need to update usp_SelectSpeakersByName to ensure that the most
efficient
execution plan is used.
What should you add at line 30 of
Procedures.sql?
A. OPTION (FORCESCAN)
B. OPTION (FORCESEEK)
C. OPTION
(OPTIMIZE FOR UNKNOWN)
D. OPTION (OPTIMIZE FOR (@LastName=
'Anderson'))
Answer:
C
NO.5
You need to convert the functionality of Legacy.sql to use a stored procedure.
Which code
segment should the stored procedure contain?
A. Option A
B.
Option B
C. Option C
D. Option D
Answer:
D
NO.6
You need to modify the function in CountryFromID.sql to ensure that the country
name is
returned instead of the country ID.
Which line of code should you
modify in CountryFromID.sql?
A. 04
B. 05
C. 06
D. 19
Answer:
D
NO.7
You need to create a function that filters invoices by CustomerID. The SELECT
statement
for the function is contained in InvoicesByCustomer.sql. Which code
segment should you use to
complete the function?
A. Option A
B. Option
B
C. Option C
D. Option D
Answer: A
NO.8 You attempt to process
an invoice by using usp_InsertInvoice.sql and you receive the following
error
message: "Msg 515, Level 16, State 2, Procedure usp_InsertInvoice,
Line
Cannot insert the value NULL into column 'InvoiceDate', table
'DB1.Accounting.Invoices'; column
does not allow nulls. INSERT fails."
You
need to modify usp_InsertInvoice.sql to resolve the error.
How should you
modify the INSERT statement?
A. InvoiceDate varchar(l00) 'InvoiceDate',
B.
InvoiceDate varchar(100) 'Customer/InvoiceDate', '
C. InvoiceDate date
'@InvoiceDate',
D. InvoiceDate date 'Customer/@InvoiceDate',
Answer:
C
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?
A. FullName
nvarchar(100) NOT NULL CONSTRAINT DF_FuIlName DEFAULT
(dbo.CreateFullName
(FirstName, LastName)),
B. FullName AS (FirstName +'
'+ LastName),
C. FullName nvarchar(100) NOT NULL DEFAULT (dbo.CreateFullName
(FirstName, LastName)).
D. FullName AS (FirstName +' '+ LastName)
PERSISTED,
Answer:
D
NO.2
You are testing disaster recovery procedures.
You attempt to restore DB1 to a
different server and you receive the following error message: "Msg
33111.
Level 16, State 3, Line 1 Cannot find server certificate with
thumbprint
,0xA694FBEA88C9354E5E2567C30A2A69E8FB4C44A9\ Msg 3013, Level 16, State 1,
Line
1 RESTORE DATABASE is terminating abnormally."
You need to ensure
that you can restore DB1 to a different server.
Which code segment should you
execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer:
B
NO.3 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 SUM(@RowNumber) < (SELECT @counter
FROM @indextable)
B. WHILE @counter < (SELECT COUNT(RowNumber) FROM
@indextable)
C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM
@indextable)
D. WHILE @counter < (SELECT SUM(RowNumber) FROM
@indextabie)
Answer: B
NO.4 You execute usp_TestSpeakers.
You
discover that usp_SelectSpeakersByName uses inefficient execution plans.
You
need to update usp_SelectSpeakersByName to ensure that the most
efficient
execution plan is used.
What should you add at line 30 of
Procedures.sql?
A. OPTION (FORCESCAN)
B. OPTION (FORCESEEK)
C. OPTION
(OPTIMIZE FOR UNKNOWN)
D. OPTION (OPTIMIZE FOR (@LastName=
'Anderson'))
Answer:
C
NO.5
You need to convert the functionality of Legacy.sql to use a stored procedure.
Which code
segment should the stored procedure contain?
A. Option A
B.
Option B
C. Option C
D. Option D
Answer:
D
NO.6
You need to modify the function in CountryFromID.sql to ensure that the country
name is
returned instead of the country ID.
Which line of code should you
modify in CountryFromID.sql?
A. 04
B. 05
C. 06
D. 19
Answer:
D
NO.7
You need to create a function that filters invoices by CustomerID. The SELECT
statement
for the function is contained in InvoicesByCustomer.sql. Which code
segment should you use to
complete the function?
A. Option A
B. Option
B
C. Option C
D. Option D
Answer: A
NO.8 You attempt to process
an invoice by using usp_InsertInvoice.sql and you receive the following
error
message: "Msg 515, Level 16, State 2, Procedure usp_InsertInvoice,
Line
Cannot insert the value NULL into column 'InvoiceDate', table
'DB1.Accounting.Invoices'; column
does not allow nulls. INSERT fails."
You
need to modify usp_InsertInvoice.sql to resolve the error.
How should you
modify the INSERT statement?
A. InvoiceDate varchar(l00) 'InvoiceDate',
B.
InvoiceDate varchar(100) 'Customer/InvoiceDate', '
C. InvoiceDate date
'@InvoiceDate',
D. InvoiceDate date 'Customer/@InvoiceDate',
Answer:
C