Level | Topic | Subtopics |
---|---|---|
Basic | Introduction to BigQuery | What is BigQuery, Key Features, Use Cases, BigQuery vs Traditional Databases, Serverless Architecture |
BigQuery Console & UI | Web UI Overview, Query Editor, Job History, Project & Dataset Navigation, Schema Exploration | |
Datasets & Tables | Creating Datasets, Creating Tables, Table Schema, Data Types, Partitioned & Clustered Tables | |
SQL Basics in BigQuery | SELECT Statements, WHERE Clause, ORDER BY, LIMIT, GROUP BY, Aggregations | |
Data Loading & Export | Loading CSV/JSON/Parquet, Streaming Inserts, Exporting Data, Storage Options | |
Intermediate | BigQuery Functions & Operators | String Functions, Date & Time Functions, Array Functions, JSON Functions, Mathematical Functions |
Joins & Subqueries | INNER JOIN, LEFT/RIGHT JOIN, CROSS JOIN, Self Joins, Nested Queries | |
Views & Materialized Views | Creating Views, Benefits, Materialized Views, Use Cases, Performance Considerations | |
Performance Optimization | Partitioning, Clustering, Query Caching, Table Decorators, Query Execution Plan | |
BigQuery ML Basics | Introduction to BigQuery ML, Creating Models, Types of Models (Linear Regression, Classification), Training & Evaluation | |
Advanced | Advanced SQL Features | Window Functions, CTEs, Arrays, Structs, UNNEST, ARRAY_AGG, WITH Clauses |
BigQuery ML Advanced | Hyperparameter Tuning, Feature Engineering, Evaluation Metrics, Model Export, Predict Queries | |
Security & Access Control | IAM Roles, Dataset/Table Permissions, Authorized Views, Row-Level Security, Column-Level Security | |
Data Transfer & Integration | BigQuery Data Transfer Service, Cloud Storage, Google Analytics, External Data Sources, Federated Queries | |
Scripting & Stored Procedures | BigQuery Scripting, Variables, Loops, IF/ELSE, Stored Procedures, Error Handling | |
Expert | Advanced BigQuery ML | Deep Learning Models, Time Series Forecasting, TensorFlow Integration, Vertex AI Integration, AutoML |
Cost Management & Optimization | Query Cost Estimation, Slot Reservations, Reservations & Flex Slots, Optimizing Storage & Queries | |
BigQuery for Analytics & BI | Integrating with Looker, Data Studio, Tableau, Power BI, Real-time Analytics | |
Multi-Region & Multi-Project Architecture | Data Replication, Cross-Project Queries, Federated Queries, Data Sharing Best Practices | |
Emerging Trends & Best Practices | BigQuery Omni, BigLake, Serverless Analytics, Data Mesh, Governance, Performance Tuning |
29 August 2024
#Google_BigQuery
28 August 2024
#AVRO
Question count - Last updated - V4 (28-Aug-2024)
What is Apache Avro? |
State some Key Points about Apache Avro? |
What Avro Offers? |
Who is intended audience to Learn Avro? |
What are prerequisites to learn Avro? |
Explain Avro schemas? |
Explain Thrift and Protocol Buffers and Avro? |
Why Avro? |
How to use Avro? |
Name some primitive types of Data Types which Avro Supports. |
Name some complex types of Data Types which Avro Supports. |
What are best features of Apache Avro? |
Explain some advantages of Avro. |
Explain some disadvantages of Avro. |
What do you mean by schema declaration? |
Explain the term Serialization? |
What do you mean by Schema Resolution? |
Explain the Avro Sasl profile? |
What is the way of creating Avro Schemas? |
Name some Avro Reference Apis? |
When to use Avro? |
Explain sort order in brief? |
What is the advantage of Hadoop Over Java Serialization? |
What are the disadvantages of Hadoop Serialization? |
AVRO | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
26 August 2024
#Augmented_Reality
Question count - Last updated - V4 (26-Aug-2024)
Augmented_Reality | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
#Prompt_Engineering
Question count - Last updated - V4 (26-Aug-2024)
Basic LLM Concepts |
|
Prompting |
|
Prompting |
|
Prompting Techniques |
|
Real World Usage Examples |
|
Pitfalls of LLMs |
|
Improving Reliability |
|
LLM Settings |
|
Image Prompting |
|
Prompt Hacking |
|
Prompt_Engineering | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
#Generative_AI
Question count - Last updated - V4 (26-Aug-2024)
Generative_AI | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
19 August 2024
#BigData
Question count - Last updated - V4 (19-Aug-2024)
What are the five V?s of Big Data? |
What is Dala Cleansing? |
What are the sources of Unstructured data in Big Data? |
What are the different approaches to deal with Big Data? |
What are the different platforms to deal with Big Data? |
What kind of projects are better suitable for Big Data? |
What are the factors or issues to be considered while building Big Data Models? |
What are the tools used to extract Big Data? |
What are the tools/languages to query Big Data? |
What is features selection? |
What is overfitting? |
What are outliers? |
What do you mean by model optimization? |
What is Data Enrichment? |
What is Lamda Architecture? |
What is Graph Analytics concerning Big Data? |
What is Dimensionality Reduction? |
What are the different techniques for Dimensionality Reduction? |
Name some tools or systems used in big data processing? |
Explain the steps to be followed to deploy a Big Data solution. |
Explain the ETL process concerning Big Data. |
Explain data preparation in Big Data. |
Why is Hadoop more suitable for Big Data? |
Which are the best tools that can be used by a Data-Analyst? |
Which language is preferred for Big Data - R, Python or any other language? |
How is Hadoop related to Big Data? |
How is big data analysis helpful in increasing business revenue? |
How is Big data different? |
How can big data support organizations? |
How can you process Big Data? |
How are Big Data and Data Science related? |
How are missing values handled in Big Data? |
How should you deal with outliers? |
Describe Big Data deployment. |
Is a cloud-based solution a good option for Big Data? |
Is Hadoop different from other parallel computing systems? How? |
|
|
|
|
|
|
|
BigData | |||||||||
Question | Option A | Option B | Option C | Option D | |||||
---|---|---|---|---|---|---|---|---|---|
The _________ Server assigns regions to the region servers and takes the help of Apache ZooKeeper for this task. | Region | Master | Zookeeper | All of the mentioned |
|
17 August 2024
#IoT
Question count - Last updated - V4 (25-Jun-2025)
What is IoT? |
How does IoT work? |
What are the core components of an IoT system? |
Define smart devices. |
What is the difference between M2M and IoT? |
Name the layers of the IoT architecture. |
What are some common use cases of IoT? |
What is Industrial IoT (IIoT)? |
What is Consumer IoT? |
Explain the concept of a "connected ecosystem." |
What are sensors? Give examples. |
What are actuators? |
How does a microcontroller differ from a microprocessor? |
Compare Arduino and Raspberry Pi. |
What is the function of an IoT gateway? |
How does a GPS sensor work in an IoT device? |
What is an ADC (Analog to Digital Converter)? |
What is GPIO in hardware? |
Name common power sources for IoT devices. |
How do you select sensors for an IoT application? |
What is MQTT? How does it work? |
What is the use of a broker in MQTT? |
Compare MQTT and HTTP. |
What is CoAP? |
Explain LoRa and its advantages. |
What is Zigbee and where is it used? |
What is BLE (Bluetooth Low Energy)? |
What is 6LoWPAN? |
What is the role of a MAC address in IoT? |
Compare LPWAN vs Wi-Fi for IoT. |
What is an IoT platform? |
Compare AWS IoT Core, Azure IoT Hub, and Google IoT Core. |
What is ThingSpeak? |
What is Node-RED? |
What is EdgeX Foundry? |
What is device provisioning in IoT platforms? |
How do you monitor device status remotely? |
What is a digital twin? |
What is OTA (Over-the-Air) update? |
How do you debug IoT software remotely? |
What is the OSI model and how does it relate to IoT? |
What are PAN, LAN, and WAN in IoT networks? |
What is an IPv6 address and why is it important for IoT? |
How is NAT traversal handled in IoT? |
What is mesh networking? |
Compare star, mesh, and tree topologies in IoT. |
What is a SIM card used for in IoT? |
What are narrowband communications? |
What is a MAC layer protocol? |
What is NB-IoT? |
Why is security critical in IoT? |
What are the most common IoT security threats? |
What is a DDoS attack in IoT? |
What is secure boot? |
How do you encrypt communication in IoT? |
What is mutual authentication? |
How do you ensure firmware integrity? |
What is role-based access control (RBAC)? |
What is TLS/SSL and how is it used in IoT? |
How do you store sensitive data securely on a device? |
What are the types of data collected in IoT? |
What is real-time analytics in IoT? |
How is big data related to IoT? |
What is data aggregation? |
What is stream processing? |
What is time-series data? |
How do you visualize sensor data? |
How does edge analytics work? |
What is latency in IoT data flow? |
What is the role of AI/ML in IoT? |
What is edge computing? |
Compare edge and cloud computing. |
Why use edge computing in IoT? |
What is fog computing? |
What are the benefits of edge AI? |
How do edge nodes communicate with the cloud? |
What are serverless functions in IoT? |
What is a cloud-to-device message? |
What is the latency difference between cloud and edge? |
What are the main challenges in cloud-IoT integration? |
What operating systems are used in IoT devices? |
What is TinyOS? |
What is Contiki OS? |
What is RIOT OS? |
What programming languages are used for IoT development? |
What is FreeRTOS? |
What is an RTOS and why is it important for IoT? |
What is firmware in IoT? |
What tools are used for debugging embedded software? |
What IDEs support IoT development? |
How do you test IoT hardware? |
What are the key metrics for IoT performance testing? |
What is stress testing in IoT? |
How do you simulate IoT devices? |
What is device provisioning? |
What is lifecycle management in IoT? |
How do you handle failed firmware updates? |
What is remote device management? |
What is device health monitoring? |
How do you scale an IoT solution? |
|
|
|
#Neural_Network
Question count - Last updated - V4 (17-Aug-2024)
Neural_Network | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
11 August 2024
#GitHub_Actions
Question count - Last updated - V4 (11-Aug-2024)
GitHub_Actions | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
#Azure_DevOps
Last updated - V4 (13-Sep-2025)
|
09 August 2024
#Spring_LDAP
Question count - Last updated - V4 (09-Aug-2024)
Spring_LDAP | |||||||||
Question | Option A | Option B | Option C | Option D |
---|
|
Subscribe to:
Posts (Atom)
Most views on this month
-
#CoreJava Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction History of Java, Fe...
-
#GIT Question count - Last updated - V4 (02-Sep-2025) Key Concepts Level Subtopic Topics Basic Introductio...
-
#Python Question count - Last updated - V4 (01-Sep-2025) Key Concepts Level Subtopic Topics Basic Language...
-
#Machine Learning Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction to ML ...
-
#Spring_Framework Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction What i...
-
#MongoDB Key Concepts Level Topic Subtopics Basic Introduction to MongoDB What is MongoDB, Features, Advantages, NoS...
-
#Apache_Kafka Question count - Last updated - V4 (02-Sep-2025) Key Concepts Level Subtopic Topics Basic Ka...
-
#Apache_Spark Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction to Spark ...
-
#AWS Question count - 0 Last updated - V4 (08-Jun-2025) Interview question What is EC2? What is SnowBall? What is Clou...
-
#Docker Question count - 0 Last updated - V4 (12-Sep-2024) Interview question What is a Container? What does the docker...
Popular Posts
-
#CoreJava Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction History of Java, Fe...
-
#Kubernetes Question count - 0 Last updated - V4 (06-Jan-2025) Interview question Define Stateful sets in Kubernetes. D...
-
Category Service AWS Azure GCP IBM cloud Oracle cloud Allibaba cloud Comput...
-
#Spring_Framework Last updated - V4 (13-Sep-2025) Key Concepts Level Topic Subtopics Basic Introduction What i...
-
#CoreJava_08 Question count - 0 Last updated - V4 (13-Jun-2025) Interview question What were the issues that were fixed ...
-
#Apache_Kafka Question count - Last updated - V4 (02-Sep-2025) Key Concepts Level Subtopic Topics Basic Ka...
-
#AWS Question count - 0 Last updated - V4 (08-Jun-2025) Interview question What is EC2? What is SnowBall? What is Clou...
-
#Docker Question count - 0 Last updated - V4 (12-Sep-2024) Interview question What is a Container? What does the docker...
-
#MongoDB Key Concepts Level Topic Subtopics Basic Introduction to MongoDB What is MongoDB, Features, Advantages, NoS...
-
#Spring_Cloud Question count - 0 Last updated - V4 (18-Jun-2025) Interview question What is Spring Cloud? What are the ...