01Impact of Orphan CustomerID Values When Joining Orders to Customers
MCQPremium 02Interpreting 20% Revenue Growth With Flat Units and Tripled Discounts
MCQPremium 03Cutting Idle Compute Cost on a Snowflake Warehouse
MCQPremium 04What RANK() OVER PARTITION BY Department Produces
MCQPremium 05Effect of Appending Through a Second Reference to a Python List
MCQPremium 06First Validation Check Before Publishing Monthly Revenue Growth
MCQPremium 07Improving Micro-Partition Pruning on a Large Snowflake Table
MCQPremium 08Result of groupby Region Sales mean in Pandas
MCQPremium 09Which Data Quality Defect to Fix First for Revenue Reporting
MCQPremium 10Reading Subscription Growth Against Falling ARPU and Rising Churn
MCQPremium 11Smallest Number With Remainders 2, 3 and 2 Modulo 3, 5 and 7
MCQPremium 12Probability Both Drawn Balls Share the Same Colour
MCQPremium 13Average Speed Over Two Equal Halves at 60 and 90 km/h
MCQPremium 14Committees of Four Excluding One Forbidden Pair
MCQPremium 15Valid Seating Order for Five Candidates in a Row
MCQPremium 16Syllogism Conclusion That Must Follow From Three Premises
MCQPremium 17Trailing Zeros in 125 Factorial
MCQPremium 18Probability of Exactly Four Heads in Six Coin Tosses
MCQPremium 19Candidates Knowing None of Three Skills
MCQPremium 20Data Sufficiency: Value of x from Two Linear Equations
MCQPremium 21Snowflake Capability for Sharing Data Without Copying
MCQPremium 22Pandas Function That Shows the First Five Rows
MCQPremium 23Python List Method That Adds an Item at the End
MCQPremium 24Output of list(range(1, 5)) in Python
MCQPremium 25Pandas Function That Removes Duplicate Rows
MCQPremium 26Speeding Up a Single-Key Lookup on a Large Orders Table
MCQPremium 27What a Snowflake Virtual Warehouse Actually Is
MCQPremium 28Python String Method That Splits on a Delimiter
MCQPremium 29Inner Join of Employees and Departments on DeptID
MCQPremium 30Snowflake Feature That Decouples Storage from Compute
MCQPremium 31Truthiness of a Non-Empty String in Python
MCQPremium 32Finding Duplicate Emails with GROUP BY and HAVING COUNT
MCQPremium 33Pandas Attribute That Returns DataFrame Column Names
MCQPremium 34Remainder Produced by 15 % 4 in Python
MCQPremium 35Filtering Grouped Counts with HAVING Instead of WHERE
MCQPremium 36Values Generated by range(4) in Python
MCQPremium 37Primary Purpose of the Snowflake Platform
MCQPremium 38Salaries Above the Average Using a Scalar Subquery
MCQPremium 39Python Statement That Skips the Current Loop Iteration
MCQPremium 40Product with the Highest Grouped Revenue Using GROUP BY and LIMIT
MCQPremium 41Result of Multiplying a String by an Integer in Python
MCQPremium 42Pandas Method That Displays Column Names and Data Types
MCQPremium 43Type of the Literal 3.14 in Python
MCQPremium 44Names Returned by ORDER BY Salary DESC with LIMIT 2
MCQPremium 45Operator Used for Exponentiation in Python
MCQPremium 46Pandas Method That Returns Summary Statistics of Numeric Columns
MCQPremium 47Python Built-in That Returns the Largest Value in a List
MCQPremium 48Rows Returned by SELECT DISTINCT on a Duplicated Customer Column
MCQPremium 49Character Count Returned by len("Analytics")
MCQPremium 50Matching a Word Anywhere in a Text Column with LIKE
MCQPremium