[Klimok]

I think this question still needs tweaking.

Partitioning by device assumes you’re interesting in a subset of devices rather than specific time horizons. However the questions mentions “study data changes over time that are stored in those files” so partitioning by time looks more suitable.

==

Also, I’d like to confirm why you refer to storage cost reduction when discussing partitioning – the idea is that grouping device’s data into a single daily file provides better compression vs saving it into 24 hourly buckets?

• This reply was modified 2 years, 8 months ago by  Klimok.

[Klimok]

Ok, thanks for explanations. If I understand you correctly, your point is that skewed KEY performance is still better than totally randomized EVEN.

[Klimok]

For 5TB one-time migration of a datacenter, Snowball (if not several Snowcones) will be a much faster and CHEAPER option. Again, that’s not a critical element in a DA question; but in a DB question set it would look very weird.

[Klimok]

Hi Joboy,

I actually found 1 question in your 2nd exam set. It’s about the max size of the item – 400k DDB vs 16MB DocDB. Also DocDB is a regional service while DDB can be global.

[Klimok]

Hi, I am joining the club of the people struggling with this question.

A Database Engineer plans to migrate an Oracle database instance running in the Northern California (us-west-1) region to an Amazon RDS for MySQL DB instance located in the Northern Virginia (us-east-1) region using AWS DMS. The source database is configured to dynamically transform and manipulate data using transformation rule expressions.

How should the engineer set up the AWS DMS replication instance to achieve the MOST optimal performance?

In Stephane’s course, he explicitly recommended placing the RI into the destination AZ. This article describes different configurations, all with RI in the Target VPC https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html

[Klimok]

Hi Carlo,

my impression that 95% of real exam and your questions are unambiguous, i.e. you can eliminate wrong items with 100% certainty. In this case there is a grey zone of two plausible answer, so I suggest to revise the scenario to allow logically arrive at the sole right answer. thanks