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. 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 the

REVENUE 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.">3.

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 the

REVENUE 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.Modern English has all of the following characteristics except() 选项： A:

Increasing use of abbreviations

B:

Increasing use of conversion

C:

Increasing use of open compounds

D:

Increasing use of dialectal words

5.A design company has multiple name and address files for its customers in several of its independent systems. Which of the following is the BEST control to ensure customer names and addresses agree across all files? 选项： A:Use of current and authorized customer information change forms B:Matching of records and review of exception reports C:Use of hash totals on customer records D:Periodic review of each master file by management

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.Your company is in the process of migrating its on-premises data warehousing solutions to BigQuery. The existing data warehouse uses trigger-based change data capture (CDC) to apply updates from multiple transactional database sources on a daily basis. With BigQuery, your company hopes to improve its handling ofCDC so that changes to the source systems are available to query in BigQuery in near-real time using log-based CDC streams, while also optimizing for the performance of applying changes to the data warehouse. Which two steps should they take to ensure that changes are available in the BigQuery reporting table with minimal latency while reducing compute overhead? (Choose two.) 选项： A: Perform a DML INSERT, UPDATE, or DELETE to replicate each individual CDC record in real time directly on the reporting table. B: Insert each new CDC record and corresponding operation type to a staging table in real time. C: Periodically DELETE outdated records from the reporting table. D: Periodically use a DML MERGE to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table. E: Insert each new CDC record and corresponding operation type in real time to the reporting table, and use a materialized view to expose only the newest version of each unique record.

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.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.

10.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

11.Many electronics stores in the United States even （）(2 words) the newest cell phones if customers agree to pay to use the network.

12.Table manners such as what or to use are essential in western dining.

13.Where should we put our chopsticks in Chinese dinner table选项： A: Put them down on the table ; B:stick the chopsticks upright in the bowl; C: Hold them in hands all the time ; D:Lay them on the bowl if no in use

14.Where should we put our chopsticks in Chinese dinner table选项： A:Put them down on the table ; B:Stick the chopsticks upright in the bowl; C:Hold them in hands all the time ; D:Lay them on the bowl if no in use

15. A company would use recruitment advertising to attract prospective customers to buy a product. 选项： A:true B:false