Question 1

A company needs to build a data pipeline to process a 1-TB file from an Amazon S3 bucket. The pipeline needs to create three DataFrames based on business logic. The pipeline must save all three DataFrames to a second S3 bucket in parallel. The company needs to set the pipeline to be the target of an Amazon EventBridge rule that matches file uploads to the source S3 bucket.
Which solution will meet these requirements with the LEAST maintenance overhead?
  • Question 2

    A mobile gaming company wants to capture data from its gaming app. The company wants to make the data available to three internal consumers of the data. The data records are approximately 20 KB in size.
    The company wants to achieve optimal throughput from each device that runs the gaming app.
    Additionally, the company wants to develop an application to process data streams. The stream- processing application must have dedicated throughput for each internal consumer.
    Which solution will meet these requirements?
  • Question 3

    Data Engineer wants to analyze query performance & looking out for profiling information, He went to Query/Operator Details also called Profile Overview of Query Profile Interface & searching for statistics attributes around I/O. Which of the following information he can't get from there?
  • Question 4

    While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?
  • Question 5

    A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.
    The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.
    Which AWS service should the company use to meet these requirements?