Amazon Exam DAS-C01 Topic 3 Question 84 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 84
Topic #: 3

A data analyst is designing an Amazon QuickSight dashboard using centralized sales data that resides in Amazon Redshift. The dashboard must be restricted so that a salesperson in Sydney, Australia, can see only the Australia view and that a salesperson in New York can see only United States (US) data.

What should the data analyst do to ensure the appropriate data security is in place?

APlace the data sources for Australia and the US into separate SPICE capacity pools.

BSet up an Amazon Redshift VPC security group for Australia and the US.

CDeploy QuickSight Enterprise edition to implement row-level security (RLS) to the sales table.

DDeploy QuickSight Enterprise edition and set up different VPC security groups for Australia and the US.

Show Suggested Answer

Suggested Answer: B, C, D

by Ryan at Dec 23, 2023, 02:05 PM

Limited Time Offer

25%

Off

Get Premium DAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Celia

1 years ago

Good point. But I'm not sure about the file size recommendation. Keeping all files about the same size, between 1-5 GB, sounds more efficient than splitting them into KB-sized files.

upvoted 0 times

Kenneth

12 months ago

D) Keep all files about the same size

upvoted 0 times

...

Kayleigh

12 months ago

B) Partition the data based on the most common query predicates

upvoted 0 times

...

Rozella

12 months ago

A) Use a columnar storage file format

upvoted 0 times

...

Leonida

1 years ago

Absolutely, and partitioning the data based on common query predicates is also a great idea. That way, Redshift Spectrum can quickly identify the relevant partitions and avoid scanning unnecessary data.

upvoted 0 times

...

Juliana

1 years ago

I agree, this is a complex issue. From what I understand, we should definitely use a columnar storage file format like Parquet or ORC. That will help with efficient data access and processing.

upvoted 0 times

...

Robt

1 years ago

Hmm, this is a tricky question. We need to consider a few factors to improve Redshift Spectrum performance when querying S3 data files.

upvoted 0 times

...