Latest DAS-C01 Exam Questions

A company has developed an Apache Hive script to batch process data stared in Amazon S3. The script needs to run once every day and store the output in Amazon S3. The company tested the script, and it completes within 30 minutes on a small local three-node cluster.
Which solution is the MOST cost-effective for scheduling and executing the script?

A financial company uses Amazon S3 as its data lake and has set up a data warehouse using a multi-node Amazon Redshift cluster. The data files in the data lake are organized in folders based on the data source of each data file. All the data files are loaded to one table in the Amazon Redshift cluster using a separate COPY command for each data file location. With this approach, loading all the data files into Amazon Redshift takes
a long time to complete. Users want a faster solution with little or no increase in cost while maintaining the segregation of the data files in the S3 data lake.
Which solution meets these requirements?

A company uses Amazon Elasticsearch Service (Amazon ES) to store and analyze its website clickstream
data. The company ingests 1 TB of data daily using Amazon Kinesis Data Firehose and stores one day’s worth
of data in an Amazon ES cluster.
The company has very slow query performance on the Amazon ES index and occasionally sees errors from
Kinesis Data Firehose when attempting to write to the index. The Amazon ES cluster has 10 nodes running a
single index and 3 dedicated master nodes. Each data node has 1.5 TB of Amazon EBS storage attached and
the cluster is configured with 1,000 shards. Occasionally, JVMMemoryPressure errors are found in the cluster
logs.
Which solution will improve the performance of Amazon ES?

A media analytics company consumes a stream of social media posts. The posts are sent to an Amazon Kinesis data stream partitioned on user_id. An AWS Lambda function retrieves the records and validates the content  before loading the posts into an Amazon Elasticsearch cluster. The validation process needs to receive the posts for a given user in the order they were received. A data analyst has noticed that, during peak hours, the social media platform posts take more than an hour to appear in the Elasticsearch cluster. What should the data analyst do reduce this latency?

A mobile gaming company wants to capture data from its gaming app and make the data available for analysis
immediately. The data record size will be approximately 20 KB. The company is concerned about achieving
optimal throughput from each device. Additionally, the company wants to develop a data stream processing
application with dedicated throughput for each consumer.
Which solution would achieve this goal?

A streaming application is reading data from Amazon Kinesis Data Streams and immediately writing the data
to an Amazon S3 bucket every 10 seconds. The application is reading data from hundreds of shards. The batch
interval cannot be changed due to a separate requirement. The data is being accessed by Amazon Athena.
Users are seeing degradation in query performance as time progresses.
Which action can help improve query performance?

A company that produces network devices has millions of users. Data is collected from the devices on an
hourly basis and stored in an Amazon S3 data lake.
The company runs analyses on the last 24 hours of data flow logs for abnormality detection and to
troubleshoot and resolve user issues. The company also analyzes historical logs dating back 2 years to discover
patterns and look for improvement opportunities.
The data flow logs contain many metrics, such as date, timestamp, source IP, and target IP. There are about 10
billion events every day.
How should this data be stored for optimal performance?

A company wants to improve user satisfaction for its smart home system by adding more features to its
recommendation engine. Each sensor asynchronously pushes its nested JSON data into Amazon Kinesis Data
Streams using the Kinesis Producer Library (KPL) in Java. Statistics from a set of failed sensors showed that,
when a sensor is malfunctioning, its recorded data is not always sent to the cloud.
The company needs a solution that offers near-real-time analytics on the data from the most updated sensors.
Which solution enables the company to meet these requirements?

A media company wants to perform machine learning and analytics on the data residing in its Amazon S3 data lake. There are two data transformation requirements that will enable the consumers within the company to create reports:
Daily transformations of 300 GB of data with different file formats landing in Amazon S3 at a scheduled
time.
One-time transformations of terabytes of archived data residing in the S3 data lake.
Which combination of solutions cost-effectively meets the company’s requirements for transforming the data? (Choose three.)

An Amazon Redshift database contains sensitive user data. Logging is necessary to meet compliance
requirements. The logs must contain database authentication attempts, connections, and disconnections. The logs must also contain each query run against the database and record which database user ran each query. Which steps will create the required logs?