Ensurepass

QUESTION 31

Drag Drop

You have a table named Table1 that contains 1 million rows. Table1 contains a column named

Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type. You have a

certificate named Cert1. You need to replace Column1 with a new encrypted column that uses

two-way encryption. Which code segment should you execute before you remove Column1?

 

To answer, move the appropriate code segments from the list of code segments to the answer

area and arrange them in the correct order.

 

Build List and Reorder:

70-459-demo-18

 

Correct Answer:

70-459-demo-19

 

 

QUESTION 32

DRAG DROP

You execute the following code:

 

CREATE TABLE Customers(

ID int PRIMARY KEY,

Name nchar(10))

GO

 

You discover that the Customers table was created in the dbo schema. You need to create a code

segment to move the table to another schema named Schema2. What should you create?

 

To answer, drag the appropriate code segments to the correct location in the answer area.

 

Build List and Reorder:

70-459-demo-20

 

Correct Answer:

70-459-demo-21

 

 

QUESTION 33

DRAG DROP

You plan to deploy SQL Server 2012. Your company identifies the following monitoring

requirements for the database:

 

  • An e-mail message must be sent if the SQL Server Authentication mode changes.

  • An e-mail message must be sent if CPU utilization exceeds 90 percent.

 

You need to identify which feature meets each monitoring requirement. Which features should

you identify?

 

To answer, drag the appropriate feature to the correct monitoring requirement in the answer

area.

 

Select and Place:

70-459-demo-22

 

Correct Answer:

70-459-demo-23

 

 

QUESTION 34

DRAG DROP

You are designing two stored procedures named Procedure1 and Procedure2.

 

You identify the following requirements:

 

  • Procedure1 must take a parameter that ensures that multiple rows of data can pass into the

stored procedure.

  • Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.

 

You need to identify the appropriate technology for each stored procedure. Which technologies

should you identify?

 

To answer, drag the appropriate technology to the correct stored procedure in the answer area.

(Answer choices may be used once, more than once, or not at all.)

 

Select and Place:

70-459-demo-24

 

Correct Answer:

70-459-demo-25

 

 

QUESTION 35

DRAG DROP

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that

will have the following specifications:

 

  • Table1 will contain a date column named Column1 that will contain a null value

approximately 80 percent of the time.

  • Table2 will contain a column named Column2 that is the product of two other columns in

Table2.

  • Both Table1 and Table2 will contain more than 1 million rows.

 

You need to recommend which options must be defined for the columns. The solution must

minimize the storage requirements for the tables. Which options should you recommend?

 

To answer, drag the appropriate options to the correct column in the answer area.

 

Select and Place:

70-459-demo-26

 

Correct Answer:

70-459-demo-27

 

 

QUESTION 36

DRAG DROP

You are designing a database for a university. The database will contain two tables named Classes and StudentGrades that have the following specifications:

 

  • Classes will store brochures in the XPS format.

  • The brochures must be structured in folders and must be accessible by using UNC paths.

  • StudentGrades must be backed up on a separate schedule than the rest of the database.

 

You need to identify which SQL Server technology meets the specifications of each table. Which

technologies should you identify?

 

To answer, drag the appropriate technology to the correct table in the answer area.

 

Select and Place:

70-459-demo-28

 

Correct Answer:

70-459-demo-29

 

 

QUESTION 37

DRAG DROP

You have a SQL Azure database named Database1. You need to design the schema for a table

named table1. Table1 will have less than one million rows. Table1 will contain the following

information for each row:

 

70-459-demo-30

 

The solution must minimize the amount of space used to store each row. Which data types

should you recommend for each column?

 

To answer, drag the appropriate data type to the correct column in the answer area.

 

Select and Place:

70-459-demo-31

 

Correct Answer:

70-459-demo-32

 

 

QUESTION 38

DRAG DROP

You are designing an authentication strategy for a new server that has SQL Server 2012 installed.

The strategy must meet the following business requirements:

 

  • The account used to generate reports must be allowed to make a connection during certain

hours only.

  • Failed authentication requests must be logged.

 

You need to recommend a technology that meets each business requirement. The solution must

minimize the amount of events that are logged. Which technologies should you recommend?

 

To answer, drag the appropriate solution to the correct business requirement in the answer area.

 

Select and Place:

70-459-demo-33

 

Correct Answer:

70-459-demo-34

 

 

QUESTION 39

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?

 

  1. Common table expressions (CTEs)

  2. Temporary tables

  3. Table variables

  4. Temporary stored procedures

 

Correct Answer: B

 

 

QUESTION 40

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

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-459 Real Exam

Try Microsoft MCSE 70-459 Free Demo

You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute

Proc1. What should you do?

 

  1. Run the following: ALTER TABLE Sales ALTER COLUMN OrderDate datetime NOT NULL;

 

  1. Change the WHERE clause to the following:

WHERE OrderDate BETWEEN CAST(@date1,char(10)) AND CAST(@date2,char(10))

 

  1. Remove the ORDER BY clause from the stored procedure.

 

  1. Run the following:

DROP INDEX IX_Sales_OrderDate;

GO

CREATE INDEX IX_Sales_OrderDate ON Sales(OrderDate);

GO

 

Correct Answer: C

 

Comments are closed.