PrepAway - Latest Free Exam Questions & Answers

Which object should you use for each table?

DRAG DROP
Note: This question is part of a series of questions that use the same scenario. For your convenience, the
scenario is repeated in each question. Each question presents a different goal and answer choices, but the text
of the scenario is exactly the same in each question in this series.
You have a database named Sales that contains the following database tables: Customer, Order, and
Products. The Products table and the Order table are shown in the following diagram.

The customer table includes a column that stores the data for the last order that the customer placed.
You plan to create a table named Leads. The Leads table is expected to contain approximately 20,000 records.
Storage requirements for the Leads table must be minimized.
Changes to the price of any product must be less a 25 percent increase from the current price. The shipping
department must be notified about order and shipping details when an order is entered into the database.
You need to implement the appropriate table objects.
Which object should you use for each table? To answer, drag the appropriate objects to the correct tables.
Each object may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
The Products table needs a primary key constraint on the ProductID field.
The Orders table needs a foreign key constraint on the productID field, with a reference to the ProductID field in
the Products table.

23 Comments on “Which object should you use for each table?”

  2. namh says:

    Pass this exam today, score 800
    44 questions in my exam
    + 10 new questions not have in this dump, but easy to answer
    + 10-15 question that you cannot change your answer when you click to next question, so read and answer your question carefully
    + 50% or more of the answers in this dump is wrong
    + the question in the exam are more detail than in this dump so you can understand and choose the correct answer




    18



    0
    1. Hai Dang says:

      “+ 10-15 question that you cannot change your answer when you click to next question, so read and answer your question carefully”
      All friend don’t worry about the issue! You can move on or tick remark questions, when you move to the last question, system shall remind you about answer isn’t finish/remark, so You can select again and finish it. I have met a problem for last test.




      1



      0
      1. Hai Dang says:

        I passed this module on Fri, Mar 09, 2018. Score 782. Only 40% question have been in dump. If you study the dump, You won’t pass a exam. And 60% question if you have knowledge about SQL server, you’ll pass. Answer original dump 50% is wrong, but many answer have adjusted correct in the comment.
        Good luck for all.




        6



        0
      2. xincheng888 says:

        When I took part in exam 70-767,I ticked “remark question” and hope I can leave them after I finish all other questions. They are all YES/NO questions. However I cannot choose question button at the end of exam. Even I can see all of these 9 remarked questions but I cannot make any answer for them. Total question 60 and I had to missed 9 of them!




        0



        0
  3. davgmane says:

    Orders = After Insert Trigger (to notify of the insert)
    Product = Check Constraint (make sure price is 25% increase)

    Not sure what the foreign & primary key have to do with anything.




    36



    8
    3. Benson Jutton says:

      Why is Product=Check Constraint (make sure price is 25% increase)? check constraint can only check the value being inserted, can’t refer to what it was before… surely this needs to be an instead of trigger, to validate the new data (new vs old virtual tables) and only update if valid and throw exception if not?




      26



      0
        2. 113 says:

          check constraints can’t do this validation.
          when a query is launched the first step is check the constraint before passing the query optimizer phase.if the check constraint gives FALSE an error is raised. only query parsing and algebrizer but no query optimizer /query plan is created and nothing is read from the actual values. so it’s not possibile to do a check constraints field <= field + filed*25/100 (you can do this ma it does not work).




          2



          0
  9. Donc says:

    How could a check constraint possibly work when there even isn’t a price column in the product table and a check constraint cannot access the previous value?




    1



    0

Leave a Reply