Library

All TestDome tests and questions grouped by skill

Skills & Roles

Programming & IT

Languages

Frameworks & Libraries

Database Technologies

Mobile & Cross-Platform

Testing & Security

DevOps & Cloud

System Administration

Data Science & Big Data

Engineering

Core Skills

Analytical Reasoning

Soft Skills

MS Office

Common Interview Questions

Business Roles

Administration & Operations

Accounting & Finance

People & Project Management

Customer & Technical Support

Sales & Marketing

UX & Design

133 tests View tests

SQL

MS Excel

Python

1732 questions

Public
Premium

Dog Classification - The following .csv file contains the data from a classifier model that predicts if an image contains a dog: predictions.csv The first column contains information if the dog is in the image or not. The second column contains the classifier prediction, which is in the interval 0-100, with higher values meaning that the classifier is more confident that image contains a dog. What is the value of the decision boundary that will maximize the accuracy of the model? Values greater than or equal to the decision boundary will be treated as positive. New Data Science Classification Decision Boundary Hard 20 min num Public
Fence - No matter how tired Billy is, he never slows down or stops painting. In fact, it would only take Billy 4 hours to paint a fence by himself. It would take Suzy 6 hours to paint the same fence by herself. On Friday, Billy and Suzy worked together to paint the fence, but Billy got tired after only 2 hours. How much time did it take to paint the whole fence? Numerical Reasoning Mechanics Work Rate Hard 5 min mcq Public
Malware Analysis - Your company is analyzing malware software which targets numerical record files. The malware checks the value of each record and the values of some of its neighbors. The record is replaced by 0 when it is smaller or equal to either of those neighbors. For each number, it matches the following pattern, where position 'X', is compared to positions 'T': T, _, _, X, _, _, _, T Positions '_' represent neighbors that are ignored. Positions further beyond the 'T's, to the far left or far right, are also ignored. If the 'X' position is near the left or right border and has no 'T' position neighbor, only one side is considered. The malware finds all the positions first and only then sets them to 0. For example, if the values in a record file are the following: [19, 2, 0, 87, 1, 40, 80, 77, 77, 77, 77] The expected values after the malware runs are: [19, 0, 0, 87, 0, 0, 0, 77, 77, 0, 0] In this example, number 2 was removed because 40 is the bigger number. Implement the simulate function so that the malware behavior is replicated for further study. New JavaScript Arrays Iteration Easy 20 min code Public
Car Dealer - The charts below show the number of cars John sold last year and the profit per car he made. How much did John earn last year? Numerical Reasoning Chart Lookup Easy 5 min num Public
Tires - Five types of tires were tested in three different driving conditions. Consider the following table of their test scores: Tire Type Driving Condition Test Scores Dry Wet Snow Desert 10 4 1 Beach 5 8 5 Mountain 6 9 6 Swamp 7 10 4 Jungle 7 5 6 If a tire type scored 4 or less in any category, it failed the test. What is the highest average score of the tire types that passed the test? Numerical Reasoning Table Lookup Easy 3 min num Public
Sunburn - In the summer, Agathe wore an ill-fitting sun hat and oversized sunglasses to the beach in Greece. Both slipped off when she fell asleep in her swimsuit on the beach at 2 p.m. What will most likely happen to Agathe? Logical Reasoning Conjunction Fallacy Easy 2 min mcq Public
Quantity Projection - A business owner needs a Power BI report which shows the projected quantity for each item. The "quantity" column is in the "items" table. Fill in the blank of the following DAX expression for a new column that will compute the projected quantity, which is the current quantity plus 12%: Projected Quantity = ______________ * 1.12 Power BI DAX Easy 5 min fill Public
Income - Which product line saw the largest absolute increase in income (dollar amount, not percentage) in the second half of the year compared to the first half of the year? Product line Quarters Q1 Q2 Q3 Q4 C# $26,000 $27,000 $33,000 $15,000 JavaScript $20,000 $25,000 $30,000 $18,000 HTML/CSS $1,000 $5,000 $7,000 $1,000 PHP $12,000 $11,000 $14,000 $13,000 Ruby $4,000 $4,000 $5,000 $6,000 Numerical Reasoning Table Lookup Easy 5 min mcq Public
Violin Strings - As a customer support agent for a music equipment company you receive an email from Fatema about a violin she bought last week for her son. She says the strings broke while he was playing in his school’s holiday concert and he was embarrassed to tears. She asks what you can do to make it up to him. New Customer Emails Customer Complaint Customer Service Easy 3 min mmcq Public
Marketing Costs - Implement the desired_marketing_expenditure function, which returns the required amount of money that needs to be invested in a new marketing campaign to sell the desired number of units. Use the data from previous marketing campaigns to evaluate how the number of units sold grows linearly as the amount of money invested increases. For example, for the desired number of 60,000 units sold and previous campaign data from the table below, the function should return the float 250,000. Previous campaigns Campaign Marketing expenditure Units sold #1 300,000 60,000 #2 200,000 50,000 #3 400,000 90,000 #4 300,000 80,000 #5 100,000 30,000 Python for Data Science Linear Regression Machine Learning NumPy Scikit-Learn Hard 30 min code Public
Profit Percentage - A Power BI report has a measure declared as: Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials)) Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis. Power BI DAX Measure Hard 5 min mca Public
Regional Sales Comparison - An insurance company maintains records of sales made by its employees. Each employee is assigned to a state. States are grouped under regions. The following tables contain the data: TABLE regions id INTEGER PRIMARY KEY name VARCHAR(50) NOT NULL TABLE states id INTEGER PRIMARY KEY name VARCHAR(50) NOT NULL regionId INTEGER NOT NULL FOREIGN KEY (regionId) REFERENCES regions(id) TABLE employees id INTEGER PRIMARY KEY name VARCHAR(50) NOT NULL stateId INTEGER NOT NULL FOREIGN KEY (stateId) REFERENCES states(id) TABLE sales id INTEGER PRIMARY KEY amount INTEGER NOT NULL employeeId INTEGER NOT NULL FOREIGN KEY (employeeId) REFERENCES employees(id) Management requires a comparative region sales analysis report. Write a query that returns: The region name. Average sales per employee for the region (Average sales = Total sales made for the region / Number of employees in the region). The difference between the average sales of the region with the highest average sales, and the average sales per employee for the region (average sales to be calculated as explained above). Employees can have multiple sales. A region with no sales should be also returned. Use 0 for average sales per employee for such a region when calculating the 2nd and the 3rd column. See the example case for more details. SQL Aggregation Left Join Select Hard 30 min code Public
Reorder Tasks - A client has a web page with a series of tasks. They want to implement a reordering feature that behaves like the following example: After performing the clicks shown in the animation above, the document's body should be: <div> <span>Prepare presentation</span> <button class="downButton" type="button">↓</button> </div> <div> <span>Read emails</span> <button class="downButton" type="button">↓</button> <button class="upButton" type="button">↑</button> </div> <div> <span>Monthly report</span> <button class="upButton" type="button">↑</button> </div> Implement the function initialize to add the requested functionality. The reordering behavior should work with any number of tasks. New JavaScript DOM Manipulation Event Handling Hard 30 min code Public
Profit per Employee - In which year did the company make the largest profit per employee? Numerical Reasoning Chart Lookup Easy 3 min mcq Public
AB Test - Your company is running a test that is designed to compare two different versions of the company’s website. Version A of the website is shown to 60% of users, while version B of the website is shown to the remaining 40%. The test shows that 8% of users who are presented with version A sign up for the company’s services, as compared to 4% of users who are presented with version B. If a user signs up for the company’s services, what is the probability that she/he was presented with version A of the website? Data Science Bayes' Theorem Probability Hard 7 min num Public
Election Poll - Each day during 2019 an agency asked a hundred randomly selected people which party they would vote for if elections were held that day. Results of the poll were recorded in the following file. The Workers' Party asked for the report which they plan to use to improve their strategy for upcoming elections. Fill in the missing values in the report for 2019: The arithmetic mean of votes for the Workers' Party is: __ (rounded to one decimal place) The median of votes for the Workers' party is: __ (rounded to closest integer) The standard deviation of votes for the Workers' party is: __ (rounded to one decimal place) The difference between the largest and the smallest number of votes for the Workers' party for March is: __ The largest number of votes that any party received on any day is: __ votes. That maximum was achieved on 2019-__-__ by __. The party with the largest difference between the maximum and minimum number of votes is _______. That difference is __ votes. New Data Science Descriptive Statistic Exploratory Data Analysis Easy 20 min fill Public
Lost Watch - David found a vintage watch his father lost 38 years ago. The watch's date showed that it had worked for over two years after his father lost it. When David found the watch, it was 3 times as old as when his father lost it. How old was the watch when David's father lost it? Numerical Reasoning Linear Equations Easy 5 min num Public
Car Dealer Profit - The charts below show the number of cars John sold last year and the profit he made per car. Considering all car types, in which quarter did John make the largest average profit per car? Numerical Reasoning Chart Lookup Hard 5 min mcq Public
Stock Prices - As an entry-level financial analyst, your manager asked you to analyze the prices of a new stock and make a buy-sell recommendation. Daily price trends seems to fluctuate as can be seen below: You need to create a new measure which will create a rolling average for 7-day periods, as below, because an increasing trend in a rolling average may signal an increase in the price of the stock. How should you configure the quick measure, shown below, for the rolling average for the last 7 days? New Power BI Quick Measures Easy 5 min mca Public
Horse Race - Dan put a large bet on a horse. However, a day before the race, the horse was injured. Select which of the following statements are true: Logical Reasoning Appeal to Probability Easy 1 min mca Public

Library

Product

Assessments

Resources

Follow us