All About Actual DAS-C01 Preparation Labs

NEW QUESTION 1
A large company has a central data lake to run analytics across different departments. Each department uses a separate AWS account and stores its data in an Amazon S3 bucket in that account. Each AWS account uses the AWS Glue Data Catalog as its data catalog. There are different data lake access requirements based on roles. Associate analysts should only have read access to their departmental data. Senior data analysts can have access in multiple departments including theirs, but for a subset of columns only.
Which solution achieves these required access patterns to minimize costs and administrative tasks?

• A. Consolidate all AWS accounts into one accoun
• B. Create different S3 buckets for each department and move all the data from every account to the central data lake accoun
• C. Migrate the individual data catalogs into a central data catalog and apply fine-grained permissions to give to each user the required access to tables and databases in AWS Glue and Amazon S3.
• D. Keep the account structure and the individual AWS Glue catalogs on each accoun
• E. Add a central data lake account and use AWS Glue to catalog data from various account
• F. Configure cross-account access for AWS Glue crawlers to scan the data in each departmental S3 bucket to identify the schema and populate the catalo
• G. Add the senior data analysts into the central account and apply highly detailed access controls in the Data Catalog and Amazon S3.
• H. Set up an individual AWS account for the central data lak
• I. Use AWS Lake Formation to catalog the cross- account location
• J. On each individual S3 bucket, modify the bucket policy to grant S3 permissions to the Lake Formation service-linked rol
• K. Use Lake Formation permissions to addfine-grained access controls to allow senior analysts to view specific tables and columns.
• L. Set up an individual AWS account for the central data lake and configure a central S3 bucke
• M. Use an AWS Lake Formation blueprint to move the data from the various buckets into the central S3 bucke
• N. On each individual bucket, modify the bucket policy to grant S3 permissions to the Lake Formation service-linked rol
• O. Use Lake Formation permissions to add fine-grained access controls for both associate and senior analysts to view specific tables and columns.

Answer: C

Explanation:
Lake Formation provides secure and granular access to data through a new grant/revoke permissions model that augments AWS Identity and Access Management (IAM) policies. Analysts and data scientists can use the full portfolio of AWS analytics and machine learning services, such as Amazon Athena, to access the data. The configured Lake Formation security policies help ensure that users can access only the data that they are authorized to access. Source : https://docs.aws.amazon.com/lake-formation/latest/dg/how-it-works.html

NEW QUESTION 2
A retail company has 15 stores across 6 cities in the United States. Once a month, the sales team requests a visualization in Amazon QuickSight that provides the ability to easily identify revenue trends across cities and stores. The visualization also helps identify outliers that need to be examined with further analysis.
Which visual type in QuickSight meets the sales team's requirements?

• A. Geospatial chart
• B. Line chart
• C. Heat map
• D. Tree map

Answer: A

NEW QUESTION 3
A transportation company uses IoT sensors attached to trucks to collect vehicle data for its global delivery fleet. The company currently sends the sensor data in small .csv files to Amazon S3. The files are then loaded into a 10-node Amazon Redshift cluster with two slices per node and queried using both Amazon Athena and Amazon Redshift. The company wants to optimize the files to reduce the cost of querying and also improve the speed of data loading into the Amazon Redshift cluster.
Which solution meets these requirements?

• A. Use AWS Glue to convert all the files from .csv to a single large Apache Parquet fil
• B. COPY the file into Amazon Redshift and query the file with Athena from Amazon S3.
• C. Use Amazon EMR to convert each .csv file to Apache Avr
• D. COPY the files into Amazon Redshift and query the file with Athena from Amazon S3.
• E. Use AWS Glue to convert the files from .csv to a single large Apache ORC fil
• F. COPY the file into Amazon Redshift and query the file with Athena from Amazon S3.
• G. Use AWS Glue to convert the files from .csv to Apache Parquet to create 20 Parquet file
• H. COPY the files into Amazon Redshift and query the files with Athena from Amazon S3.

Answer: D

