Add office photos
Engaged Employer

Tech Mahindra

3.5
based on 35.1k Reviews
Video summary
Filter interviews by

Inline Technologies Interview Questions and Answers

Updated 15 Dec 2024
Popular Designations

Q1. how to remove duplicate rows from bigquery? find the month of a given date in bigquery.

Ans.

To remove duplicate rows from BigQuery, use the DISTINCT keyword. To find the month of a given date, use the EXTRACT function.

  • To remove duplicate rows, use SELECT DISTINCT * FROM table_name;

  • To find the month of a given date, use SELECT EXTRACT(MONTH FROM date_column) AS month_name FROM table_name;

  • Make sure to replace 'table_name' and 'date_column' with the appropriate values in your query.

Add your answer

Q2. what operator is used in composer to move data from gcs to bq

Ans.

The operator used in Composer to move data from GCS to BigQuery is the GCS to BigQuery operator.

  • The GCS to BigQuery operator is used in Apache Airflow, which is the underlying technology of Composer.

  • This operator allows you to transfer data from Google Cloud Storage (GCS) to BigQuery.

  • You can specify the source and destination parameters in the operator to define the data transfer process.

Add your answer

Q3. write a code for this - input = [1,2,3,4] output = [1,4,9,16]

Ans.

Code to square each element in the input array.

  • Iterate through the input array and square each element.

  • Store the squared values in a new array to get the desired output.

Add your answer

Q4. architecture of bq. Query optimization techniques in bigquery.

Ans.

BigQuery architecture includes storage, execution, and optimization components for efficient query processing.

  • BigQuery stores data in Capacitor storage system for fast access.

  • Query execution is distributed across multiple nodes for parallel processing.

  • Query optimization techniques include partitioning tables, clustering tables, and using query cache.

  • Using partitioned tables can help eliminate scanning unnecessary data.

  • Clustering tables based on certain columns can improve que...read more

Add your answer
Discover Inline Technologies interview dos and don'ts from real experiences

Q5. difference between bigtable and bigquery.

Ans.

Bigtable is a NoSQL database for real-time analytics, while BigQuery is a fully managed data warehouse for running SQL queries.

  • Bigtable is a NoSQL database designed for real-time analytics and high throughput, while BigQuery is a fully managed data warehouse for running SQL queries.

  • Bigtable is used for storing large amounts of semi-structured data, while BigQuery is used for analyzing structured data using SQL queries.

  • Bigtable is suitable for real-time data processing and hig...read more

Add your answer

Q6. RDD vs dataframe vs dataset in pyspark

Ans.

RDD vs dataframe vs dataset in PySpark

  • RDD (Resilient Distributed Dataset) is the basic abstraction in PySpark, representing a distributed collection of objects

  • Dataframe is a distributed collection of data organized into named columns, similar to a table in a relational database

  • Dataset is a distributed collection of data with the ability to use custom classes for type safety and user-defined functions

  • Dataframes and Datasets are built on top of RDDs, providing a more structured...read more

Add your answer

Q7. dataflow vs dataproc.

Ans.

Dataflow is a fully managed stream and batch processing service, while Dataproc is a managed Apache Spark and Hadoop service.

  • Dataflow is a serverless data processing service that automatically scales to handle your data, while Dataproc is a managed Spark and Hadoop service that requires you to provision and manage clusters.

  • Dataflow is designed for both batch and stream processing, allowing you to process data in real-time, while Dataproc is more focused on batch processing.

  • Da...read more

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Inline Technologies

based on 2 interviews
Interview experience
4.5
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Engineer Interview Questions from Similar Companies

3.8
 • 72 Interview Questions
3.7
 • 64 Interview Questions
4.0
 • 29 Interview Questions
3.4
 • 20 Interview Questions
3.5
 • 16 Interview Questions
4.0
 • 11 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter