Time limit: 0
Quiz Summary
0 of 20 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Quiz complete. Results are being recorded.
Results
0 of 20 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
-
Unfortunately, you didn’t pass the quiz, but hey, you have unlimited access.😎
Practice makes you perfect! 👊 -
Congratulations! 🥳
You have passed the quiz successfully! You are one step closer to pass the real exam!
We hope to see you again on another certification path.✌️
Good luck with the exam! Stay strong.👊
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 20
1. Question
Which of the following data integration processes combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse?
CorrectIncorrect -
Question 2 of 20
2. Question
A web analyst wants to use automated bots to crawl through the internet and extract data from targeted sites. He wants the collected data to be delivered in a readable form such as CSV for further analysis.
Which of the following data collection methods is the MOST appropriate method to employ?
CorrectIncorrect -
Question 3 of 20
3. Question
A database administrator designs a new database with two tables.
-
Employee
-
Department
The Employee table has the following columns:
-
Employee_birthdate
-
Employee_Year_Of_Registration_In_Company
-
Employee_Total_Years_Of_Registration
Which of the following refers to the situation that there is data in the database that can be removed without losing information?
CorrectIncorrect -
-
Question 4 of 20
4. Question
An online shop sends orders based on the zip code customers type during the checkout process. Many orders never received the customers because customers misspell the zip code into the input field.
Which of the following solutions SHOULD the online shop implement to solve this issue?
CorrectIncorrect -
Question 5 of 20
5. Question
A data analyst wants to create “Income Categories” that would be calculated based on the existing variable “Income”.
The “Income Categories” would be as follows:
-
Income category 1: less than $1
-
Income category 2: more than $1 and less than $20,000
-
Income category 3: more than $20,001 and less than $40,000
-
Income category 4: more than $40,001
Which of the following data manipulation techniques should the data analyst use to create “Income Categories”?
CorrectIncorrect -
-
Question 6 of 20
6. Question
An online shop wants to expand its customer base using SMS marketing campaigns. The online shop has already a database with customers with the following columns.
-
First_Name
-
Last_Name
-
Email
The head of marketing wants to add one more column titled “Phone_Numbers”. Also, he wants to match the customer’s names with the respective phone numbers.
Which of the following data manipulation techniques would the head of marketing use to add the phone numbers into the database without affecting the existing data?
CorrectIncorrect -
-
Question 7 of 20
7. Question
A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?
CorrectIncorrect -
Question 8 of 20
8. Question
A data analyst wants to show and hide information on his sheet based on selected criteria. Which of the following data manipulation techniques is most appropriate in this case?
CorrectIncorrect -
Question 9 of 20
9. Question
Consider the following data set.
Which of the following data manipulation techniques would arrange the data set in decreasing order of total marks so that who scored highest marks is in the top row, and who scored lowest marks is in the last row?
CorrectIncorrect -
Question 10 of 20
10. Question
Which of the following Date function commands would effectively calculate the number of days, months, or years between two dates?
CorrectIncorrect -
Question 11 of 20
11. Question
Consider the following data sets.
Which of the following Logical functions would return TRUE?
CorrectIncorrect -
Question 12 of 20
12. Question
A SQL database administrator wants to display the total number of employees. Which of the following SQL commands should the administrator use to display the total number?
CorrectIncorrect -
Question 13 of 20
13. Question
A web developer wants to ensure that malicious users can’t type SQL statements when they asked for input, like their username/userid. Which of the following query optimization techniques would effectively prevent SQL Injection attacks?
CorrectIncorrect -
Question 14 of 20
14. Question
Which of the following SQL commands will be used to prevent SQL injection attacks?
CorrectIncorrect -
Question 15 of 20
15. Question
A database administrator is responsible to optimise the data queries from 800ms to 300ms by using indexing.
Which of the following techniques, indexing uses to make columns faster to query?
CorrectIncorrect -
Question 16 of 20
16. Question
A web analyst wants to display a chart of daily hits on the keyword “it certifications” for four different states with the help of Google Trends and Python.
Which of the following data collection methods will effectively request data from google trends and display them in a chart?
CorrectIncorrect -
Question 17 of 20
17. Question
The human resources (HR) department of the ACME Corporation needs to monitor changes in employee satisfaction over time. Which of the following data collection methods will BEST help the HR department to monitor the changes?
CorrectIncorrect -
Question 18 of 20
18. Question
Consider the following dataset which contains information about houses that are for sale.
Which of the following string manipulation commands will replace the “St” characters in the address column with the word “Street”?
CorrectIncorrect -
Question 19 of 20
19. Question
Consider the following dataset which contains information about houses that are for sale.
Which of the following string manipulation commands will combine the address and region name columns to create a full address?
full_address ----------------------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan
CorrectIncorrect -
Question 20 of 20
20. Question
Which of the following data manipulation techniques improves the accuracy and integrity of your data while ensuring that your database is easier to navigate?
CorrectIncorrect