African Ideas/GrabAGrad Developer Real-Time Assessment March 2024 The aim of this assessment is to gauge the applicant’s proficiency in the skills and competencies required for the role of a Developer at African Ideas/GrabAGrad. Instructions: 1. Ensure you have a stable internet connection 2. Read each question carefully. 3. Answer all questions to the best of your ability within the given time frame. 4. Do not use external help. 5. Use the Office 365 Suite where required. SECTION 1: MULTIPLE CHOICE QUESTIONS (8 Marks) 1. Which language would you typically use for data manipulation and querying databases? (1 mark) *JavaScriptPHPSQL CSS 2. Which of the following is a feature of ASP.NET Core not found in previous versions of ASP.NET? (1 mark) *Web FormsMVC ArchitectureRazor PagesGlobal.asax file 3. In GIT, which command creates a new branch? (1 mark)*git branchgit checkoutgit mergegit init 4. For which of the following would you use the framework ASP.Net? (1 mark)*Designing a website layoutCreating animations on a webpageBuilding a web application using C#Data Visualisation 5. Consider the following JavaScript function. What will be the output when sum(2)(3) is executed? (1 mark)*5UndefinedNaNError 6. In SQL, which statement is used to extract data from a database? (1 mark)EXTRACTGETSELECTPULL 7. In SQL, which of the following commands will select all columns from a table named users where the user’s age is greater than 25? (1 mark) SELECT * FROM users WHERE age u003e 25SELECT * FROM users WHERE age = 25GET * FROM users WHERE age u003e 25FETCH ALL FROM users IF age u003e 25 8. Which of the following is NOT a commonly used front-end framework/library for web development? (1 mark) ReactAngularDjangoVue.js SECTION 2: SHORT ANSWER QUESTIONS (17 Marks) 1. SQL: Write an SQL statement to retrieve all user records from the table ‘Users’ where the user’s email ends with u0022@grabagrad.com (4 marks) * 2. JavaScript: Write a JavaScript function that takes in an array of numbers and returns the sum of all numbers. (4 marks) * 3. ASP.NET Core API:u003c/strongu003e Write an ASP.NET Core API method to retrieve user details by ID. The method should handle any potential errors gracefully. (4 marks) * 4. React Frontend: Create a simple React component that displays a list of users fetched from an API endpoint. (5 marks) SECTION 3: LONG ANSWERS (10 Marks) 1. Azure, CI/CD, Docker: Describe a CI/CD pipeline that you would set up for a web application using Azure DevOps and Docker. (5 marks) 2. WordPress: You are tasked with creating a custom WordPress shortcode that displays a personalized greeting message to the site’s visitors. The greeting should display a default message, “Welcome to our website!”, but also allow the shortcode to accept a name attribute to personalize the message further. If a name is provided, the greeting should change to “Welcome to our website, [Name]!” where [Name] is the value of the name attribute passed to the shortcode.Requirements:a. Implement a function in WordPress to define the custom shortcode.b. The shortcode should be named [greeting_message].c. The shortcode should accept an optional name attribute.d. The greeting message should be customizable based on the attribute’s presence.e. Add a brief comment in your code explaining the functionality of the shortcode. (5 marks) Full Name* Email Address* Acknowledgement: By submitting this assessment, you consent to the collection, processing, and storage of your personal information for the purpose(s) of this application Submit