NEW QUESTION 4
A company has an application that uses the Amazon Kinesis Client Library (KCL) to read records from a Kinesis data stream.
After a successful marketing campaign, the application experienced a significant increase in usage. As a result, a data analyst had to split some shards in the data stream. When the shards were split, the application started throwing an ExpiredIteratorExceptions error sporadically.
What should the data analyst do to resolve this?

• A. Increase the number of threads that process the stream records.
• B. Increase the provisioned read capacity units assigned to the stream’s Amazon DynamoDB table.
• C. Increase the provisioned write capacity units assigned to the stream’s Amazon DynamoDB table.
• D. Decrease the provisioned write capacity units assigned to the stream’s Amazon DynamoDB table.

Answer: C

NEW QUESTION 5
A central government organization is collecting events from various internal applications using Amazon Managed Streaming for Apache Kafka (Amazon MSK). The organization has configured a separate Kafka topic for each application to separate the data. For security reasons, the Kafka cluster has been configured to only allow TLS encrypted data and it encrypts the data at rest.
A recent application update showed that one of the applications was configured incorrectly, resulting in writing data to a Kafka topic that belongs to another application. This resulted in multiple errors in the analytics pipeline as data from different applications appeared on the same topic. After this incident, the organization wants to prevent applications from writing to a topic different than the one they should write to.
Which solution meets these requirements with the least amount of effort?

• A. Create a different Amazon EC2 security group for each applicatio
• B. Configure each security group to have access to a specific topic in the Amazon MSK cluste
• C. Attach the security group to each application based on the topic that the applications should read and write to.
• D. Install Kafka Connect on each application instance and configure each Kafka Connect instance to write to a specific topic only.
• E. Use Kafka ACLs and configure read and write permissions for each topi
• F. Use the distinguished name of the clients’ TLS certificates as the principal of the ACL.
• G. Create a different Amazon EC2 security group for each applicatio
• H. Create an Amazon MSK cluster and Kafka topic for each applicatio
• I. Configure each security group to have access to the specific cluster.

Answer: B

NEW QUESTION 6
A US-based sneaker retail company launched its global website. All the transaction data is stored in Amazon RDS and curated historic transaction data is stored in Amazon Redshift in the us-east-1 Region. The business intelligence (BI) team wants to enhance the user experience by providing a dashboard for sneaker trends.
The BI team decides to use Amazon QuickSight to render the website dashboards. During development, a team in Japan provisioned Amazon QuickSight in ap-northeast-1. The team is having difficulty connecting Amazon QuickSight from ap-northeast-1 to Amazon Redshift in us-east-1.
Which solution will solve this issue and meet the requirements?

• A. In the Amazon Redshift console, choose to configure cross-Region snapshots and set the destination Region as ap-northeast-1. Restore the Amazon Redshift Cluster from the snapshot and connect to Amazon QuickSight launched in ap-northeast-1.
• B. Create a VPC endpoint from the Amazon QuickSight VPC to the Amazon Redshift VPC so Amazon QuickSight can access data from Amazon Redshift.
• C. Create an Amazon Redshift endpoint connection string with Region information in the string and use this connection string in Amazon QuickSight to connect to Amazon Redshift.
• D. Create a new security group for Amazon Redshift in us-east-1 with an inbound rule authorizing access from the appropriate IP address range for the Amazon QuickSight servers in ap-northeast-1.

Answer: B

NEW QUESTION 7
A large financial company is running its ETL process. Part of this process is to move data from Amazon S3 into an Amazon Redshift cluster. The company wants to use the most cost-efficient method to load the dataset into Amazon Redshift.
Which combination of steps would meet these requirements? (Choose two.)

• A. Use the COPY command with the manifest file to load data into Amazon Redshift.
• B. Use S3DistCp to load files into Amazon Redshift.
• C. Use temporary staging tables during the loading process.
• D. Use the UNLOAD command to upload data into Amazon Redshift.
• E. Use Amazon Redshift Spectrum to query files from Amazon S3.

Answer: AC

NEW QUESTION 8
A company is building a data lake and needs to ingest data from a relational database that has time-series data. The company wants to use managed services to accomplish this. The process needs to be scheduled daily and bring incremental data only from the source into Amazon S3.
What is the MOST cost-effective approach to meet these requirements?

