Discuss Salesforce Analytics-Con-301 Exam Topic 4 Question 5

A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.

They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse

structure.

What should the client do to achieve the desired result?

ACreate a temporary table in the database.

BUse Tableau Desktop to visualize null values.

CUpdate the Widget Inventory Table to be a daily snapshot.

DUse Tableau Prep to add new rows.

Suggested Answer: D

For a client who needs a daily visualization of widget inventory but cannot modify the data warehouse structure, the best approach is to use Tableau Prep to add new rows. Tableau Prep can be used to manipulate the existing dataset by adding missing date entries and appropriately adjusting inventory counts based on available data. This allows the creation of a complete daily snapshot for visualization without needing changes to the underlying database structure.

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

15 comments · newest first

Marylin 10 months ago

Wait, can they really visualize null values in Tableau?

Carma 11 months ago

Updating the table for daily snapshots sounds like a hassle.

Gail 11 months ago

A temporary table could work well for this!

Paris 11 months ago

I think using Tableau Prep is a better option.

In 11 months ago

Not sure if a temporary table is the best solution here.

Mona 11 months ago

I practiced a similar question where we had to use Tableau Prep to manipulate data. It seems like adding new rows could help, but I'm not confident if that's the best approach here.

Nobuko 12 months ago

I feel like updating the Widget Inventory Table to be a daily snapshot could be too much if they can't modify the data warehouse structure.

Loren 12 months ago

I'm not entirely sure, but I think using Tableau Desktop to visualize null values might not solve the underlying issue of missing data.

Oren 1 year ago

I remember we discussed how temporary tables can be useful for creating snapshots of data without altering the original structure. That might be a good option here.

Rodolfo 1 year ago

Using Tableau Prep to add new rows could be an interesting approach, but I'm not sure if that's the most efficient solution given the limitations. I'll need to carefully consider all the options.

Emiko 1 year ago

Creating a temporary table in the database seems like a straightforward solution, but I'm not sure if that's allowed given the constraints. I'll need to think through the pros and cons of each option.

Verdell 1 year ago

Alright, I've got a strategy in mind. I think updating the Widget Inventory Table to be a daily snapshot could be the way to go, but I'll need to double-check that it meets the requirement of not modifying the data warehouse structure.

Lavonna 1 year ago

Okay, let's see here. I'm a bit confused by the nonstandard schedule for the data updates. I'll need to make sure I understand that part before deciding on a solution.

Kizzy 1 year ago

Hmm, this looks like a tricky one. I'll need to think through the options carefully to figure out the best approach.

Jani 1 year ago

I think the client should update the Widget Inventory Table to be a daily snapshot.

Salesforce Analytics-Con-301 Exam - Topic 4 Question 5 Discussion