A large ride-sharing company has thousands of drivers g

1. A large ride-sharing company has thousands of drivers globally serving millions of unique customers everyday. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schemaincludes the following tables.・ A trips fact table for information on completed rides.・ A drivers dimension table for driver profiles.・ A customers fact table holding customer profile information.The company analyzes trip details by date and destination to examine profitability by region. The driversdata rarely changes. The customers data frequently changes.What table design provides optimal query performance? 选项： A:

Use DISTSTYLE KEY (destination) for the trips table and sort by date. Use DISTSTYLE ALL for the drivers and customers tables.

B:

Use DISTSTYLE EVEN for the trips table and sort by date. Use DISTSTYLE ALL for the drivers table.Use DISTSTYLE EVEN for the customers table.

C:

Use DISTSTYLE KEY (destination) for the trips table and sort by date. Use DISTSTYLE ALL for the drivers table. Use DISTSTYLE EVEN for the customers table.

D:

Use DISTSTYLE EVEN for the drivers table and sort by date. Use DISTSTYLE ALL for both fact tables.

2.Which of the following is wrong?选项： A:In China,people sit around one table.; B:Westerners like to use a long table.; C:The dishes are placed on the table and everyone shares in China.; D:In China, people like to use a long table.

3. A healthcare company uses AWS data and analytics tools to collect, ingest, and store electronic healthrecord (EHR) data about its patients. The raw EHR data is stored in Amazon S3 in JSON format partitionedby hour, day, and year and is updated every hour. The company wants to maintain the data catalog andmetadata in an AWS Glue Data Catalog to be able to access the data using Amazon Athena or AmazonRedshift Spectrum for analytics.When defining tables in the Data Catalog, the company has the following requirements:・ Choose the catalog table name and do not rely on the catalog table naming algorithm.・ Keep the table updated with new partitions loaded in the respective S3 bucket prefixes.Which solution meets these requirements with minimal effort? 选项： A:

Run an AWS Glue crawler that connects to one or more data stores, determines the data structures,and writes tables in the Data Catalog.

B:

Use the AWS Glue console to manually create a table in the Data Catalog and schedule an AWS Lambda function to update the table partitions hourly.

C:

Use the AWS Glue API CreateTable operation to create a table in the Data Catalog. Create an AWS Glue crawler and specify the table as the source.

D:

Create an Apache Hive catalog in Amazon EMR with the table schema definition in Amazon S3, and update the table partition with a scheduled job. Migrate the Hive catalog to the Data Catalog.

Which two are true? (Choose two.)

选项： A:The CONTAINERS clause cannot be used in queries on the REVENUE table. B:The REVENUE table must be a list-partitioned table. C:The MAPTABLE tables defines a logical partition key on a commonly used column for theREVENUE table. D:The MAPTABLE table is a metadata-linked table. E: A container map exists for the REVENUE table, but is not enabled. F: The REVENUE table partitions are not pruned across the PDBs automatically.">4.

Your SALES_ROOT application container has two application PDBs. The SALES_APP application has

A common table, FIN.REVENUE, in the two PDBs.

Examine this query and its output:

bdcd15648f13bb488b42437a523cb330

Which two are true? (Choose two.)

选项： A:The CONTAINERS clause cannot be used in queries on the REVENUE table. B:The REVENUE table must be a list-partitioned table. C:The MAPTABLE tables defines a logical partition key on a commonly used column for theREVENUE table. D:The MAPTABLE table is a metadata-linked table. E: A container map exists for the REVENUE table, but is not enabled. F: The REVENUE table partitions are not pruned across the PDBs automatically.

5. A media company wants to perform machine learning and analytics on the data residing in its Amazon S3data lake. There are two data transformation requirements that will enable the consumers within thecompany to create reports:・ Daily transformations of 300 GB of data with different file formats landing in Amazon S3 at a scheduledtime.・ 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 thedata? (Choose three.) 选项： A:

For daily incoming data, use AWS Glue crawlers to scan and identify the schema.

B:

For daily incoming data, use Amazon Athena to scan and identify the schema.

C:

For daily incoming data, use Amazon Redshift to perform transformations.

D:

For daily incoming data, use AWS Glue workflows with AWS Glue jobs to perform transformations.

E:

For archived data, use Amazon EMR to perform data transformations.

F:

For archived data, use Amazon SageMaker to perform data transformations.

6.Which of the following statements is wrong about the seating etiquette in Chinese and western table manners? ( ) 选项： A、It is more likely to use the round tables in Chinese table manners. B、It is more likely to use the long tables in western table manners. C、The left is the honor in Chinese table manners. D、The right is the honor in western table manners.

7.Both historical records and frequently accessed data are stored on an on-premises storage system. The amount of current data is growing at an exponential ratE . As the storage's capacity is nearing its limit, the company's Solutions Architect has decided to move the historical records to AWS to free up space for the active datA . Which of the following architectures deliver the best solution in terms of cost and operational management? 选项： A:

Use AWS DataSync to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier Deep Archive to be the destination for the datA .

B:

Use AWS Storage Gateway to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier Deep Archive to be the destination for the datA .

C:

Use AWS DataSync to move the historical records from on-premises to AWS. Choose Amazon S3 Standard to be the destination for the datA . Modify the S3 lifecycle configuration to move the data from the Standard tier to Amazon S3 Glacier Deep Archive after 30 days.

D:

Use AWS Storage Gateway to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier to be the destination for the datA . Modify the S3 lifecycle configuration to move the data from the Standard tier to Amazon S3 Glacier Deep Archive after 30 days.

8.Both historical records and frequently accessed data are stored on an on-premises storage system. The amount of current data is growing at an exponential rate. As the storage's capacity is nearing its limit, the company's Solutions Architect has decided to move the historical records to AWS to free up space for the active data. Which of the following architectures deliver the best solution in terms of cost and operational management? 选项： A:

Use AWS DataSync to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier Deep Archive to be the destination for the data.

B:

Use AWS Storage Gateway to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier Deep Archive to be the destination for the data.

C:

Use AWS DataSync to move the historical records from on-premises to AWS. Choose Amazon S3 Standard to be the
destination for the data. Modify the S3 lifecycle configuration to move the data from the Standard tier to Amazon S3 Glacier Deep Archive after 30 days.

D:

Use AWS Storage Gateway to move the historical records from on-premises to AWS. Choose Amazon S3 Glacier to
be the destination for the data. Modify the S3 lifecycle configuration to move the data from the Standard tier to Amazon
S3 Glacier Deep Archive after 30 days.

9.One of the most ill-mannered things to do at a business meal is_____.

A、order a lot of food

B、Smoke while others are eating

C、Set up business papers on the table

D、Use a cell phone

This will result as an error.