• A. Use AWS Glue to connect to the data source using JDBC Driver
• B. Ingest incremental records only using job bookmarks.
• C. Use AWS Glue to connect to the data source using JDBC Driver
• D. Store the last updated key in an Amazon DynamoDB table and ingest the data using the updated key as a filter.
• E. Use AWS Glue to connect to the data source using JDBC Drivers and ingest the entire datase
• F. Use appropriate Apache Spark libraries to compare the dataset, and find the delta.
• G. Use AWS Glue to connect to the data source using JDBC Drivers and ingest the full dat
• H. Use AWSDataSync to ensure the delta only is written into Amazon S3.

Answer: A

Explanation:
https://docs.aws.amazon.com/glue/latest/dg/monitor-continuations.html

NEW QUESTION 9
A financial services company needs to aggregate daily stock trade data from the exchanges into a data store.
The company requires that data be streamed directly into the data store, but also occasionally allows data to be modified using SQL. The solution should integrate complex, analytic queries running with minimal latency. The solution must provide a business intelligence dashboard that enables viewing of the top contributors to anomalies in stock prices.
Which solution meets the company’s requirements?

• A. Use Amazon Kinesis Data Firehose to stream data to Amazon S3. Use Amazon Athena as a data source for Amazon QuickSight to create a business intelligence dashboard.
• B. Use Amazon Kinesis Data Streams to stream data to Amazon Redshif
• C. Use Amazon Redshift as a data source for Amazon QuickSight to create a business intelligence dashboard.
• D. Use Amazon Kinesis Data Firehose to stream data to Amazon Redshif
• E. Use Amazon Redshift as a data source for Amazon QuickSight to create a business intelligence dashboard.
• F. Use Amazon Kinesis Data Streams to stream data to Amazon S3. Use Amazon Athena as a data source for Amazon QuickSight to create a business intelligence dashboard.

Answer: C

NEW QUESTION 10
A retail company wants to use Amazon QuickSight to generate dashboards for web and in-store sales. A group of 50 business intelligence professionals will develop and use the dashboards. Once ready, the dashboards will be shared with a group of 1,000 users.
The sales data comes from different stores and is uploaded to Amazon S3 every 24 hours. The data is partitioned by year and month, and is stored in Apache Parquet format. The company is using the AWS Glue Data Catalog as its main data catalog and Amazon Athena for querying. The total size of the uncompressed data that the dashboards query from at any point is 200 GB.
Which configuration will provide the MOST cost-effective solution that meets these requirements?

• A. Load the data into an Amazon Redshift cluster by using the COPY comman
• B. Configure 50 author users and 1,000 reader user
• C. Use QuickSight Enterprise editio
• D. Configure an Amazon Redshift data source with a direct query option.
• E. Use QuickSight Standard editio
• F. Configure 50 author users and 1,000 reader user
• G. Configure an Athena data source with a direct query option.
• H. Use QuickSight Enterprise editio
• I. Configure 50 author users and 1,000 reader user
• J. Configure an Athena data source and import the data into SPIC
• K. Automatically refresh every 24 hours.
• L. Use QuickSight Enterprise editio
• M. Configure 1 administrator and 1,000 reader user
• N. Configure an S3 data source and import the data into SPIC
• O. Automatically refresh every 24 hours.

Answer: C

NEW QUESTION 11
A real estate company has a mission-critical application using Apache HBase in Amazon EMR. Amazon EMR is configured with a single master node. The company has over 5 TB of data stored on an Hadoop Distributed File System (HDFS). The company wants a cost-effective solution to make its HBase data highly available.
Which architectural pattern meets company’s requirements?

