Bigquery data set - Study guides, Class notes & Summaries

GCP Data Engineer Sample Exam With 100% Correct Answers. You are building storage for files for a data pipeline on Google Cloud. You want to support JSON files. The schema of these files will occasionally change. Your analyst teams will use running aggregate ANSI SQL queries on this data. What should you do? - CORRECT ANSWER B. Use BigQuery for storage. Select "Automatically detect" in the Schema section. Your infrastructure includes two 100-TB enterprise file servers. You need to perf...

Google's Cloud Platform Questions and Answers 100% correct Google App Engine enables you to build and host web apps on the same systems that power Google applications. It offers fast development and deployment; simple administration, with no need to worry about hardware, patches or backups; and effortless scalability. It also provides the ability to create Managed VMs. In addition, you can build client APIs for your applications using Google Cloud Endpoints. competes with: Heroku, Elastic ...

A tool that warns you when you're spending too much. - CORRECT ANSWER Billing Alerts A service used for executing code in response to events. - CORRECT ANSWER Cloud Functions A mechanism that allows you to track custom information in code and save it to Stackdriver. - CORRECT ANSWER Custom monitoring metric. The command to create a Cloud Function. - CORRECT ANSWER `gcloud functions deploy` The way to enable point-in-time recovery for MySQL databases on Cloud SQL. - CORRECT ANSWER Enabl...

1 GOOGLE ASSOCIATE CLOUD ENGINEER EXAM | QUESTIONS & ANSWERS (VERIFIED) | LATEST UPDATE | GRADED A+ What is the purpose of a VPC ? Correct Answer: Connects resources to each other and the internet. networks are ___ , subnets are ___ Correct Answer: global,regional How would you increase the size of a subnet? Correct Answer: expanding IP addresses What is the purpose of a pre-emptible VM? Correct Answer: permission to terminate if resources are needed elsewhere. Also very cheap ...

You are working on an enhancement project that requires the existing application to access the Analytics report data from the Analytics Reporting API. The application is hosted on a virtual machine with an internal IP address and no external IP address. What should you do to access the Analytics Reporting API? 1. Disable Private Google Access. 2. Enable Private Google Access. 3. Ensure that VM interface has an external IP address assigned. 4. Ensure that the VM interface is connected to a ...

A. Create two configurations using gcloud config configurations create [NAME]. Run gcloud config configurations activate [NAME] to switch between accounts when running the commands to start the Compute Engine instances. B. Create two configurations using gcloud config configurations create [NAME]. Run gcloud configurations list to start the Compute Engine instances. C. Activate two configurations using gcloud configurations activate [NAME]. Run gcloud config list to start the Compute Engine in...

You support a N application running on Google Kubernetes Engine (GKE) in production. The application makes several HTTP requests to dependent applications. You want to anticipate which dependent applications might cause performance issues. What should you do? A. Instrument all applications with Stackdriver Profiler. B. Instrument all applications with Stackdriver Trace and review inter-service HTTP requests. C. Use Stackdriver Debugger to review the execution of logic within each application ...

BigQuery Data Set correct answers A dataset is contained within a specific project. Datasets enable you to organize and control access to your tables and views. A table or view must belong to a dataset, so you need to create at least one dataset before loading data into BigQuery. BigQuery Table correct answers A BigQuery table contains individual records organized in rows, and a data type assigned to each column (also called a field). Individual fields within a record data type can contain ne...

1. Instance templates are used to create a group of identical VMs. The instance templates include: A. Machine type, boot disk image or container image, zone, and labels B. Cloud Storage bucket definitions C. A load balancer description D. App Engine configuration file -ANSWER A. Machine type, boot disk image or container image, zone, and labels are all configuration parameters or attributes of a VM and therefore would be included in an instance group configuration that creates those VMs....

Every employee of your company has a Google account. Your operational team needs to manage a large number of instances on Compute Engine. Each member of this team needs only administrative access to the servers. Your security team wants to ensure that the deployment of credentials is operationally efficient and must be able to determine who accessed a given instance. What should you do? A. Generate a new SSH key pair. Give the private key to each member of your team. Configure the public key in...