Nothing can stop the free 70-229

1. You are designing an inventory and shipping database for Contoso.Ltd. You create the logical
database design shown in the exhibit.
You must ensure that the referential integrity of the database is maintained. which three types of
constraints should you apply to your design?

A. Create a FOREIGN KEY constraint on the Products table that references the Order Details table

B. Create a FOREIGN KEY constraint on the Products table that references the Suppliers table

C. Create a FOREIGN KEY constraint on the Orders table that references the Order Details table

D. Create a FOREIGN KEY constraint on the Order Details table that references the Orders table

E. Create a FOREIGN KEY constraint on the Order Details table that references the Products table

F. Create a FOREIGN KEY constraint on the Suppliers table that references the Products table
Answer: BDE


2. You are designing a database for Tailspin Toys. You review the database design. which is shown in the
exhibit
You want to promote quick response times for queries and minimize redundant data. what should you do?

A. Create a new table named CustomerContact. Add CustomerID,ContactName,and Phone columns to
this table

B. Create a new composite PK constraint on the Orderdetails table Include the OrderID,ProductId and
CustomerIDcomlumns in the contraint

C. Remove the PK constraint from the OrderDetails table Use and IDENTITY column to create a
surrogate key for theOrderDetails table

D. Remove the CustomerID column from the OrderDetails table

E. Remove the Quantity column from the OrderDetails table Add a Quantity column to the Orders table
Answer: D