• A. Use Spot Instances for core and task nodes and a Reserved Instance for the EMR master node.Configurethe EMR cluster with multiple master node
• B. Schedule automated snapshots using AmazonEventBridge.
• C. Store the data on an EMR File System (EMRFS) instead of HDF
• D. Enable EMRFS consistent view.Create an EMR HBase cluster with multiple master node
• E. Point the HBase root directory to an Amazon S3 bucket.
• F. Store the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view.Run two separate EMR clusters in two different Availability Zone
• G. Point both clusters to the same HBase root directory in the same Amazon S3 bucket.
• H. Store the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view.Create a primary EMR HBase cluster with multiple master node
• I. Create a secondary EMR HBase read- replica cluster in a separate Availability Zon
• J. Point both clusters to the same HBase root directory in the same Amazon S3 bucket.

Answer: D

NEW QUESTION 12
An online gaming company is using an Amazon Kinesis Data Analytics SQL application with a Kinesis data stream as its source. The source sends three non-null fields to the application: player_id, score, and us_5_digit_zip_code.
A data analyst has a .csv mapping file that maps a small number of us_5_digit_zip_code values to a territory code. The data analyst needs to include the territory code, if one exists, as an additional output of the Kinesis Data Analytics application.
How should the data analyst meet this requirement while minimizing costs?

• A. Store the contents of the mapping file in an Amazon DynamoDB tabl
• B. Preprocess the records as they arrive in the Kinesis Data Analytics application with an AWS Lambda function that fetches the mapping and supplements each record to include the territory code, if one exist
• C. Change the SQL query in the application to include the new field in the SELECT statement.
• D. Store the mapping file in an Amazon S3 bucket and configure the reference data column headers for the.csv file in the Kinesis Data Analytics applicatio
• E. Change the SQL query in the application to include a join to the file’s S3 Amazon Resource Name (ARN), and add the territory code field to the SELECT columns.
• F. Store the mapping file in an Amazon S3 bucket and configure it as a reference data source for the Kinesis Data Analytics applicatio
• G. Change the SQL query in the application to include a join to the reference table and add the territory code field to the SELECT columns.
• H. Store the contents of the mapping file in an Amazon DynamoDB tabl
• I. Change the Kinesis DataAnalytics application to send its output to an AWS Lambda function that fetches the mapping and supplements each record to include the territory code, if one exist
• J. Forward the record from the Lambda function to the original application destination.

Answer: C

NEW QUESTION 13
A company is planning to create a data lake in Amazon S3. The company wants to create tiered storage based on access patterns and cost objectives. The solution must include support for JDBC connections from legacy clients, metadata management that allows federation for access control, and batch-based ETL using PySpark and Scala. Operational management should be limited.
Which combination of components can meet these requirements? (Choose three.)

• A. AWS Glue Data Catalog for metadata management
• B. Amazon EMR with Apache Spark for ETL
• C. AWS Glue for Scala-based ETL
• D. Amazon EMR with Apache Hive for JDBC clients
• E. Amazon Athena for querying data in Amazon S3 using JDBC drivers
• F. Amazon EMR with Apache Hive, using an Amazon RDS with MySQL-compatible backed metastore

Answer: BEF

NEW QUESTION 14
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. In Apache ORC partitioned by date and sorted by source IP
• B. In compressed .csv partitioned by date and sorted by source IP
• C. In Apache Parquet partitioned by source IP and sorted by date
• D. In compressed nested JSON partitioned by source IP and sorted by date

Answer: A

NEW QUESTION 15
A data analytics specialist is setting up workload management in manual mode for an Amazon Redshift environment. The data analytics specialist is defining query monitoring rules to manage system performance and user experience of an Amazon Redshift cluster.
Which elements must each query monitoring rule include?

• A. A unique rule name, a query runtime condition, and an AWS Lambda function to resubmit any failed queries in off hours
• B. A queue name, a unique rule name, and a predicate-based stop condition
• C. A unique rule name, one to three predicates, and an action
• D. A workload name, a unique rule name, and a query runtime-based condition

Answer: C

NEW QUESTION 16
A global pharmaceutical company receives test results for new drugs from various testing facilities worldwide. The results are sent in millions of 1 KB-sized JSON objects to an Amazon S3 bucket owned by the company. The data engineering team needs to process those files, convert them into Apache Parquet format, and load them into Amazon Redshift for data analysts to perform dashboard reporting. The engineering team uses AWS Glue to process the objects, AWS Step Functions for process orchestration, and Amazon CloudWatch for job scheduling.
More testing facilities were recently added, and the time to process files is increasing. What will MOST efficiently decrease the data processing time?

