Free Amazon BDS-C00 Exam Dumps and BDS-C00 Exam Questions

Question No: 1

MultipleChoice

A company uses Amazon Redshift for its enterprise data warehouse. A new op-premises PostgreSQL OLTP DB must be integrated into the data warehouse. Each table in the PostgreSQL DB has an indexed last_modified timestamp column. The data warehouse has a staging layer to load source data into the data warehouse environment for further processing.

The data log between the source PostgreSQL DB and the Amazon Redshift staging layer should NOT exceed four hours.

What is the most efficient technique to meet these requirements?

Options

ACreate a DBLINK on the source DB to connect to Amazon Redshift. Use a PostgreSQL trigger on the source table to capture the new insert/update/delete event and execute the event on the Amazon Redshift staging table.

BUse a PostgreSQL trigger on the source table to capture the new insert/update/delete event and write it to Amazon Kinesis Streams. Use a KCL application to execute the event on the Amazon Redshift staging table.

CExtract the incremental changes periodically using a SQL query. Upload the changes to multiple Amazon Simple Storage Service (S3) objects and run the COPY command to load the Amazon Redshift staging table.

DExtract the incremental changes periodically using a SQL query. Upload the changes to a single Amazon Simple Storage Service (S3) object run the COPY command to load to the Amazon Redshift staging layer.

Question No: 2

MultipleChoice

Can the string value of 'Key' be prefixed with laws?

Options

ANo

BOnly for EC2 not S3

CYes

DOnly for S3 not EC

Question No: 3

MultipleChoice

Amazon S3 doesn't automatically give a user who creates _____ permission to perform other actions on that bucket or object.

Options

Aa file

Ba bucket or object

Ca bucket or file

Da object or file