Sophia Introduction to Relational Databases Milestone_3.
3 views 0 purchase
Course
WGU CS1011
Institution
Western Governors University
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment.
Which type of backup would result in the fastest to RESTORE?
Nightly backup
Inc...
16 questions were answered correctly. 5 questions were answered incorrectly.
1
In each milestone, you may want or need to use the database
and query tool to answer some of the questions. We suggest you
open the tool in another browser tab while you are working on
this assessment.
https://postgres.sophia.org/
Which type of backup would result in the fastest to RESTORE?
Nightly backup
Incremental backup
Full backup
Differential backup
RATIONALE
, Full backups are a full copy of the entire data set. Although they
UNIT
are 3 protection,
the best — MILESTONE 3
they are time-consuming and quite large
to store. Incremental backups only back up the data that has
changed since the previous backup, even if it's another 16/21
incremental backup. These file sizes are the smallest out of the
are similar to incremental backups, but they start with a full
backup and include data since the prior full backup. At most, there
are only 2 backups to restore from.
CONCEPT
Backup Methods
Report an issue with this question
2
In each milestone, you may want or need to use the database
and query tool to answer some of the questions. We suggest you
open the tool in another browser tab while you are working on
this assessment.
https://postgres.sophia.org/
Which of the following scenarios reflects the
durability property?
The product quantity starts at 200.
Transaction 1 runs to read the quantity of the product to be updated.
Transaction 2 runs in parallel to read the quantity of the product to be updated
Transaction 1 updates the product quantity to reduce it by 100.
Transaction 2 updates the product quantity to reduce it by 5.
, UNIT 36. The product quantity ends
at— MILESTONE 3
16/21
1. A fairly large update is
made to the products table.
2. The update is saved to
the logs.
3. The update starts to then
save to the disk.
4. The system fails midway
through.
5. When the system starts back
up, the committed transactions
that haven't been written to disk
are written.
1. User 1 has $500 in their
online account.
2. User 2 has $300 in their online
account.
3. User 1 sends user 2 $100.
4. User 1 has $400 in
their account.
5. User 2 has $300 in their
account.
5. The transaction is reverted.
1. Transaction 1 reads a
product's cost which is set at
$100.
2. Transaction 1 updates the
product to set the price to
$90.
3. Transaction 2 reads the
same product's cost and sees
$100.
4. Transaction 1 commits the cost.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ACADEMICAIDSTORE. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.00. You're not tied to anything after your purchase.
