Certification Question: You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location

  • You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location.

    which three tasks should you include?(each correct answer presents part of the solution. choose three)

    A. Store all backup media offsite

    B. Script SQL Login accounts and credentials

    C. Install all SQL Server instances on a failover cluster.

    D. Maintain one list of all Windows logins and Passwords.

    E. Document the administrative processes and application access requirements.

    A, B AND E ARE THE CORRECT ANSWERS. BUT ARE THOSE REALLY THE MOST CORRECT ANSWERS?

    ===============================================================

    "lets do amazing" our company motto..

  • I don't think HP would be impressed with you cheating Raymund.


    Dird

  • jnuqui (6/7/2013)


    You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location.

    which three tasks should you include?(each correct answer presents part of the solution. choose three)

    A. Store all backup media offsite

    B. Script SQL Login accounts and credentials

    C. Install all SQL Server instances on a failover cluster.

    D. Maintain one list of all Windows logins and Passwords.

    E. Document the administrative processes and application access requirements.

    A, B AND E ARE THE CORRECT ANSWERS. BUT ARE THOSE REALLY THE MOST CORRECT ANSWERS?

    Yes, I would say so.

    D is just plain wrong, and C wouldn't help if the SAN/Hard-drive blows up.

    So you need A) Offsite Backup, so the backups are safe incase of a disaster such as a fire onsite.

    B) Logins aren't backed up in a database backup. They are related to the instance.

    E) Not sure why this would be required, but by process of elimination I'd include it as the 3rd option.

  • its not cheating. The answers are also given by other DBA's and not verified by MS. And how would you know really that this is the answer to the questions anyway? I review answers carefully and not just memorize this answers that are not 100% reliable.

    ===============================================================

    "lets do amazing" our company motto..

  • g_demetriou (6/7/2013)


    jnuqui (6/7/2013)


    You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location.

    which three tasks should you include?(each correct answer presents part of the solution. choose three)

    A. Store all backup media offsite

    B. Script SQL Login accounts and credentials

    C. Install all SQL Server instances on a failover cluster.

    D. Maintain one list of all Windows logins and Passwords.

    E. Document the administrative processes and application access requirements.

    A, B AND E ARE THE CORRECT ANSWERS. BUT ARE THOSE REALLY THE MOST CORRECT ANSWERS?

    Yes, I would say so.

    D is just plain wrong, and C wouldn't help if the SAN/Hard-drive blows up.

    So you need A) Offsite Backup, so the backups are safe incase of a disaster such as a fire onsite.

    B) Logins aren't backed up in a database backup. They are related to the instance.

    E) Not sure why this would be required, but by process of elimination I'd include it as the 3rd option.

    but answer A is a little confusing because of this keyword in the question "without requiring backup data center in a different location."

    ===============================================================

    "lets do amazing" our company motto..

  • jnuqui (6/7/2013)


    And how would you know really that this is the answer to the questions anyway?

    I would assume that the purpose of an exam is that you answer the questions to the best of your knowledge; not based on the answers you found on Google (away from MS's resources).


    Dird

  • Dird (6/7/2013)


    jnuqui (6/7/2013)


    And how would you know really that this is the answer to the questions anyway?

    I would assume that the purpose of an exam is that you answer the questions to the best of your knowledge; not based on the answers you found on Google (away from MS's resources).

    Not all the questions on this exam is based on the BOOK but based on situations. We don't encounter this kind of questions every time.

    Steve Jobs once said, There's no harm in asking questions, once you knew the answer share the answer to another person. 😛

    ===============================================================

    "lets do amazing" our company motto..

  • jnuqui (6/7/2013)but answer A is a little confusing because of this keyword in the question "without requiring backup data center in a different location."

    You're right it's a bit confusing, but an offsite backup doesn't necessarily have to be via a datacentre. Could be a physical storage device moved offsite. https://en.wikipedia.org/wiki/Off-site_data_protection

  • g_demetriou (6/7/2013)


    jnuqui (6/7/2013)but answer A is a little confusing because of this keyword in the question "without requiring backup data center in a different location."

    You're right it's a bit confusing, but an offsite backup doesn't necessarily have to be via a datacentre. Could be a physical storage device moved offsite. https://en.wikipedia.org/wiki/Off-site_data_protection%5B/quote%5D

    thanks for the info bro!

    ===============================================================

    "lets do amazing" our company motto..

  • Where did you get that question from?

    If it's one of those braindump sites with real questions regardless of where the answers came from, you may want to take a look at the exam rules before continuing.

    http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx#tab2

    The Examinee may be prohibited from taking any Microsoft Certification Exams, and/or may be decertified from Microsoft Certification Program if Examinee violates this Exam Agreement and/or engages in any misconduct. Proctors are authorized to take immediate and appropriate measures against Examinees who violate testing rules. This policy is enforced to ensure the integrity of the Exams and Microsoft Certification Program. Examples of misconduct and/or misuse of the Exam include, but are not limited to, the following:

    * Modifying and/or altering the original results/score report for this Exam or any other exam records

    * Violation of the current exam retake policy

    * Fraudulently impersonating another to gain access to the Exam

    * Submission of any work that is not completely your own

    * Providing or accepting improper assistance

    * Using unauthorized materials in an attempt to satisfy Exam requirements (this includes using brain-dump material and/or unauthorized publication of Exam questions with or without answers)

    * Disseminating actual Exam content

    *Possession of non-authorized items at the testing center during an Exam

    * Misconduct as determined by statistical analysis

    * Copying, publishing, disclosing, transmitting, selling, offering to sell, posting, downloading, distributing in any way, or otherwise transferring, modifying, making derivative works of, reverse engineering, decompiling, disassembling or translating any Exam in whole or in part, in any form or by any means, verbal or written, electronic or mechanical, for any purpose

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply