Microsoft Shortcuts
Use to switch between open items
Alt + tab
This is the year when PowerShell was introduced
What is 2006?
SQL Server DB - These are 5 system database types
what is master, model, msdb, tempdb, resourcedb, distributor, ReportServer, ReportServerTempDB?
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
This word starts a SQL statement.
What is Select?
Used to open Task Manager
Ctrl + Shift + Esc
This command stops a node in a Network Load Balancing (NLB) cluster.
What is Stop-NlbClusterNode?
SSAS - These are two SSAS dimension types
What is Database Dimension, Cube Dimension and Linked Dimension?
This is an application that can be used to develop and share reports.
What is the Power BI Desktop?
This symbol brings back all the rows and columns.
What is *?
Used to refresh the current browser window
What is the F5 Key?
You must set this before you can run a PowerShell script.
What is an execution policy?
SSRS - Use this to determine if SSRS reports are being used
What is the ExecutionLog?
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?
This function lists the current date
What is sysdate?
Used to restore minimized windows
Windows Logo + Shift + M
This PowerShell command changes the current directory to the directory that was most recently stored by the pushd command.
What is popd?
This SQL Server platform is used for data integration and workflow applications.
What is SSIS?
These are 2 ways which Power BI access data.
What is Direct Query and Import?
This symbol ends a SQL Statement
What is ;?
Used to delete without confirmation?
What is SHIFT + DEL?
These men designed PowerShell.
Who are Jeffrey Snover, Bruce Payette, James Truher?
SSAS - Clients communicate with Analysis Services using this standard protocol for issuing commands and receiving responses.
What is XMLA (XML for Analysis)?
This Power BI feature allows you to add new tables based on data you've already loaded into the model.
What is a Calculated Table?
This command can be processed as an inline view or resolved as a temporary table. It was implemented in Oracle 9.2
What is a WITH clause?