PrepAway - Latest Free Exam Questions & Answers

Which storage mechanism should you use?

DRAG DROP
You must create two staging database tables. The tables have the following requirements:

You need to select the correct storage mechanism for each table.
Which storage mechanism should you use? To answer, drag the appropriate table types to the correct tables.
Each table type 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:

3 Comments on “Which storage mechanism should you use?

  1. ERod says:

    In my opinion, the answer should be:
    Table 1 – Memory-optimized table
    Table 2 – Memory-optimized non-durable table.
    Why?
    We are working with staging tables.Table 1 – should be disk-based table but I think it is better to use a memory-optimized table because it most convenient for staging tables.
    Table 2 – Memory-optimized non-durable table convenient for multiple concurrent connections. Using Lazy commit to reduce I/O operations. Also, you can tolerate any data loss because the CSV files must be available.




    4



    7

Leave a Reply