Data Engineer 101

Data Engineer 101

Proficiency in Google Data Studio, Looker Studio, and BigQuery to set up dashboards from raw data. Or equivalent

Strong experience in data engineering and pipeline optimization.

Expertise in SQL and BI tools.

Ability to translate complex data into actionable strategies and reports.

Multiple Choice

What is Metadata?

• Metadata is defined as the information that describes and explains data. It provides context with details such as the source, type, owner, and relationships to other data sets. So, it can help you understand the relevance of a particular data set and guide you on how to use it.

• not A

Multiple Choice

What is RDBMS database?

• A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

Multiple Choice

What is MPP database

• An MPP Database (short for massively parallel processing) is a storage structure designed to handle multiple operations simultaneously by several processing units. In this type of data warehouse architecture, each processing unit works independently with its own operating system and dedicated memory.

Multiple Choice

What does Row Level mean?

• Row-Level Security, or RLS, refers to the practice of controlling access to data in a database by row, so that users are only able to access the data they are authorized for. This contrasts with database-level or table-level security which controls access to entire databases or tables, respectively.

Multiple Choice

What is Database Parellelism?

• Database Parallelism is a method of implementing parallel processing in a database. An attempt to increase database functioning in a short period of time.

Multiple Choice

What is Sharding?

• Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts. These smaller parts are called data shards. The word shard means "a small part of a whole."

Multiple Choice

What is the meaning of change data capture?

• Change data capture (CDC) refers to the tracking of all changes in a data source (databases, data warehouses, etc.) so they can be captured in destination systems. In short, CDC allows organizations to achieve data integrity and consistency across all systems and deployment environments.

Multiple Choice

What is a native connection to the database?

• What is a native connection to the database?

  A native database interface is a direct connection to your data in InfoMaker. Each native database interface uses its own interface DLL to communicate with a specified database through a vendor-specific database API. For example, the Adaptive Server interface uses a DLL named PBSYC190.

• not A

Multiple Choice

What is Sybase InfoMaker?

• InfoMaker is a powerful reporting and data maintenance tool. With InfoMaker, you can create the following objects: Reports to view data. Forms to view and change data. Queries to automatically retrieve data for reports or forms.

• not A

Multiple Choice

What does SLAs mean?

• What does SLAs mean?

  What is an SLA? SLA stands for service level agreement. It refers to a document that outlines a commitment between a service provider and a client, including details of the service, the standards the provider must adhere to, and the metrics to measure the performance.

• not A

1. Log-based CDC.

2. Query-based CDC.

3. Trigger-based CDC.

Out-of-the-Box Change Data Capture

Multiple Choice

What are Agile ceremonies?

• There are four main Agile ceremonies: the sprint planning meeting, the daily stand-up meeting, the sprint review meeting, and the sprint retrospective meeting. Before each of these ceremonies take place, all team members should know this key information: Who on the development team is involved in this ceremony?

• not A