Data Management: Quiz

These questions are designed to be similar to ones that will be asked on certification exams.  Aim to get most of these questions correct on the first attempt.

To view the remainder of this content, you must purchase the Certified Administrator Study Guide.  Please Login or purchase the study guide.

15 Responses to “Data Management: Quiz”

  1. Russell Gibbins October 23, 2013 at 6:22 pm #

    the second answer appears to use Instruction instead of Instruct.
    Small typo replace Instructions with Instruct.

  2. Muge Onder December 5, 2013 at 10:02 am #

    Hello ,

    For question 2, On Salesforce Help Portal, It advices when to use Data Loader and says :” You want to export your data for backup purposes” So the answer can also be “a”?

    • JohnCoppedge December 6, 2013 at 9:55 pm #

      Typically you would use the weekly export to backup all data in your org – this is much faster than exporting each table on its own (which would be the case using the data loader).

      To backup a few tables of data, absolutely use the data loader. Does that clarify?

  3. Kaira Bergstra January 14, 2014 at 8:10 pm #

    “Provide users a lead upload template file that matches the field naming convention used in Salesforce. This will ensure that fields are automatically mapped when using an import wizard. ”

    — How do you do that? I tried the Lead import wizard, and didn’t see the option to select a mapping file (in Data Loader, I have seen the option to load a saved mapping).

    • JohnCoppedge January 16, 2014 at 11:38 pm #

      With the data import wizard you can name the columns the same as the field label (e.g. “First Name” would automatically map to the first name field on the lead). This is essentially a manual process – name the fields, test the template to ensure the fields match, then distribute. This has a similar result of storing the saved field mapping the data loader (although not as cleanly).

      This question will likely go away when the new data import wizard is officially released.

  4. Erik Granered March 16, 2014 at 6:47 pm #

    In question 3, the Data Management | Mass Transfer Records function is not called a wizard in Salesforce. Got the question right but the wording confused me a little.

  5. Alex Messinger February 20, 2015 at 3:08 pm #

    Does data import through the API trigger validation rules? I am having trouble finding a definitive answer.

  6. sheiscindy July 31, 2015 at 1:02 am #

    For the question, “The sales team wants to prevent sales reps from entering an opportunity close date more than 1 year from today’s date. Instead of pushing the close date this far, the opportunity should be marked as Closed/Lost and the account revisited in one year. How should this be enforced?” – Correct answer is Validation Rule. Which to me is accurate for actually enforcing the first sentence. But I went off on a Workflow Rule train of thought when reading the second sentence to take care of automatically marking the record closed/lost. I wasn’t familiar enough with the Opportunities process, so I understand now. Just wanted to let you know the 2nd sentence threw me off.

    • JohnCoppedge August 5, 2015 at 2:35 am #

      Totally understand that train of thought – the key word is “prevent” in this example. If workflow were also a possible answer, that would make the question much more ambiguous.

  7. kuhnflyfish August 7, 2015 at 3:58 pm #

    Hey John, shouldn’t question 3’s validation rule be:
    CloseDate (TODAY() + 365) GREATER THAN?
    Minor deal but just wanted to make sure.


    • kuhnflyfish August 7, 2015 at 3:59 pm #

      That didn’t post what I wrote……symbol should be LESS THAN instead of GREATER THAN CORRECT?

      • JohnCoppedge August 17, 2015 at 7:47 pm #

        No – the validation rule will take effect when the condition is true – therefore you want to specify that close date is greater than one year out.

Leave a Reply