Professional Data Engineer

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

Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error. SELECT person FROM `1` WHERE city = "London" How would you correct the error? A. Add ", UNNEST(person...

Steps in Data Life Cycle correct answers Ingest, Store, Process/Analyze, Explore/Visualize Define Ingest correct answers pull in raw data - streaming/real-time data from devices - on premises batch data - application logs Define Store correct answers data needs to be stored in a format and ...

Bigtable's security can be controlled at what points? correct answers Folder Project Instance BigQuery's security can be controlled at what points? correct answers Folder Project Dataset A project can contain a Bigtable ____, which contains one or two _____, each with 3 to many ____ corr...

1- Your company built a TensorFlow neutral-network model with a large number of neurons and layers. The model fits well for the training data. However, when tested against new data, it performs poorly. What method can you employ to address this? A. Threading B. Serialization C. Dropout Methods D...

1. You are developing an application that will only recognize and tag specific business to business product logos in images. You do not have an extensive background working with machine learning models, but need to get your application working. What is the current best method to accomplish this task...

What are the 4 V's of Big Data? correct answers Volume - lots of data (lots!) Variety - structure & unstructured Velocity - faster than transactional data (like CC's); think sensor data... so fast that some RDMS has trouble writing it all Value - make sense of the data so that action can be tak...

What is data engineering? correct answers Data engineering enables data-driven decision making by collecting, transforming, and visualizing data. What does a data engineer do? correct answers A data engineer designs, builds, maintains, and troubleshoots data processing systems with a particular e...

Question 1 Which of the following describes a benefit of a data lakehouse that is unavailable in a traditional data warehouse? A. A data lakehouse provides a relational system of data management. B. A data lakehouse captures snapshots of data for version control purposes. C. A data lakehouse cou...