Microsoft Shortcuts
PowerShell
SQL Server
Power BI
Redmond, Washington
100

Use to switch between open items

Alt + tab

100

This is the year when PowerShell was introduced

What is 2006?

100

SQL Server DB - These are 5 system database types

what is master, model, msdb, tempdb, resourcedb, distributor, ReportServer, ReportServerTempDB?

100

Data Visualization - Three chart types found in Power BI

Stacked Bar Chart, Stacked Column Chart, Clustered Bar Chart, Clustered Column Chart, 100% Stacked Bar Chart, 100% Stacked Column Chart, Line Chart, Area Chart, Stacked Area Chart, Line and stacked column chart, Line and clustered column chart, Ribbon Chart, Waterfall chart, Scatter Chart, Pie chart, Donut chart, Treemap, Map, Filled Map, Funnel Gauge, Card, Multi-Row Card, KPI Slicer, Table Martix, R Script Visual, ArcGIS Maps

100

Politics - This is the Governor of Redmond

Who is Jay Inslee?

200

Used to open Task Manager

Ctrl + Shift + Esc

200

This command stops a node in a Network Load Balancing (NLB) cluster.

What is Stop-NlbClusterNode?

200

SSAS - These are two SSAS dimension types

What is Database Dimension, Cube Dimension and Linked Dimension?

200

This is an application that can be used to develop and share reports. 

What is the Power BI Desktop?

200

Technology - These technology companies are known for their home being in Redmond, Washington.

Microsoft & Nintendo


300

Used to refresh the current browser window

F5 Key

300

You must set this before you can run a PowerShell script.

What is an execution policy?

300

SSRS - Use this to determine if SSRS reports are being used

What is the ExecutionLog?

300

A setting that can be configured to manage how end users see data; this configuration can remove rows based on user groups.

What is Row Level Security?

300

Geography - 3 cities that border Redmond


Bellevue

Kirkland

Sammamish 

Bothell

Cottage Lake

400

Used to restore minimized windows

Windows Logo + Shift + M

400

These men designed PowerShell.

Who are Jeffrey Snover, Bruce Payette, James Truher?

400

SSAS - Clients communicate with Analysis Services using this standard protocol for issuing commands and receiving responses.

What is XMLA (XML for Analysis)?

400

These are 2 ways to optimize bad performing reports that are using Premium resources (RAM/CPU).

What is Direct Query, Incremental Refresh, Query Optimization?
400

History - Because salmon was so abundant in the Sammamish River when the first pioneers arrived in 1871, they called their settlement this, which is now Redmond.

Salmonberg