[Free] Get all latest Microsoft 70-433 Actual Tests 161-170

Ensurepass

QUESTION 161

You are a database developer responsible for maintaining an application.

 

The application has a table named Programs that has the following definition:

 

clip_image002

 

You need to modify the Customers table to meet the following requirements:

 

Which Transact-SQL statement or statements should you use?

 

clip_image004

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: B

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 162

DRAG DROP

You create a database named AdventureWorks. You want to create a new table to store customer reviews for all products within the database.

 

The table must meet the following requirements:

 

Which three Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

 

clip_image006

 

Correct Answer:

clip_image008

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 163

You administer a Microsoft SQL Server 2008 database that contains a table named Sales.SalesOrderDetail and a view named Sales.ProductOrders.

 

The view has the following definition:

 

clip_image009

 

The Sales.SalesOrderDetail table contains 5 million rows. Report queries that join to this view consume excessive disk I/O.

 

You need to create an index on the view.

 

Which Transact-SQL statement or statements should you use?

 

clip_image011

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: C

 

 

 

 

 

QUESTION 164

You administer a Microsoft SQL Server 2008 database for an inventory management

system.

 

The application contains a product table that has the following definition:

 

clip_image012

 

You want to add a new field to the Product table to meet the following requirements:

 

You need to add a field named User_Data_1 to support integer values ranging from -10 through 10.

 

Which SQL statement should you use?

 

A.

ALTER TABLE [Production].[Product] ADD [User_Data_1] TINYINT

B.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLINT

C.

ALTER TABLE [Production].[Product] ADD [User_Data_1] INT

D.

ALTER TABLE [Production].[Product] ADD [User_Data_1] BIGINT

E.

ALTER TABLE [Production].[Product] ADD [User_Data_1] BIT

F.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(11,6)

G.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(6,11)

H.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(5,6)

I.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLMONEY

J.

ALTER TABLE [Production].[Product] ADD [User_Data_1] MONEY

K.

ALTER TABLE [Production].[Product] ADD [User_Data_1] CHAR(100)

L.

ALTER TABLE [Production].[Product] ADD [User_Data_1] VARCHAR(100)

M.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NCHAR(100)

N.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NVARCHAR(100)

O.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLDATETIME

P.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME

Q.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME2

R.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATE

 

Correct Answer: B

 

 

 

QUESTION 165

You administer a Microsoft SQL Server 2008 database for an inventory management system.

 

The application contains a product table that has the following definition:

 

clip_image013

 

You want to add a new field to the Product table to meet the following requirements:

 

You need to add a field named User_Data_1 to support only values that are 1 or 0.

 

A.

ALTER TABLE [Production].[Product] ADD [User_Data_1] TINYINT

B.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLINT

C.

ALTER TABLE [Production].[Product] ADD [User_Data_1] INT

D.

ALTER TABLE [Production].[Product] ADD [User_Data_1] BIGINT

E.

ALTER TABLE [Production].[Product] ADD [User_Data_1] BIT

F.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(11, 6)

G.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(6, 11)

H.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(5,6)

I.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLMCNEY

J.

ALTER TABLE [Production].[Product] ADD [User_Data_1] MONEY

K.

ALTER TABLE [Production].[Product] ADD [User_Data_1] CHAR(100)

L.

ALTER TABLE [Production].[Product] ADD [User_Data_1] VARCHAR(100)

M.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NCHAR(100)

N.

ALTER TABLE [Production].[Product] ADD [User_Data_1] NVARCHAR(100)

O.

ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLDATETIME

P.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME

Q.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME2

R.

ALTER TABLE [Production].[Product] ADD [User_Data_1] DATE

 

Correct Answer: E

 

 

 

 

 

QUESTION 166

You administer a Microsoft SQL Server 2008 database that contains a table named dbo.SalesOrders.

 

The table has the following definition:

 

clip_image014

 

The SalesOrder table contains one million rows.

 

You want to create a report that meets the following requirements:

 

clip_image015

 

You need to execute a Transact-SQL query to generate the report.

 

Which Transact-SQL query should you use?

 

clip_image017

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: D

 

 

QUESTION 167

You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports. You need to force a query to use only one processor core without affecting other queries. Which option should you use?

 

A.

OPTION (MAXDOP 1)

B.

OPTION (MAXDOP 16)

C.

OPTION (MAXDOP 0)

D.

OPTION (MAXDOP 4)

 

Correct Answer: A

 

 

QUESTION 168

You are a developer for a Microsoft SQL Server 2008 R2 database instance.

 

You create tables named order, customer, and product as follows:

 

clip_image018

 

You need to write a query to identify all customers who have ordered for an average amount of more than 500 or more from September 01, 2011.

 

Which SQL query should you use?

 

clip_image019

clip_image021

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

F.

Option F

G.

Option G

H.

Option H

I.

Option I

J.

Option J

 

Correct Answer: E

 

 

QUESTION 169

You are a developer for a Microsoft SQL Server 2008 R2 database instance. You create tables named order, customer, and product as follows:

 

clip_image022

 

You need to write a query to sum the sales of all orders by the following entries:

 

Which SQL query should you use?

 

clip_image023

clip_image024

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

F.

Option F

G.

Option G

H.

Option H

I.

Option I

J.

Option J

 

Correct Answer: G

 

 

QUESTION 170

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as follows:

 

clip_image025

 

You need to write a query to return all customer names and total number of complaints for customers who have made more than 10 complaints.

 

Which SQL query should you use?

 

clip_image026

clip_image027

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

F.

Option F

G.

Option G

H.

Option H

I.

Option I

J.

Option J

 

Correct Answer: D

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-433 Real Exam

Instant Access to Try Microsoft 70-433 Free Demo

This entry was posted in 70-433 Actual Tests and tagged , , , , , . Bookmark the permalink.