Microsoft SQL Server test for hiring
Check how candidates apply T-SQL, design database objects, tune queries and handle SQL Server administration.
- 10 рморм┐рмирм┐рмЯрнН
- 15рмЯрм┐ рмкрнНрм░рм╢рнНрми
- рмормзрнНрнЯрмо рм╕рнНрмдрм░
- рммрм╣рнБ-рммрм┐рмХрм│рнНрмк
- рмЗрмВрм░рм╛рмЬрнАрм░рнЗ рмкрнНрм░рм╢рнНрми (рмЗрмВрм░рм╛рмЬрнА)
- рмХрнЗрммрм│ рмбрнЗрм╕рнНрмХрмЯрмкрнН
рм╕рмВрмХрнНрм╖рм┐рмкрнНрмд рмЙрмдрнНрмдрм░
The Microsoft SQL Server test is a 10-minute, 15-question check of intermediate hands-on work. It measures T-SQL querying, schema and object design, indexing and query performance, plus server administration and access. Use it to assess database developers and administrators, engineers and BI developers who write T-SQL, and consultants who support SQL Server systems.
рмПрм╣рм╛ рмХтАЩрмг рморм╛рмкрнЗ
Practical knowledge of T-SQL, schema design, query performance and server administration in Microsoft SQL Server.
T-SQL querying
Questions ask candidates to read or write T-SQL and reason about what a short listing returns or does.
Schema and object design
Questions cover designing tables and database objects.
Indexing and query performance
Questions cover using indexes and execution plans to make queries run well.
Server administration and access
Questions cover day-to-day server work, including backups, restores, permissions and configuration.
рмкрнНрм░рм╢рнНрмирм░ рмзрм░рмг
рммрм╣рнБ-рммрм┐рмХрм│рнНрмк
рмХрнНрнЯрм╛рмгрнНрмбрм┐рмбрнЗрмЯрнН: рмПрмХ рм╕рмВрмХрнНрм╖рм┐рмкрнНрмд рмкрм░рм┐рм╕рнНрмерм┐рмдрм┐, рм╕рм╛рм░рмгрнА рмХрм┐рморнНрммрм╛ рммрмХрнНрмдрммрнНрнЯ рмкрмврм╝рм┐ рм╕рмарм┐рмХрнН рмЙрмдрнНрмдрм░, рмХрм┐рморнНрммрм╛ рм╕рморм╕рнНрмд рм╕рмарм┐рмХрнН рмЙрмдрнНрмдрм░ рммрм╛рмЫрнЗред
рмЖрмкрмг рмжрнЗрмЦрм┐рммрнЗ: рмХрнНрнЯрм╛рмгрнНрмбрм┐рмбрнЗрмЯрнНтАМ рмПрм╣рм┐ рммрм┐рм╖рнЯрммрм╕рнНрмдрнБрмХрнБ рмХрнЗрммрм│ рмЪрм┐рм╣рнНрмирм┐рммрм╛ рмирнБрм╣рнЗрмБ, рмкрнНрм░рнЯрнЛрмЧ рмХрм░рм┐рммрм╛ рмкрм╛рмЗрмБ рмпрмернЗрм╖рнНрмЯ рмнрм▓ рмнрм╛рммрнЗ рмЬрм╛рмгрм┐рмЫрмирнНрмдрм┐ рмХрм┐ рмирм╛рм╣рм┐рмБред
10 рморм┐рмирм┐рмЯрнНтАМрм░рнЗ 15рмЯрм┐ рмкрнНрм░рм╢рнНрми, рмЧрнЛрмЯрм┐рмП рмкрм░рнЗ рмЧрнЛрмЯрм┐рмП рмжрм┐рмЖрмпрм╛рмПред
рмПрм╣рм┐ рмЯрнЗрм╖рнНрмЯ рмЙрмкрмпрнБрмХрнНрмд рмнрнВрморм┐рмХрм╛рмЧрнБрмбрм╝рм┐рмХ
Database developers and database administrators who work with Microsoft SQL Server, back-end and data engineers who write T-SQL, reporting and BI developers, and consultants who support SQL Server systems.
See applied SQL Server knowledge
Look beyond listed experience
Short T-SQL listings and small result tables show how a candidate reasons about querying, not just which tools appear on a resume.
Cover connected work areas
One test checks schema and object design, indexing and query performance, and server administration and access.
Focus follow-up time
Use the results to choose which SQL Server tasks to explore in a work sample and interview, rather than treating a score as a hiring decision.
рмкрнНрм░рмдрнНрнЯрнЗрмХ рмХрнНрнЯрм╛рмгрнНрмбрм┐рмбрнЗрмЯрнНтАМрмЩрнНрмХ рмкрм╛рмЗрмБ рмЖрмкрмг рмХтАЩрмг рмкрм╛рмЗрммрнЗ
- рм╕рмормЧрнНрм░ рмкрм░рнАрмХрнНрм╖рм╛ рм╕рморнЯрм░рнЗ рмкрм░рнАрмХрнНрм╖рм╛ рмЯрнНрнЯрм╛рммрнНтАМрм░рнЗ рм░рм╣рм┐рмерм┐рм▓рнЗ
- рмкрнЗрм╖рнНрмЯ рмХрм░рм╛рмпрм╛рмЗрмерм┐рммрм╛ рмЙрмдрнНрмдрм░ рмирм╛рм╣рм┐рмБ
- рм╕рнНрмерм┐рм░ рмЧрмдрм┐рм░рнЗ рмЙрмдрнНрмдрм░ рмжрнЗрм▓рнЗ
рм╕рнНрмХрнЛрм░рнН, рмкрнНрм░рнЛрмлрм╛рмЗрм▓рнН рмПрммрмВ Integrity Score рм╕рмЩрнНрмХрнЗрмдрмЧрнБрмбрм╝рм┐рмХ рм╕рм╛рмХрнНрм╖рм╛рмдрнНрмХрм╛рм░ рм╕рм╣рм┐рмд рмЖрмкрмг рм╕рморнАрмХрнНрм╖рм╛ рмХрм░рм┐рммрм╛ рмкрм╛рмЗрмБ рмкрнНрм░рморм╛рмг, рмХрнЗрммрнЗрм╣рнЗрм▓рнЗ рм╕рнНрн▒рнЯрмВрмЪрм╛рм│рм┐рмд рмирм┐рм╖рнНрмкрмдрнНрмдрм┐ рмирнБрм╣рнЗрмБред
рмПрм╣рм┐ рмЯрнЗрм╖рнНрмЯ рморм╛рмЧрмгрм╛рм░рнЗ рммрнНрнЯрммрм╣рм╛рм░ рмХрм░рмирнНрмдрнБ
Test setup and integrity signals
Each candidate receives a different set of questions from large pools. Question order and answer options are shuffled, and the browser shows one question at a time. The test lasts 10 minutes and candidates cannot go back to earlier questions. Timing runs on the server, so reloading restores the same question with only the time left. Question text cannot be copied or selected, and a blocked copy attempt is recorded in the timeline. HireValid records signals such as time away from the test tab, pastes into answers, and answers faster than a question can be read. The employer can review these signals in an Integrity Score and evidence timeline; neither makes a decision on its own. With candidate consent, the employer can add webcam photos at random moments.
рмЖрморнЗ AI рморм╛рмзрнНрнЯрморм░рнЗ рмармХрнЗрмЗ рмХрм┐рмкрм░рм┐ рм░рнЛрмХрнБ ┬╖ рм╕рмдрнНрнЯрмирм┐рм╖рнНрмарм╛ рм╕рмЩрнНрмХрнЗрмд
Use the score as evidence
Review the score alongside a work sample and a structured interview. For example, ask the candidate to explain a T-SQL choice or discuss an indexing approach, then compare that reasoning with the test evidence. Do not use the score alone to decide. For related coverage, compare SQL Coding: Querying or PostgreSQL. See the pre-employment testing guide for more on using assessments in hiring.
Structured interview questions
How would you investigate a SQL Server query that is running slowly?
Listen for a practical approach involving the query, indexes and execution plans, with reasoning tied to the example.
Tell me how you would design tables and database objects for a new reporting need.
Listen for a clear explanation of the proposed structure and how it supports the requested data.
Walk me through how you would handle a backup and restore task on a SQL Server system.
Listen for a coherent account of the steps and the permissions or configuration they would consider.
рм╕рнНрмХрнЛрм░рм┐рмВ рмУ рморм╛рмирмжрмгрнНрмб рммрнБрмЭрмирнНрмдрнБ
рмирм┐рм░рмкрнЗрмХрнНрм╖рмдрм╛ рмПрммрмВ рмЖрммрм╢рнНрнЯрмХ рм╕рнБрммрм┐рмзрм╛
Questions describe behavior in SQL Server 2019 and later with default settings unless a question says otherwise, so nothing depends on an older version or an unusual setup. Sample data uses neutral business tables (orders, stock, shifts, tickets) with no money symbols, dates written as unambiguous ISO literals, and names from many backgrounds. Code listings are short and follow one consistent style, and the test asks for a computer so listings are large enough to read.
рмпрнЗрмХрнМрмгрм╕рм┐ рмкрнНрм░рм╛рм░рнНрмернАрмЩрнНрмХрнБ рмЖрммрм╢рнНрнЯрмХ рм╕рнБрммрм┐рмзрм╛ рмнрм╛рммрнЗ рмЕрмдрм┐рм░рм┐рмХрнНрмд рм╕рморнЯ рмжрнЗрмЗрмкрм╛рм░рм┐рммрнЗред рмлрм│рм╛рмлрм│ рмЬрмгрнЗ рммрнНрнЯрмХрнНрмдрм┐рмЩрнНрмХ рм╕рморнАрмХрнНрм╖рм╛ рмкрм╛рмЗрмБ рмЖрмзрм╛рм░ рморм╛рмдрнНрм░; рмПрм╣рм╛ рмХрнЗрммрнЗ рммрм┐ рм╕рнНрн▒рнЯрмВрмЪрм╛рм│рм┐рмд рмирм┐рм╖рнНрмкрмдрнНрмдрм┐ рмирнБрм╣рнЗрмБред
Provisional: reliability is reported once 200 candidates have completed it.
рмкрм░рнАрмХрнНрм╖рм╛рм░ рммрм┐рммрм░рмгрнА
A short, timed check of hands-on Microsoft SQL Server work at an intermediate level. Questions cover writing and reading T-SQL, designing tables and database objects, making queries run well with indexes and execution plans, and running a server day to day: backups, restores, permissions and configuration. Most questions show a short T-SQL listing or a small table of results and ask what happens, what it returns or which choice is right.
- рмкрнНрм░рм╢рнНрмирмЧрнБрмбрм╝рм┐рмХ рмЗрмВрм░рм╛рмЬрнАрм░рнЗ рмЕрмЫрм┐ред
- рмХрнМрмгрм╕рм┐ рм╕рм╣рм╛рнЯрмХ рм╕рм╛рмормЧрнНрм░рнА рмЖрммрм╢рнНрнЯрмХ рмирм╛рм╣рм┐рмБред
- рмкрнНрм░рмдрнНрнЯрнЗрмХ рмкрнНрм░рм╢рнНрмирм░ рмЙрмдрнНрмдрм░ рмХрнНрм░рморм╛рмирнБрм╕рм╛рм░рнЗ рмерм░рнЗ рмжрм┐рмЖрмпрм╛рмПред рмкрмЫрмХрнБ рмлрнЗрм░рм┐рммрм╛рм░ рм╕рнБрмпрнЛрмЧ рмирм╛рм╣рм┐рмБред
- рм╕рморнЯ-рмирм┐рм░рнНрмжрнНрмзрм╛рм░рм┐рмд рмкрм░рнАрмХрнНрм╖рм╛ рмкрнВрм░рнНрммрм░рнБ 4 рморм┐рмирм┐рмЯрнНтАМрм░рнЗ 4рмЯрм┐ рмЕрмнрнНрнЯрм╛рм╕ рмкрнНрм░рм╢рнНрмиред
- рмбрнЗрм╕рнНрмХрмЯрмкрнН рмХрм┐рморнНрммрм╛ рм▓рм╛рмкрмЯрмкрнН рмХрморнНрмкрнНрнЯрнБрмЯрм░рм░рнЗ рмжрм┐рмЖрмпрм╛рмПред
Microsoft SQL Server рмПрм╣рм╛рм░ рморм╛рм▓рм┐рмХрмЩрнНрмХрм░ рмЯрнНрм░рнЗрмбрнНтАМрморм╛рм░рнНрмХред HireValid рмПрм╣рм╛ рм╕рм╣ рмЬрмбрм╝рм┐рмд рмирнБрм╣рнЗрмБ рмХрм┐рморнНрммрм╛ рмПрм╣рм╛ рмжрнНрн▒рм╛рм░рм╛ рм╕рморм░рнНрмерм┐рмд рмирнБрм╣рнЗрмБред
рммрм╛рм░рморнНрммрм╛рм░ рмкрмЪрм░рм╛рмпрм╛рмЙрмерм┐рммрм╛ рмкрнНрм░рм╢рнНрми
What does the Microsoft SQL Server test measure?+
It covers practical T-SQL, schema and object design, indexing and query performance, and server administration and access. Many questions show a short T-SQL listing or a small table of results and ask what happens, what it returns, or which choice is right.
Who should take the Microsoft SQL Server test?+
It is intended for database developers and database administrators who work with Microsoft SQL Server, as well as back-end and data engineers who write T-SQL, reporting and BI developers, and consultants who support SQL Server systems.
How long is the Microsoft SQL Server test, and does it need a computer?+
It has 15 multiple-choice questions and a 10-minute limit. Candidates need a computer, so code listings are large enough to read, and they cannot return to earlier questions. A separate practice set has 4 questions and takes 4 minutes.
What SQL Server versions and settings does the Microsoft SQL Server test use?+
Questions describe behavior in SQL Server 2019 and later with default settings unless a question says otherwise. Reliability is provisional and will be reported once 200 candidates have completed the test.
рм╕рморнНрммрмирнНрмзрм┐рмд рмкрм░рнАрмХрнНрм╖рм╛
PostgreSQL
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБрмбрнЗрмнрнЗрм▓рмкрм░рнНтАМрморм╛рмирмЩрнНрмХ рмкрм╛рмЗрмБ MariaDB
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБMongoDB
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБElasticsearch
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБOracle DBMS
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБSQL Server Management Studio
10 рморм┐рмирм┐рмЯрнН, рм╕рмлрнНрмЯрн▒рнЗрм░рнН рмжрмХрнНрм╖рмдрм╛
рмЕрмирнБрм╕рмирнНрмзрм╛рми рмХрм░рмирнНрмдрнБрмЖрмкрмгрмЩрнНрмХ рмкрм░рммрм░рнНрмдрнНрмдрнА рмирм┐рмпрнБрмХрнНрмдрм┐рм░рнЗ Microsoft SQL Server рмЯрнЗрм╖рнНрмЯ рммрнНрнЯрммрм╣рм╛рм░ рмХрм░рмирнНрмдрнБ
Free рм╕рм╣рм┐рмд рмкрнНрм░рмдрнНрнЯрнЗрмХ рмкрнНрм▓рм╛рмирнНтАМрм░рнЗ рмкрнВрм░рм╛ test library рмЙрмкрм▓рммрнНрмз рмЕрмЫрм┐ред