Your company is in the process of migrating its on-premises data wareh

1. Your company implemented BigQuery as an enterprise data warehouse， Users from multiple business units run queries on this data warehouse. Hlowever, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use? (Choose two.) 选项： A:Split the users from business units to multiple projects. B:Apply a user- or project-level custom query quota for BigQuery data warehouse. C:Create separate copies of your BigQuery data warehouse for each business unit. D:Split your BigQuery data warehouse into multiple data warehouses for each business unit. E:Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.

2.Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very high,and you need to control costs. Which two methods should you use?(Choose two.) 选项： A: Split the users from business units to multiple projects. B:Apply a user- or project-level custom query quota for BigQuery data warehouse. C: Create separate copies of your BigQuery data warehouse for each business unit. D:Split your BigQuery data warehouse into multiple data warehouses for each business unit. E:Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.

3.Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse.However, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use? (ChooseTwo.) 选项： A: Split the users from business units to multiple projects. B: Apply a user- or project-level custom query quota for BigQuery data warehouse. C: Create separate copies of your BigQuery data warehouse for each business unit. D: Split your BigQuery data warehouse into multiple data warehouses for each business unit. E: Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.

4.A company plans to use Azure Storage for file storage purposes. Compliance rules require: A single storage account to store all operations including reads, writes and deletes Retention of an on-premises copy of historical operations You need to configure the storage account.Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. 选项： A: Configure the storage account to log read, write and delete operations for service type Blob B: Use the AzCopy tool to download log data from $logs/blob C: Configure the storage account to log read, write and delete operations for service-type table D: Use the storage client to download log data from $logs/table E: Configure the storage account to log read, write and delete operations for service type queue

5.You are building a new data pipeline to share data between two different types of applications: jobs generators and job runners. Your solution must scale to accommodate increases in usage and must accommodate the addition of new applications without negatively affecting the performance of existing ones. What should you do?● 选项： A: Create an API using App Engine to receive and send messages to the applications● B: Use a Cloud Pub/Sub topic to publish jobs, and use subscriptions to execute them● C: Create a table on Cloud SQL, and insert and delete rows with the job information● D: Create a table on Cloud Spanner, and insert and delete rows with the job information

6.A company runs a highly available data collection application on Amazon EC2 in the eu-north-1 Region. The application collects data from enduser devices and writes records to an Amazon Kinesis data stream and a set of AWS Lambda functions that process the records. The companyPersists the output of the record processing to an Amazon S3 bucket in eu-north-1. The company uses the data in the S3 bucket as a data sourceFor Amazon Athena.The company wants to increase its global presence. A solutions architect must launch the data collection capabilities in the sa-east-1 and apnortheast-1 Regions. The solutions architect deploys the application, the Kinesis data stream, and the Lambda functions in the two new Regions.The solutions architect keeps the S3 bucket in eu-north-1 to meet a requirement to centralize the data analysis.During testing of the new setup, the solutions architect notices a significant lag on the arrival of data from the new Regions to the S3 bucket.Which solution will improve this lag time the MOST? 选项： A: In each of the two new Regions, set up the Lambda functions to run in a VPC. Set up an S3 gateway endpoint in that VPC. B: Turn on S3 Transfer Acceleration on the S3 bucket in eu-north-1. Change the application to use the new S3 accelerated endpoint when theApplication uploads data to the S3 bucket. C: Create an S3 bucket in each of the two new Regions. Set the application in each new Region to upload to its respective S3 bucket. Set up S3Cross-Region Replication to replicate data to the S3 bucket in eu-north-1. D: Increase the memory requirements of the Lambda functions to ensure that they have multiple cores available. Use the multipart uploadFeature when the application uploads data to Amazon S3 from Lambda.

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

8.SQL语句中INSERT.UPDATE.DELETE属于数据库DML语句

9.You are a Customer Data Platform Specialist. Your organization recently implemented audience insights. You need to create a measure using the AverageTransaction Value' template to track the average spent by a customer.As part of the process of creating the measure, you need to add data and map it to the data from the Unifed Activity entity.When you are setting up the measure, which two steps should you perform to complete this task? Each 答案 presents part of the solution.NOTE: Each correct selection is worth one point. 选项： A:Choose the attribute representing the Transaction value from the Unifed Customer entity. B:Choose the attribute representing the Transaction value from the Unifed Activity entity. C:Choose an activity type and select the entity with transactional data. D:Choose either the Account or Contact entity to get the related transactional data.

10.数据操作语言（DML）有以下几种：（）。选项： A、SELECT B、INSERT C、DELETE D、UPDATE

11.以下哪项不属于DML操作（）选项： A:insert; B:update; C:delete; D:create

12.When each router receives a packet, it searches its ______________ to find the best match between the _____________________ and one of the network addresses in the routing table. Once a match is found, the packet is ____________ in the Layer 2 data l

13.334An organization wants to classify database tables according to its data classification scheme. From an IS auditor’s perspective, the tables should be classified based on the: 选项： A:number of end users with access to the table B:frequency of updates to the table C:descriptions of column names in the table D:specific functional contents of each single table