Which two actions should you take?

You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as its data source. It is company policy to ensure employees can view only the data associated with their region, so you create and populate a table for each region. You...

September 27, 2021 No Comments READ MORE +

What should you do?

Your company’s on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided to migrate the cluster to Google Cloud Dataproc. A like-for-like migration of the cluster would require 50 TB of Google Persistent Disk per node. The CIO is concerned about the cost of using that much block storage....

September 26, 2021 No Comments READ MORE +

To give a user read permission for only the first three columns of a table, which access control method would you use?

To give a user read permission for only the first three columns of a table, which access control method would you use?A . Primitive roleB . Predefined roleC . Authorized viewD . It's not possible to give access to only the first three columns of a table.View AnswerAnswer: C Explanation:...

September 26, 2021 No Comments READ MORE +

Which TensorFlow function can you use to configure a categorical column if you don't know all of the possible values for that column?

Which TensorFlow function can you use to configure a categorical column if you don't know all of the possible values for that column?A . categorical_column_with_vocabulary_listB . categorical_column_with_hash_bucketC . categorical_column_with_unknown_valuesD . sparse_column_with_keysView AnswerAnswer: B Explanation: If you know the set of all possible feature values of a column and there are...

September 26, 2021 No Comments READ MORE +

Which combination of Google Cloud Platform products should you recommend?

MJTelco is building a custom interface to share data. They have these requirements: - They need to do aggregations over their petabyte-scale datasets. - They need to scan specific time range rows with a very fast response time (milliseconds). Which combination of Google Cloud Platform products should you recommend?A ....

September 26, 2021 No Comments READ MORE +

How can you make that data available while minimizing cost?

You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Users table consisting of a FirstName field and a LastName field. A member of IT is building an application and asks you to modify the schema and data...

September 26, 2021 No Comments READ MORE +

What should they do?

Topic 2, Flowlogistic Case Study Company Overview Flowlogistic is a leading logistics and supply chain provider. They help businesses throughout the world manage their resources and transport them to their final destination. The company has grown rapidly, expanding their offerings to include rail, truck, aircraft, and oceanic shipping. Company Background...

September 26, 2021 No Comments READ MORE +

How should you adjust the database design?

You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics. Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then,...

September 25, 2021 No Comments READ MORE +

Which combination of GCP products should you choose?

Flowlogistic’s management has determined that the current Apache Kafka servers cannot handle the data volume for their real-time inventory tracking system. You need to build a new system on Google Cloud Platform (GCP) that will feed the proprietary tracking software. The system must be able to ingest data from a...

September 25, 2021 No Comments READ MORE +

Which approach should you take?

Flowlogistic is rolling out their real-time inventory tracking system. The tracking devices will all send package-tracking messages, which will now go to a single Google Cloud Pub/Sub topic instead of the Apache Kafka cluster. A subscriber application will then process the messages for real-time reporting and store them in Google...

September 25, 2021 No Comments READ MORE +