경쟁이 치열한 IT업계에서 굳굳한 자신만의 자리를 찾으려면 국제적으로 인정받는 IT자격증 취득은 너무나도 필요합니다. Microsoft SQL Server 2012 70-459시험은 IT인사들중에서 뜨거운 인기를 누리고 있습니다. Pass4Test는 IT인증시험에 대비한 시험전 공부자료를 제공해드리는 전문적인 사이트입니다.한방에 쉽게 Microsoft SQL Server 2012 70-459시험에서 고득점으로 패스하고 싶다면 Pass4Test의 Microsoft SQL Server 2012 70-459덤프를 선택하세요.저렴한 가격에 비해 너무나도 높은 시험적중율과 시험패스율, 언제나 여러분을 위해 최선을 다하는 Pass4Test가 되겠습니다.
NO.1 You plan to design an application that temporarily stores data in a SQL
Azure database.
You need to identify which types of database objects can be
used to store data for the application.
The solution must ensure that the
application can make changes to the schema of a temporary object
during a
session.
Which type of objects should you identify?
A. Common table
expressions (CTEs)
B. Temporary tables
C. Table variables
D. Temporary
stored procedures
Answer: B
NO.2
You need to monitor the health of your tables and indexes in order to implement
the required
index maintenance strategy.
What should you do?
A. Query
system DMVs to monitor avg_chain_length and max_chain_length. Create alerts to
notify
you when these values converge.
B. Create a SQL Agent alert when
the File Table: Avg time per file I/O request value is increasing.
C. Query
system DMVs to monitor total_bucket_count. Create alerts to notify you when this
value
increases.
D. Query system DMVs to monitor total_bucket_count.
Create alerts to notify you when this value
decreases.
Answer:
A
NO.3 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 (FCRCESCAN)
B. OPTION (OPTIMIZE FOR
UNKNOWN)
C. OPTION (OPTIMIZE FOR (@LastName = 'Anderson'))
D. OPTION
(FORCESEEK)
Answer: B
NO.4 You need to
recommend a disaster recovery strategy for the Inventory database.
What
should you include in the recommendation?
A. Log shipping
B. Always on
availability groups
C. SQL Server Failover Clustering
D. Peer-to-peer
replication
Answer: A
NO.5
You need to recommend a solution to allow application users to perform UPDATE
operations on
the database tables. The solution must meet the business
requirements.
What should you recommend?
A. Create a user-defined database
role and add users to the role.
B. Create stored procedures that use EXECUTE
AS clauses.
C. Create functions that use EXECUTE AS clauses.
D. Create a
Policy-Based Management Policy.
Answer: B
NO.6 You use SQL Server 2012
to maintain the data used by the applications at your company.
You plan to
create a table named Table1 by using the following statement. (Line numbers
are
included for reference only.)
You need to ensure that Table1 contains
a column named UserName.
The UserName column will:
- Store string values
in any language.
- Accept a maximum of 200 characters.
- Be case-sensitive
and accent-sensitive.
Which code segment should you add at line 03?
A.
UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
B. UserName
varchar(200) COLLATE Latin1_GeneraI_CI_AI NOT NULL,
C. UserName nvarchar(200)
COLLATE Latin1_General_CS_AS NOT NULL,
D. UserName varchar(200) COLLATE
Latin1_General_CS_AS NOT NULL,
E. UserName nvarchar(200) COLLATE
Latin1_General_CI_AS NOT NULL,
F. UserName varchar(200) COLLATE
Latin1_General_CI_AS NOT NULL,
Answer: C
NO.7 You
execute the following code.
You need to reduce the amount of time it takes to
execute the query. What should you do?
A. Change SUBSTRING(JobTitle,1, 1) =
'C' to JobTitle LIKE `C%'.
B. Partition the table and use the JobTitle column
for the partition scheme.
C. Replace IX_Employees with a clustered
index.
D. Change SUBSTRING (JobTitle, 1, 1) = 'C' to LEFT(JobTitle ,1) =
'C'.
Answer: A
NO.8
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
Azure database.
You need to identify which types of database objects can be
used to store data for the application.
The solution must ensure that the
application can make changes to the schema of a temporary object
during a
session.
Which type of objects should you identify?
A. Common table
expressions (CTEs)
B. Temporary tables
C. Table variables
D. Temporary
stored procedures
Answer: B
NO.2
You need to monitor the health of your tables and indexes in order to implement
the required
index maintenance strategy.
What should you do?
A. Query
system DMVs to monitor avg_chain_length and max_chain_length. Create alerts to
notify
you when these values converge.
B. Create a SQL Agent alert when
the File Table: Avg time per file I/O request value is increasing.
C. Query
system DMVs to monitor total_bucket_count. Create alerts to notify you when this
value
increases.
D. Query system DMVs to monitor total_bucket_count.
Create alerts to notify you when this value
decreases.
Answer:
A
NO.3 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 (FCRCESCAN)
B. OPTION (OPTIMIZE FOR
UNKNOWN)
C. OPTION (OPTIMIZE FOR (@LastName = 'Anderson'))
D. OPTION
(FORCESEEK)
Answer: B
NO.4 You need to
recommend a disaster recovery strategy for the Inventory database.
What
should you include in the recommendation?
A. Log shipping
B. Always on
availability groups
C. SQL Server Failover Clustering
D. Peer-to-peer
replication
Answer: A
NO.5
You need to recommend a solution to allow application users to perform UPDATE
operations on
the database tables. The solution must meet the business
requirements.
What should you recommend?
A. Create a user-defined database
role and add users to the role.
B. Create stored procedures that use EXECUTE
AS clauses.
C. Create functions that use EXECUTE AS clauses.
D. Create a
Policy-Based Management Policy.
Answer: B
NO.6 You use SQL Server 2012
to maintain the data used by the applications at your company.
You plan to
create a table named Table1 by using the following statement. (Line numbers
are
included for reference only.)
You need to ensure that Table1 contains
a column named UserName.
The UserName column will:
- Store string values
in any language.
- Accept a maximum of 200 characters.
- Be case-sensitive
and accent-sensitive.
Which code segment should you add at line 03?
A.
UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
B. UserName
varchar(200) COLLATE Latin1_GeneraI_CI_AI NOT NULL,
C. UserName nvarchar(200)
COLLATE Latin1_General_CS_AS NOT NULL,
D. UserName varchar(200) COLLATE
Latin1_General_CS_AS NOT NULL,
E. UserName nvarchar(200) COLLATE
Latin1_General_CI_AS NOT NULL,
F. UserName varchar(200) COLLATE
Latin1_General_CI_AS NOT NULL,
Answer: C
NO.7 You
execute the following code.
You need to reduce the amount of time it takes to
execute the query. What should you do?
A. Change SUBSTRING(JobTitle,1, 1) =
'C' to JobTitle LIKE `C%'.
B. Partition the table and use the JobTitle column
for the partition scheme.
C. Replace IX_Employees with a clustered
index.
D. Change SUBSTRING (JobTitle, 1, 1) = 'C' to LEFT(JobTitle ,1) =
'C'.
Answer: A
NO.8
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