TechBis

10 SQL Multiple Choice Questions (MCQs)  1. Which SQL statement is used to retrieve data from a database? A. GET B. SELECT C. FETCH D. READ ✅ Answer: B. SELECT 2. What does the WHERE clause do in SQL? A. Groups records B. Filters records C. Sorts records D. Deletes records ✅ Answer: B. Filters records 3. Which SQL function is used to count the number of rows? A. COUNT() B. SUM() C. TOTAL() D. LENGTH() ✅ Answer: A. COUNT() 4. Which keyword is used to sort the result-set in SQL? A. ORDER B. GROUP C. SORT D. ORDER BY ✅ Answer: D. ORDER BY 5. What is the default sorting order of ORDER BY clause? A. Random B. Descending C. Ascending D. Alphabetical ✅ Answer: C. Ascending 6. What does the SQL JOIN clause do? A. Combines rows from multiple tables B. Deletes rows from a table C. Finds duplicates D. Creates new tables ✅ Answer: A. Combines rows from multiple tables 7. Which JOIN returns only the matching rows from both tables? A. LEFT JOIN B...

 20 ChatGPT-related MCQs 1. ChatGPT is primarily trained on data available until: A. Real-time data B. December 2023 C. April 2022 D. Depends on version 👉 Answer: D (Each model has a different cutoff) 2. Which model is used in ChatGPT-4? A. GPT-2 B. GPT-3 C. GPT-4 D. GPT-5 👉 Answer: C 3. Which of the following is a major use case of ChatGPT? A. Cooking food B. Editing photos C. Answering questions and drafting text D. Sending emails automatically 👉 Answer: C 4. What is the default interface ChatGPT uses to interact with users? A. Terminal B. Text chat interface C. Graphical dashboard D. Voice control 👉 Answer: B 5. ChatGPT can write code in which of the following languages? A. Python B. JavaScript C. SQL D. All of the above 👉 Answer: D 6. What is the maximum token limit (approx.) for a GPT-4-turbo context window? A. 1,000 B. 4,000 C. 128,000 D. 256,000 👉 Answer: C (As of 2024, GPT-4-turbo supports 128k context) 7. What is a "to...

  💼 Top Jobs in Microsoft Fabric Ecosystem 1. Microsoft Fabric Developer Key Skills: DAX, Power BI, Dataflows, Notebooks, KQL (Kusto Query Language) Responsibilities: Build and maintain Power BI reports and dashboards Work with Fabric Workspaces, Pipelines, and Lakehouses Use Copilot to automate parts of development 2. Data Engineer – Microsoft Fabric Key Skills: Data Pipelines, Lakehouse Architecture, Delta Lake, Spark Notebooks Responsibilities: Build ETL/ELT dataflows in Fabric Integrate various data sources into OneLake Optimize and manage data pipelines using Fabric Data Engineering tools 3. Fabric Solution Architect Key Skills: Azure Synapse, Power BI, Microsoft Fabric, Governance, Security Responsibilities: Design end-to-end data architecture using Fabric components Define data security, data quality, and data governance policies Guide teams on how to use Fabric most effectively 4. Data Scientist – Fabric AI Integration Key Skills: Pytho...

Top 10 Power BI Features That Changed the Game 🚀 If you're a data enthusiast, analyst, or business intelligence developer, you know Power BI has come a long way. With every update, it's not just evolving — it's redefining how we analyze and visualize data. In this post, I’ll walk you through 10 Power BI features that have truly changed the game — making reports smarter, faster, and more intuitive than ever. 1. 💡 DAX (Data Analysis Expressions) Power BI’s DAX language gives you superpowers . From calculating running totals to dynamic year-over-year comparisons — if you can think it, DAX can calculate it. 🔍 Example: CALCULATE(SUM(Sales[Amount]), YEAR(Today()) = 2024)   2. 🧹 Power Query Before dashboards, there's dirty data. Power Query lets you clean, transform, and shape your data effortlessly — all with a no-code, user-friendly interface. Think of it as Excel’s Power Editor — on steroids.   3. 🧠 Data Modeling Relationships matter — in life and in Power BI. Da...

  Why SQL Is Still Important in 2025 ✅ 1. Data is Everywhere — and SQL is Its Language SQL (Structured Query Language) is still the standard way to talk to databases . Whether it's MySQL, PostgreSQL, SQL Server, or even cloud platforms like Snowflake, BigQuery, or Azure Synapse — they all use SQL. 💼 2. Job Market Still Demands It Data analysts, Power BI developers, data engineers, and even ML engineers are all expected to know SQL. Over 70% of data-related job descriptions in 2025 still list SQL as a required skill . 🧠 3. It’s the Foundation of Business Intelligence Tools Tools like Power BI, Tableau, Looker, and Superset rely on SQL for: Custom queries DirectQuery modes SQL-based data transformations 🌐 4. Cloud & Big Data Tools Are Built on SQL Platforms like Google BigQuery, Amazon Redshift, Snowflake, and Azure Data Explorer all support SQL-first interfaces . Even modern “no-code” platforms generate SQL in the background! 🔧 5. Sti...

Microsoft Fabric Pricing in 2025 — Everything You Need to Know 2️⃣ Storage (OneLake) OneLake — the unified data lake behind Fabric — is priced separately: 💾 $0.023/GB/month ( $23 per TB) Deleted data retained for 7–90 days (still billable) Includes lakehouse and KQL caches 3️⃣ Power BI Licensing Microsoft Fabric is deeply integrated with Power BI. Here’s how licensing works: Power BI Pro: $14/user/month Power BI Premium Per User: $24/user/month With F64+ capacity: Viewers don’t need a Pro license — only creators do 📊 Below F64, every user still requires a Pro license to consume content. 4️⃣ Consumption Flexibility ✅ Pay-as-you-go allows pausing unused capacity during off-hours. 🧠 Reserved plans offer cost predictability for consistent workloads. 🎯 Fabric workloads (Power BI, Synapse, Data Factory) share the same capacity — no double-billing. 🧮 Sample Cost Scenario A medium-sized team using F8 capacity: Compute: ~$1,051/month Storage: ~$50/m...