Technology
What platform does the JHAS Data Load Pipeline live on?
Azure Data Factory
How many live data sources do we currently have?
1 - JHAS
What type of database is Salesforce?
A transactional Database
What is the farthest man made object from Earth?
Voyager 1
Fill in the blank. There are 13 _____ in a round of Hearts
What's the primary language we use to write dbt models?
SQL with a little bit of Jinja sprinkled on top
The Exposed models
What type of database is a Data Warehouse?
An Analytic Database
How many stars are in the Milky Way?
100-400 billion
You get three tries. Which hand has a coin?
It's a trick!
What are the two compute resources in Azure Synapse Analytics?
SQL Pools and Apache Spark Pools
What are the types of models used to build an exposed model?
construction models:
- spines
- features
- metrics
What is a data dictionary?
A centralized reference for business logic, structure, and format of data
What is the rarest known natural substance in the Universe?
Wood
How many syllables are in the word "Monosyllableic"
one.
Mono-syllable-ic
What does dbt stand for?
Data Build Platform
What kind of models are used in PowerBI reports and dashboards?
consumption models
What is the difference between a fact and dimension
Facts are quantitative and Dimensions are descriptive
How many planets can fit between the Earth and the Moon?
8
Pluto also fits but it isn't a planet.
One guard always tells the truth and another guard always lies. One door holds certain death and one door is life. You can ask one guard one question to figure out which door to go through. What do you ask?
Which door would the other guard tell me to go through?
What is the protocol used to connect an AI model to our dbt platform?
MCP - Model Context Protocol
How many models are used to build the advisory board dashboard?
Extra 200 points to whoever can list the most.
53
What are the layers and their purposes in a medallion architecture?
- Bronze -> Raw Data Ingestion and basic clean up
- Silver -> Beginnings of business logic and combining data
- Gold -> business ready models for consumption
Assuming no human intervention, when will the last solar eclipse happen?
~1.2 billion years
How many times can you subtract 10 from 100?
Only once.