Salesforce Analytics-DA-201 Exam - Topic 4 Question 9 Discussion

Actual exam question for Salesforce's Analytics-DA-201 exam

Question #: 9
Topic #: 4

[All Analytics-DA-201 Questions]

You have a workbook that connects to a database. The database requires authentication.

You plan to publish the workbook and schedule a daily refresh of the data.

Which two conditions must be met to schedule the refresh? Choose two.

AThe credentials must be embedded.

BThe data source must be stored as a hyper file.

CThe data source must use a live connection.

DThe data must be extracted.

Show Suggested Answer

Suggested Answer: A, D

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Publishing and Scheduling Data Refreshes''

Tableau Help: Embedding Database Credentials

Tableau Help: Extract Your Data

by Dean at Nov 24, 2025, 12:55 PM

Limited Time Offer

25%

Off

Get Premium Analytics-DA-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jamie

3 days ago

I think B) is also a must!

upvoted 0 times

...

Alyssa

8 days ago

Haha, who needs credentials? Just use the database admin's password and you're good to go!

upvoted 0 times

...

Josephine

13 days ago

Definitely A and C. Gotta have those credentials embedded and a live connection to the database.

upvoted 0 times

...

Anjelica

18 days ago

I think B and D are the right choices. Embedding the credentials and using a live connection are important.

upvoted 0 times

...

Raelene

24 days ago

A and C are the correct answers.

upvoted 0 times

...

Ma

29 days ago

I feel like I’ve seen options where live connections were mentioned, but I can’t recall if they’re necessary for scheduling a refresh.

upvoted 0 times

...

Denny

1 month ago

I’m a bit confused; does the data source need to be a hyper file, or is it enough for it to just be extracted?

upvoted 0 times

...

Coral

1 month ago

I remember practicing a question like this, and I think the data source has to be extracted to schedule the refresh.

upvoted 0 times

...

Lettie

1 month ago

I think the credentials need to be embedded for the refresh to work, but I'm not sure about the second condition.

upvoted 0 times

...

Pamella

2 months ago

Alright, I think I've got this. The key is that the database requires authentication, so the credentials need to be embedded. And since we want to schedule a daily refresh, the data source has to use a live connection. A and C are the way to go.

upvoted 0 times

...

Chara

2 months ago

Hmm, this is a tricky one. I'm not totally clear on the difference between a live connection and a hyper file. I'll need to read the question carefully and think through the implications of each option.

upvoted 0 times

...

Kristel

2 months ago

I've done something similar before, so I've got a good handle on this. I'm pretty sure the credentials need to be embedded, and the data source has to use a live connection. I'll double-check, but I think A and C are the right answers.

upvoted 0 times

...

Selma

2 months ago

A) The credentials must be embedded.

upvoted 0 times

...

Felix

3 months ago

Not necessary for scheduling, though. A and D cover it.

upvoted 0 times

...

Rozella

3 months ago

Wait, we're supposed to schedule a refresh? I thought we just had to publish the workbook and call it a day.

upvoted 0 times

...

Vi

3 months ago

Okay, let me think this through. I know the data source needs to be live, so that rules out option D. But I'm not sure about the other conditions - I'll have to review the details on embedding credentials and using a hyper file.

upvoted 0 times

...

Tayna

3 months ago

Hmm, this seems pretty straightforward. I think the key is understanding the database authentication requirements and how that impacts the refresh options.

upvoted 0 times

Claribel

2 months ago

Definitely! Embedded credentials seem necessary.

upvoted 0 times

...

Avery

3 months ago

I agree, authentication is crucial for the refresh.

upvoted 0 times

...