• A. Use AWS Lambda to group the small files into larger file
• B. Write the files back to Amazon S3. Process the files using AWS Glue and load them into Amazon Redshift tables.
• C. Use the AWS Glue dynamic frame file grouping option while ingesting the raw input file
• D. Process the files and load them into Amazon Redshift tables.
• E. Use the Amazon Redshift COPY command to move the files from Amazon S3 into Amazon Redshift tables directl
• F. Process the files in Amazon Redshift.
• G. Use Amazon EMR instead of AWS Glue to group the small input file
• H. Process the files in Amazon EMR and load them into Amazon Redshift tables.

Answer: A

NEW QUESTION 17
A company’s marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:
The data size is approximately 32 TB uncompressed.
There is a low volume of single-row inserts each day.
There is a high volume of aggregation queries each day.
Multiple complex joins are performed.
The queries typically involve a small subset of the columns in a table. Which storage service will provide the MOST performant solution?

• A. Amazon Aurora MySQL
• B. Amazon Redshift
• C. Amazon Neptune
• D. Amazon Elasticsearch

Answer: B

NEW QUESTION 18
An IoT company wants to release a new device that will collect data to track sleep overnight on an intelligent mattress. Sensors will send data that will be uploaded to an Amazon S3 bucket. About 2 MB of data is generated each night for each bed. Data must be processed and summarized for each user, and the results need to be available as soon as possible. Part of the process consists of time windowing and other functions. Based on tests with a Python script, every run will require about 1 GB of memory and will complete within a couple of minutes.
Which solution will run the script in the MOST cost-effective way?

• A. AWS Lambda with a Python script
• B. AWS Glue with a Scala job
• C. Amazon EMR with an Apache Spark script
• D. AWS Glue with a PySpark job

Answer: A

NEW QUESTION 19
A company wants to optimize the cost of its data and analytics platform. The company is ingesting a number of .c sv and JSON files in Amazon S3 from various data sources. Incoming data is expected to be 50 GB each day. The company is using Amazon Athena to query the raw data in Amazon S3 directly. Most queries aggregate data from the past 12 months, and data that is older than 5 years is infrequently queried. The typical query scans about 500 MB of data and is expected to return results in less than 1 minute. The raw data must be retained indefinitely for compliance requirements.
Which solution meets the company’s requirements?

• A. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data forma
• B. Use Athena to query the processed datase
• C. Configure a lifecycle policy to move the processed data into the Amazon S3 Standard-Infrequent Access (S3 Standard-IA) storage class 5 years after object creatio
• D. Configure a second lifecycle policy to move the raw data into Amazon S3 Glacier for long-term archival 7 days after object creation.
• E. Use an AWS Glue ETL job to partition and convert the data into a row-based data forma
• F. Use Athena to query the processed datase
• G. Configure a lifecycle policy to move the data into the Amazon S3 Standard- Infrequent Access (S3 Standard-IA) storage class 5 years after object creatio
• H. Configure a second lifecycle policy to move the raw data into Amazon S3 Glacier for long-term archival 7 days after object creation.
• I. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data forma
• J. Use Athena to query the processed datase
• K. Configure a lifecycle policy to move the processed data into the Amazon S3 Standard-Infrequent Access (S3 Standard-IA) storage class 5 years after the object was last accesse
• L. Configure a second lifecycle policy to move the raw data into Amazon S3 Glacier forlong-term archival 7 days after the last date the object was accessed.
• M. Use an AWS Glue ETL job to partition and convert the data into a row-based data forma
• N. Use Athena to query the processed datase
• O. Configure a lifecycle policy to move the data into the Amazon S3 Standard- Infrequent Access (S3 Standard-IA) storage class 5 years after the object was last accesse
• P. Configure a second lifecycle policy to move the raw data into Amazon S3 Glacier for long-term archival 7 days after the last date the object was accessed.

Answer: A

NEW QUESTION 20
......