Qrankr
All kits
Data

Data & Analytics

Analyst and data roles. Questions about working with data, drawing insights, and communicating findings to stakeholders.

Technical
Critical Thinking
Attention to Detail

16 questions in this kit

1

What are the most important database performance metrics, and how do you monitor them?

medium
Technical
Problem-Solving
Attention to Detail
0
2

You have learned that a business unit is managing a major component of the business using Excel spreadsheets and Access databases. What risks does this present, and what would you recommend be done to mitigate those risks?

hard
Critical Thinking
Problem-Solving
Technical
0
3

What steps would you take if you were assigned a task that required precise data analysis under a tight deadline?

medium
Attention to Detail
Time Management
0
4

Describe a time when you had to analyze complex data to inform a business decision.

medium
Business
Critical Thinking
0
5

Can you provide an example of how you used insight from data to inspire a creative business strategy?

medium
Creativity
Business
Critical Thinking
0
6

Can you provide an example of a time when you had to analyze data to make a decision? What was your process?

medium
Problem-Solving
Technical
Critical Thinking
0
7

Tell me about a time you used data analysis to influence a business decision.

medium
Technical
Critical Thinking
Business
0
8

Can you provide an example of how you used data analytics to improve trade outcomes?

medium
Trade
Technical
Problem-Solving
0
9

How do you enforce relational integrity in database design?

hard
Technical
Problem-Solving
Attention to Detail
0
10

When is it appropriate to de-normalize database design?

hard
Technical
Critical Thinking
Problem-Solving
0
11

In databases, what is the difference between a delete statement and a truncate statement?

medium
Technical
0
12

How comfortable are you using spreadsheet software?

easy
Technical
Problem-Solving
0
13

What does the primary key of a database table represent? What about its secondary key?

medium
Technical
0
14

What is the difference between an operational database, relational database, and object-oriented database?

hard
Technical
0
15

How would you migrate a database built in MySQL to Microsoft SQL Server?

hard
Technical
Problem-Solving
0
16

What technologies and processes are used to secure data that moves to cloud services?

hard
Technical
Critical Thinking
Problem-Solving
0