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

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.

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

Get Premium Analytics-DA-201 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

31 comments · newest first

Galen 6 months ago

But what about B? Hyper files are important!

Fatima 7 months ago

I agree with D too. Data needs extraction for refresh.

Marsha 7 months ago

Because embedded credentials allow automatic access.

Von 7 months ago

Why A?

Marsha 7 months ago

I think A and D are the right answers.

Felix 7 months ago

This question is tricky!

Edwin 7 months ago

Definitely A) and D) for sure!

Carlene 8 months ago

I’m not sure about that, I thought live connections could work too.

Keith 8 months ago

Wait, does it really have to be a hyper file?

Jamie 8 months ago

I think B) is also a must!

Alyssa 9 months ago

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

Josephine 9 months ago

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

Anjelica 9 months ago

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

Raelene 9 months ago

A and C are the correct answers.

Ma 9 months 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.

Denny 9 months 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?

Coral 10 months ago

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

Lettie 10 months ago

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

Pamella 10 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.

Chara 10 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.

Kristel 10 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.

Selma 11 months ago

A) The credentials must be embedded.

Felix 11 months ago

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

Rozella 11 months ago

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

Vi 11 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.

Tayna 12 months ago

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

Fallon 6 months ago

↳ replying to Tayna

Extracting the data could simplify the refresh process.

Amie 6 months ago

↳ replying to Tayna

I think a live connection might complicate things.

Dwight 6 months ago

↳ replying to Tayna

But what about the hyper file requirement?

Claribel 10 months ago

↳ replying to Tayna

Definitely! Embedded credentials seem necessary.

Avery 11 months ago

↳ replying to Tayna

I agree, authentication is crucial for the refresh.

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