Search test library by skills or roles
⌘ K

About the test:

The Hyperion Financial Management Test uses scenario-based MCQs to evaluate candidates on their proficiency in using the Oracle Hyperion Financial Management tool for financial consolidation and reporting. The test assesses candidates' ability to design and configure financial management applications, create and manage financial reports, and perform data analysis and modeling.

Covered skills:

  • Hyperion Financial Management
  • Budgeting and forecasting
  • Data integration
  • Business rules
  • Security and user management
  • Intercompany transactions
  • Financial reporting
  • Consolidation
  • Data management
  • Currency translation
  • Financial consolidation
  • Data analysis

9 reasons why
9 reasons why

Adaface Hyperion Financial Management Assessment Test is the most accurate way to shortlist Hyperion Developers



Reason #1

Tests for on-the-job skills

The Hyperion Financial Management Test helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

  • Ability to manage financial data and create financial reports in Hyperion Financial Management
  • Knowledge of budgeting and forecasting processes in Hyperion Financial Management
  • Experience in financial consolidation and intercompany transactions in Hyperion Financial Management
  • Understanding of data integration and data management in Hyperion Financial Management
  • Familiarity with business rules and currency translation in Hyperion Financial Management
  • Capability to handle security and user management in Hyperion Financial Management
  • Competence in performing financial analysis using Hyperion Financial Management
  • Proficiency in Oracle Hyperion Financial Management tool
  • Ability to handle and solve complex financial scenarios in Hyperion Financial Management
  • Knowledge of financial consolidation and reporting standards
  • Understanding of data governance and compliance in Hyperion Financial Management
  • Expertise in multi-currency environments in Hyperion Financial Management
  • Capability to configure and maintain advanced calculations in Hyperion Financial Management
  • Experience in data mapping and data transformation in Hyperion Financial Management
  • Understanding of financial close processes in Hyperion Financial Management
Reason #2

No trick questions

no trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

View sample questions

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface
Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

These are just a small sample from our library of 10,000+ questions. The actual questions on this Hyperion Financial Management Test will be non-googleable.

🧐 Question

Easy

100m Race
Solve
In a 100m race between A, B, C and D, B finished after A. C finished ahead of B, D finished in the last-but-one position, and C did not win the race. Who came in second?

Medium

51% Attacks
Solve
A 51% attack is perhaps the most discussed threat to any public Blockchain asset. A 51% attack happens when a certain miner or mining pool, that owns more than 50% of all the network’s hashing power, acts maliciously to disturb the network’s operation.
For example: Two Bitcoin Cash mining pools, carried out a 51% attack on the Bitcoin Cash blockchain in order to stop an unknown miner from taking coins that they weren’t supposed to have access to, while the network forked.
Which of the following CAN be done by a miner employing a 51% attack?

A: Double spend their coins
B: Reverse confirmed transactions
C: Steal funds from a certain address
D: Prevent transactions from being confirmed
E: Create false transactions that never happened

Medium

Binary Search
Solve
Here's a sample ABAP code written to accept a list of numbers, a search input and to perform binary search on it. Analyze the code thoroughly and pick the correct statements:
 image
A: If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 47,  the program prints "Success"
B:  If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 47,  the program prints "Error"
C:  If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 47,  the program goes into endless loop
D: If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 27,  the program prints "Success"
E:  If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 27,  the program prints "Error"
F:  If the array (internal table) supplied is 0 4 7 10 14 23 45 47 53 and the search input is 27,  the program goes into endless loop

Easy

OOPs print
Solve
Check the following ABAP code. What would it print?
 image
// I
A
B

// II
B
A

// III
A
A

// IV
B
B

// V
A

// VI
B

// VII
No output

Easy

Overseas office
Inferential Reasoning
Reading Comprehension
Solve
Your company recently opened a second office overseas. Some of the people from the original office will be relocating. All the people hired in the last six months will continue working in the original location where they were hired. Which of the following statements can be true regarding employees relocating?

Medium

Access content
Routes
Controllers
Solve
Review the following Drupal code:
 image
 image
Pick the correct statements:

A: When /sample is accessed, access is allowed without checking for permissions and SampleController::content method is invoked
B: When /sample is accessed, ‘access content’ permission is checked on the accessing user and, if access is granted, SampleController::content method is invoked
C: When /sample is accessed, the page outputs ‘A’ on the page with title ‘B’
D: When /sample is accessed, the page outputs ‘B’ on the page with title ‘A’
E: When /sample is accessed, the page outputs ‘A’ on the page with no title
F: When /sample is accessed, the page outputs nothing on the page with title ‘B’

Medium

Account Determination
Procurement Process
Valuation
Solve
In an SAP MM implementation for a manufacturing company, you are tasked with setting up the procurement process for raw materials, ensuring accurate valuation and account determination for financial reporting. The company uses a standard costing method for inventory valuation and has a complex organizational structure with multiple plants and company codes. During the procurement process, a purchase order is created for raw material X, which is categorized under material type ROH (Raw Material) and has a material master record with a standard price of $100. The purchase order quantity is 50 units at a price of $110 per unit due to market fluctuations. Upon goods receipt, the system should post the inventory and update the financial accounts accurately according to the company's accounting principles.

Given the scenario, how should the system handle the valuation and account determination at the time of goods receipt, assuming the configuration settings are appropriately set for the material and financial accounting integration?
A: The system valuates the inventory at the purchase order price, posts the difference to a price difference account, and the stock account is credited with the standard price.
B: The system valuates the inventory at the standard price, posts the difference to a price difference account, and the stock account is credited with the purchase order price.
C: The system valuates the inventory at the standard price, and the stock account is credited with the standard price. No price difference account is involved.
D: The system valuates the inventory at the purchase order price, and the stock account is credited with the purchase order price. No price difference account is involved.
E: The system valuates the inventory at the purchase order price, posts the difference to a variance account, and the stock account is credited with the standard price.
F: The system valuates the inventory at the standard price, posts the difference to a price difference account if the purchase order price is higher than the standard price, and the stock account is credited with the purchase order price.

Medium

Active Directory Replication Issues
Active Directory Replication
Event Log Analysis
Network Troubleshooting
Solve
You are an experienced Windows Server administrator tasked with resolving a complex Active Directory replication issue across multiple sites. Users have reported authentication problems and inconsistent Group Policy applications. Upon examining the Event Logs from various Domain Controllers (DCs), you gather the following key log entries:
 image
Considering this information, what is the most appropriate first step in diagnosing and resolving this Active Directory replication issue?
A: Reinitialize the replication on DC01 to ensure it has the most current data.
B: Review and configure site link costs and schedules in Active Directory Sites and Services.
C: Perform a comprehensive network connectivity test between all sites.
D: Examine the DNS settings and records on each Domain Controller for inconsistencies.
E: Force a manual replication between DC01, DC02, and DC03 using repadmin.
F: Check firewall settings across sites for any rules that may block AD replication traffic.

Easy

Ad Comparison for Quality Score and Extensions
Ad Quality Score
Ad Extensions
Solve
Refer to the images of the three different ads (Ad A, Ad B, and Ad C) provided. Each ad varies in terms of Quality Score, bid amount, and the use of ad extensions.

- Ad A has a Quality Score of 6, bid amount of $3, and uses no ad extensions.
- Ad B has a Quality Score of 7, bid amount of $2, and uses a sitelink extension.
- Ad C has a Quality Score of 8, bid amount of $4, and uses both sitelink and callout extensions.

Considering the information and the appearance of each ad, which ad is likely to have the highest Ad Rank and the most significant enhancement in Click-Through Rate (CTR) due to the use of ad extensions?
 image

Medium

Ad Copy and Extension Optimization
Ad Copywriting
Conversion Rate
Ad Testing
Solve
Imagine overseeing a campaign for a newly launched online store specializing in sustainable products. The following are two different ad previews with their associated statistics:

Ad 1:
 image
Statistics for Ad 1:

- CTR = 2.8%
- Conversion Rate = 5.5%
- Average CPC = $1.8
Ad 2:
 image
Statistics for Ad 2:

- CTR = 3.2%
- Conversion Rate = 4.5%
- Average CPC = $2
After A/B testing, you notice that removing “Free Shipping on Orders Over $50” from Ad 2 decreased the CTR by 0.5% but increased the Conversion Rate by 1.5%. Removing “Shop Now and Make a Difference!” from Ad 1 had no significant effect on the CTR but increased the Conversion Rate by 0.8%.

Given this, what specific aspect should be focused on for optimization to potentially enhance both CTR and conversion rate?
A: Reinstate “Free Shipping on Orders Over $50” in Ad 2
B: Remove “Shop Now and Make a Difference!” from Ad 1
C: Add a price incentive to Ad 1
D: Add product categories to Ad 2
E: Add a limited-time discount offer to both ads

Medium

Adapting Communication Styles
Communication
Adaptability
Solve
As a customer service representative, it's crucial to adapt the communication style based on the customer's persona. Analyze the data points provided from the analytical dashboard for three customers and match the appropriate communication style for each customer persona:
Customer A:

Age: 42
Profession (from LinkedIn): Financial Analyst
Browsing data: Frequently visits the website during office hours, spends an average of 45 seconds on each page, and often uses the search function to find specific information.
Previous support requests: Sent an email inquiring about product pricing and requested a quick response; started the message with "Dear Support Team."
Customer B:

Age: 67
Profession (from LinkedIn): Retired School Teacher
Browsing data: Spends a considerable amount of time on the website during evenings and weekends, primarily visiting the "Help" and "FAQ" sections. Searches for information on basic product usage and troubleshooting.
Previous support requests: Submitted a query through the website's contact form asking for help with setting up their new device; started the message with "Hello, I hope you're well. I need some assistance with my new device."
Customer C:

Age: 29
Profession (from LinkedIn): Graphic Designer
Browsing data: Visits the website late at night, frequently engages with interactive content, and shares company blog posts on social media. Searches for information on design tools and creative processes.
Previous support requests: Sent a direct message on the company's social media page asking for a software recommendation; started the message with "Hey there! 😊 I'm looking for some advice on a design tool."

Easy

Advanced PLG Strategy and Customer Success
Product Led Growth
Solve
You are a product manager at a B2B SaaS company that has recently transitioned to a product-led growth (PLG) strategy. The company has always had a strong focus on customer success and wants to ensure this continues under the new strategy. You have been asked to recommend a strategy that aligns customer success with the PLG approach. 

You have the following data:

1. The company's product has a free trial version with limited features.
2. The conversion rate from free trial to paid customers is 15%.
3. The churn rate for paid customers is 5%.
4. The average customer support ticket resolution time is 48 hours.
5. The Net Promoter Score (NPS) is 30.

Which of the following strategies would best align customer success with the PLG approach?
A: Increase the number of features in the free trial version to attract more users.
B: Decrease the price of the paid version to increase the conversion rate.
C: Improve the product's user experience and provide self-service resources to empower users.
D: Increase the customer support team size to reduce ticket resolution time and improve customer satisfaction.
E: Launch a referral program to improve the NPS and attract more users through word-of-mouth.

Medium

Aggregate Deviation
Solve
Su is the project manager for a Bengaluru based video storage company. The allowable deviation for video compression time is ±150 milliseconds. They use a third party service which offers an API for video compression. The third party service delivers documentation with the latest version of the API which states that the requirements are being met as per specification. Su’s team conducts multiple quality tests on the API. The aggregate deviation found by her team is 155 milliseconds, but the team says this variation from the permissible deviation is negligible. What should Su do?
A: Allow the API since the third party vendor provided the product on time
B: Allow the API for now, but ask the third party vendor for an explanation
C: Document the low level of quality, allow the API to be used and work with the third party vendor to find a solution
D: Reject the API and ask the third party vendor to provide the product within the allowable deviation
E: Use the API for now, and start developing their own video compression API to use in the future
F: Halt the project and start developing their own video compression API

Medium

Airline Operators
Solve
Four airline operators A, B, C and D operate on a popular route between 2 cities, Rome and Venice in Italy. Airline A wanted to increase the number of seats sold, so they reduced their fares for this route. Airlines B, C, D imitated this move immediately. The general belief is that the volume of air travel between Rome and Venice would increase as a result of this. Which of the following statements, if true, would add trust to the general belief?
A: All 4 airlines see increased profits.
B: Airlines start slashing rates for other routes as well.
C: A study shows that around 80% of air travel in Italy is company sponsored.
D: A study shows that air travellers in Italy are price sensitive.

Medium

AJAX Request Completion Handling
Handling AJAX Requests
Solve
Suppose you are testing a web application with Selenium, where a button click (id="sendRequest") sends an AJAX request to fetch user data. The data, once retrieved, is displayed in a div with id="userData". This div is already present in the HTML with empty text. You need to ensure that the AJAX request is completed and the data is loaded before proceeding. (You can assume that the AJAX request will always succeed.

Consider the following pseudo JavaScript code which is used in the web application:
 image
Given the above code, which of the following Python Selenium code snippets should be used to correctly wait for the AJAX request to complete and the userData to be loaded?
 image

Medium

Algorithm and Testcase
Unreachable Code
Designing Testcases
Solve
Review the following algorithm to calculate the final bill in a store:
Algorithm: 

1. Each purchase has three amounts - base, special and extra
2. On the base amount - If there is a discount offer going on in the store, the discount is applied 
3. There are no discounts on the special amount
4. On the extra amount - customer is offered 19% discount if accrued credits are equal to or more than 25 or 10% if the accrued credits are equal to or more than 13. If the accrued credits are lesser than 13, no discount on the extra amount is offered. In case there is a discount offer going on in the store, the discount on extra amount calculated based on credits cannot be lesser than the discount offer.
Here is the code written by the developers for this algorithm:
 image
Here is the code the developers wrote to test the program when a customer has 13 credits and store offer is 0:
 image
Pick the correct statements:

A: The code works correctly as expected without any defect
B: The program has unreachable code and generates faulty output when credits are ≥ 25
C: The testcase is written correctly and tests the test case as expected
D: The testcase need to be modified to account for imprecise rounding of floating numbers. Ex: (price == 12900.00) can be replaced with ((price - 12900.00) < 0.01)
E: The testcase need to be modified to account for imprecise rounding of floating numbers. Ex: (price == 12900.00) can be replaced with (abs(price - 12900.00) < 0.01)

Medium

Alias
OOPs
Solve
What does the following TypeScript code print?
 image
 image

Medium

Aligning Content with Customer Journey
Buyer’s Journey
Content Personalization
Solve
An online bookstore specializing in self-help and personal development books is planning its content strategy to nurture leads and guide them through the customer journey. They have segmented their audience into three main stages: Awareness, Consideration, and Decision. Based on the needs and behaviors of potential customers at each stage, which type of content should the bookstore prioritize for people in the Consideration stage?
A: Blog posts introducing the concept of personal development
B: Video interviews with authors discussing their books and insights
C: Social media posts highlighting daily tips for self-improvement
D: Detailed book reviews and comparisons
E: Email newsletters featuring new releases and bestsellers

Medium

Analyzing Hive Join
Optimization
Solve
Consider the following two Hive tables in a space adventure context:
 image
Assume that the astronauts table is small and can fit in memory. Which of the following queries will take full advantage of a map-side join?
 image

Medium

Analyzing StreamBuilder
StreamBuilder
ListView
Solve
Consider the below code:
 image
Analyze the given pseudocode and determine what will be displayed on the screen after the second emission of Stream (after 2 seconds).
A: CircularProgressIndicator will be displayed.
B: A ListView with 3 ListTile widgets, each displaying one item from the list ['Item1', 'Item2', 'Item3'].
C: Text widget with 'No Items Available' will be displayed.
D: A ListView with 0 ListTile widgets.
E: The code will throw an error.

Medium

Analyzing Website Traffic Data
Data Analysis
Solve
You are analyzing website traffic data for your e-commerce platform from the last quarter using Google Analytics. The table below summarizes the traffic sources and their respective metrics:
 image
Based on the data above, you are tasked with calculating the E-commerce Conversion Rate (ECR) for each traffic source and identifying which traffic source has the highest Revenue per Session (RPS). E-commerce Conversion Rate is calculated as (Transactions / Sessions) * 100, and Revenue per Session is calculated as Revenue / Sessions.

Which traffic source has the highest Revenue per Session, and what is the E-commerce Conversion Rate for that source?

Medium

AppDomain Resource Scoping
Configuration Management
AppDomain
Resource Scoping
Solve
Consider a scenario where you have a .NET application that needs to load different configurations for different components running in separate AppDomains. You have the following code structure:
 image
The `ConfigManager` class is designed to load and store configurations for different domains. What will be the output of this program, assuming `ConfigA.xml` and `ConfigB.xml` contain distinct settings?
A: Config in DomainA: [Settings from ConfigA.xml], Config in DomainB: [Settings from ConfigB.xml]
B: Config in DomainA: null, Config in DomainB: null
C: Config in DomainA: [Settings from ConfigB.xml], Config in DomainB: [Settings from ConfigA.xml]
D: A runtime exception is thrown due to cross-domain operation.
E: Config in DomainA: [Settings from ConfigA.xml], Config in DomainB: [Settings from ConfigA.xml]
F: The output is unpredictable and depends on the runtime environment.

Medium

Application Context and Request Dispatching
Application Context
Request Lifecycle
Thread-Safety
Solve
Consider a complex Flask application that uses an application factory pattern for scalability and flexibility. The application also utilizes global variables to manage configurations across different parts of the app. Review the following pseudo-code, which illustrates a portion of this application where an issue with application context might arise when deploying:
 image
In this scenario, where the application is configured to run with multiple threads, what is the potential issue that could arise when processing multiple requests concurrently?
A: The db_connection in g might be shared across requests leading to data integrity issues.
B: The USE_CACHE configuration might reset to its default value in between requests.
C: Multiple threads might cause the application to crash due to improper locking mechanisms.
D: There will be no issues as Flask naturally handles application contexts per request in a thread-safe manner.
E: The configuration change in current_app.config['USE_CACHE'] will not be visible to the request handlers.

Medium

Applying Functions
Data frames
Functions
Math
Solve
Consider the following R code:
 image
This script defines a function apply_fun that calculates the mean of a vector and adds it to the standard deviation of the vector. The apply function is then used to apply this function to each column of the data frame df. What will be the value of result after the script is run?

Medium

Applying Middleware to Resource Routes
Middleware
Routing
Solve
You are developing a Laravel application that has a PostController for managing blog posts. The routes for this controller are set up as a resource route in your web.php file:
 image
You have already created a middleware called EnsureAdminRole to restrict access to certain routes for admin users. Now, you want to apply this middleware to the create, edit, update, and delete routes for the PostController, but not the index or show routes.

Which of the following ways would correctly apply the EnsureAdminRole middleware to these routes?
 image

Medium

Appropriate Apology
Customer Complaints
Communication
Solve
As a customer support agent for a high-end telescope manufacturing company, you receive an email from Dr. Patel regarding a telescope she purchased last month for her university's astronomy department. She mentions that during a critical observation session for their research, one of the research team members deleted the historical data by mistake because the UX was confusing. She shares this feedback with you over email.

What is an appropriate apology?
A. "We are deeply sorry that the historical data got deleted due to confusing UX during such a crucial experiment! It must be extremely frustrating for a team of dedicated researchers."

B. "Our apologies! We truly feel terrible that your team's experiment was disrupted. As a fellow academic, it's disheartening to see your colleagues face such setbacks."

C. "We are sincerely sorry for the inconvenience caused by the telescope's confusing UX. That must have been embarrassing for you."

D. "Apologies! We feel awful that your team wasn't able to use the telescope correctly for their experiments. It's fortunate, though, that they have a supportive department head to help them through this."

Medium

Approval Chain with Dynamic Routing
Approvals
Conditions
Flow Design
Solve
You're tasked with building a Power Automate flow for a purchase order approval system. Here are the requirements:

1. Initiation: The flow starts when a purchase order is submitted via a SharePoint list.
2. Initial Approval: The purchase order should first be routed to the submitter's direct manager (information available in SharePoint).
3. Conditional High-Value Routing:
    - If the purchase order value is over $5000, it requires an additional approval from the department head.
    - If the value is $5000 or less, proceed directly to final processing.
4. Final Processing: Upon all approvals, update the purchase order status in the SharePoint list and send a confirmation email.
Which of the following is the valid approach?
OPTION A:
    - Initialize two string variables: 'Manager Approval' and 'Department Head Approval'.
    - 'Get manager (V2)' to store the submitter's manager email in 'Manager Approval'.
    - 'Start and wait for an approval' (Approval type: Approve/Reject - First to respond) using 'Manager Approval'.
    - 'Condition': Purchase order value is greater than 5000.
        - If yes: Set 'Department Head Approval' with department head's email and start another approval.
        - If no: Proceed to final processing steps.

OPTION B:
    - 'Get manager (V2)' to retrieve the submitter's manager email.
    - 'Start and wait for an approval' (Approval type: Approve/Reject - First to respond) using the manager's email.
    - 'Condition': Purchase order value is greater than or equal to 5000.
        - If yes: Proceed to final processing steps.
        - If no: 'Get manager (V2)' to retrieve department head's email, followed by another 'Start and wait for an approval'.
OPTION C:
    - 'Start and wait for an approval' (Approval type: Approve/Reject - Everyone must approve)
    - Add both the submitter's manager and the department head as approvers.
    - 'Condition': Purchase order value is greater than 5000.
        - If yes: Proceed to final processing steps.
        - If no: Set status to 'Rejected' in the SharePoint list.

OPTION D:
    - 'Get manager (V2)' to retrieve the submitter's manager email.
    - 'Start and wait for an approval' (Approval type: Approve/Reject - First to respond) using the manager's email.
    - Create a parallel branch.
        - Branch 1: 'Start and wait for an approval' with department head's email (retrieved from SharePoint).
        - Branch 2: 'Condition' to check if the purchase order value is greater than 5000.

OPTION E:
    - Initialize a 'Department Head Approval' string variable.
    - 'Start and wait for an approval' (Approval type: Approve/Reject - First to respond).
    - 'Condition': Purchase order value is greater than 5000.
        - If yes: Assign 'Department Head Approval' variable with department head's email (retrieved from SharePoint).
        - If no: Proceed to final processing steps.
    - 'Start and wait for an approval' (Approval type: Approve/Reject - First to respond) using the 'Department Head Approval' variable.

Medium

Array Manipulation and Summation
Array Manipulation
Mathematical Operations
Solve
Consider the following code snippet:
 image
What will be the value of G after executing the code?

Hard

Reactivity - Arrays and Objects
Array
Solve
Here are different ways to make changes to arrays and objects in Vue.
 image
Which of the following statements are true?

I) A retains reactivity of items array
II) B retains reactivity of items array
III) C retains reactivity of user object
IV) D retains reactivity of user object

Hard

Cache
Cache
Solve
In ASP.NET, which of the following is the correct way to use the Cache object?
 image

Medium

ViewState
Solve
In ASP.NET which of the following is the correct way to work with ViewState?
 image

Easy

Assemble Triangle
Visual assembly
Geometric Reasoning
Solve
Which of the following set of shapes can be assembled to create the shape displayed:
 image

Medium

Async Await Promises
Promises
Async-Await
Solve
What will the following code output?
 image
A: 24 after 5 seconds and after another 5 seconds, another 24
B: 24 followed by another 24 immediately
C: 24 immediately and another 24 after 5 seconds
D: After 5 seconds, 24 and 24
E: Undefined
F: NaN
G: None of these

Medium

Async Await
Asynchronous Programming
Solve
Review the following Dart code:
 image
The code reads data from a file synchronously. The code blocks while waiting for file I/O. Which of the following is the proper asynchronous version of the same code? 

- Assume readAsString is asynchronous version of readAsStringSync
- Lines with changes compared to original code are marked with // #
 image

Medium

Asynchronous Processing
Asynchronous Execution
Performance Optimization
Workflow Design
Solve
An RPA developer must design a workflow that initiates several web data extraction tasks simultaneously. Each task may take a variable amount of time to complete. The workflow should be optimized for performance, ensuring that the overall execution time is minimized by running these tasks in parallel. Once all tasks are completed, the workflow should compile the results into a single report. Which method should be used to achieve efficient asynchronous processing in this scenario?
A: Implement multiple parallel process activities, synchronizing them at the end with a join activity before report compilation.
B: Sequentially execute each web data extraction task and compile the report immediately after each task completes.
C: Use a multi-threaded approach by invoking external scripts that run in parallel and communicate back to the RPA process.
D: Create a dispatcher-performer model where the dispatcher queues tasks and the performer executes them as they are queued.
E: Schedule individual bots for each task to run at the same time and use a file-based system to compile results post execution.

Medium

Audit Information
Periodic Processing
Audit Controls
Document Posting
Solve
In SAP FICO, a company has implemented strict controls over financial period closures and audit trails. The company's fiscal year ends on December 31st. On January 5th, an attempt is made to post a vendor invoice dated December 29th of the previous year. The system settings are configured to allow postings only to the current and the immediately preceding month. What will happen and how should the financial data be managed in this scenario?
A: The system allows the posting; the invoice is recorded in December of the previous year.
B: The system rejects the posting; the invoice must be recorded in January of the current year.
C: The system allows the posting with a special period indicator, and the invoice is recorded in December of the previous year.
D: The system allows the posting with an error message, but the transaction is flagged for audit review.
E: The system allows the posting; the invoice is recorded in January of the current year with a backdate to December.

Medium

Automatic Purchase Order Creation
Purchase Requisition
Source Determination
Automatic Purchase Order
Solve
In SAP MM, an automatic purchase order can be created directly from a purchase requisition based on predefined conditions. Which of the following settings must be configured to enable this functionality?
 image

Medium

Autowiring Service
Solve
Review the following two Spring components- SampleA and SampleB:
 image
 image
Notice @Autowired line added to SampleService in SampleB (rest of the code is same for both components). What happens when the components are run as a @SpringBootApplication?
A: SampleA prints true null
B: SampleA prints true class package.SampleService
C: SampleA throws a null pointer exception
D: SampleA prints false null

E: SampleB prints true null
F: SampleB prints true class package.SampleService
G: SampleB throws a null pointer exception
H: SampleB prints false null

Easy

Background Properties
Solve
Consider the following shorthand CSS example:

background: #f7f7f7 url(jolie.jpg) no-repeat scroll 0px 0px;

Which of the following show the individual background properties represented by the shorthand:
 image

Medium

Backup and Restore Strategy
Databases
Backup
Recovery
Solve
You are a database administrator for an organization that uses Azure SQL Database for its operations. The organization has a strict data retention policy and has set up the following backup strategy:

1. Full backups are taken every Sunday at midnight.
2. Differential backups are taken every day at midnight, excluding Sunday.
3. Transaction log backups are taken every hour on the hour.

On Wednesday at 2:30 PM, a failure occurred, and the latest backup files available are: full backup from the previous Sunday, differential backups for Monday and Tuesday, and transaction log backups up to Wednesday 2 PM.

In order to restore the database to the most recent point in time with the minimum amount of data loss, in what order should you restore the backups?
A: Restore the full backup, then the differential backup for Tuesday, then the differential backup for Wednesday, then each transaction log backup from midnight on Wednesday to 2 PM on Wednesday.

B: Restore the full backup, then the differential backup for Wednesday, then each transaction log backup from midnight on Wednesday to 2 PM on Wednesday.

C: Restore the full backup, then each differential backup from Monday and Tuesday, then each transaction log backup from midnight on Wednesday to 2 PM on Wednesday.

D: Restore the full backup, then the differential backup for Monday, then each transaction log backup from midnight on Monday to 2 PM on Wednesday.

E: Restore the full backup, then the differential backup for Tuesday, then each transaction log backup from midnight on Tuesday to 2 PM on Wednesday.

Medium

Backup Strategy
Backups
Troubleshooting
Solve
As a DBA, you receive an alert notifying you that the production database has gone offline due to a severe issue. Fortunately, you have a proper backup strategy in place. The backups are performed as follows:

1. Full database backup every Sunday at 2:00 AM.
2. Differential backup every day at 2:00 AM, except Sunday.
3. Transaction log backup every hour.
Today is Wednesday, and the failure occurred at 10:15 AM. You have the following backup files available:

1. Full backup: Full_Backup_Sun.bak taken on Sunday 2:00 AM.
2. Differential backups: Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak taken at 2:00 AM on their respective days.
3. Transaction log backups: Hourly backups from Sunday 3:00 AM until Wednesday 10:00 AM, like TLog_Backup_Wed_09.bak, TLog_Backup_Wed_10.bak.
Given the RPO (Recovery Point Objective) of 15 minutes, which of the following sequences of restore operations would ensure minimal data loss?
A: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then all Transaction Log backups from Wednesday.

B: Full_Backup_Sun.bak, Diff_Backup_Tue.bak, then all Transaction Log backups from Tuesday and Wednesday.

C: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.

D: Full_Backup_Sun.bak, then all Transaction Log backups from Sunday to Wednesday 10:00 AM.

E: Full_Backup_Sun.bak, Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.

Medium

Tennis Players
Solve
A tennis coach was trying to put together a team of 4 players for a tennis championship out of 7 players. R, S, T are the male players, and W, X, Y, Z are the female players. Note that all players have equal ability, and the team needs to have atleast 2 male players. While selecting the team we need to keep in mind that all 4 players should be able to play with each other. 
 image
We also need to keep the following restrictions in mind:
- R cannot play with Y
- S cannot play with W
- T cannot play with Z
Which of the following are true:

A: S and Z cannot be in the team together.
B: T and Y cannot be in the team together.
C: T and X cannot be in the team together.

Easy

Balancing Autonomy and Team Synergy
Employee Development
Team Integration
Solve
In a fast-paced tech environment at Crafters, you are faced with the challenge of integrating individual contributors like Jamie, who are technically stellar but less inclined towards team activities. Their solitary contributions have been pivotal, yet their aloofness is creating friction within the team, which could impede collective progress. As the HR manager, your goal is to harness Jamie's potential while nurturing a collaborative team spirit. What strategy would you employ to ensure both the individual’s growth and the team's success?
A: Create a peer recognition program that incentivizes both individual achievements and collaborative successes.

B: Implement a rotating team leadership model where Jamie takes on leadership roles in phases, promoting engagement.

C: Initiate a 'shadow and learn' program, pairing Jamie with team members on a project basis to encourage mutual understanding.

D: Designate Jamie as a subject matter expert, offering consultation to the team while continuing their solo projects.

E: Develop a specialized task force with Jamie that tackles complex problems, requiring occasional cross-team collaboration.

Medium

Bean init and afterPropertiesSet
Beans
Solve
Spring allows specific operations to be performed after the bean is initialized and before the bean is destroyed. Review the following sample Bean that implements init method and overrides afterPropertiesSet. 
 image
Here’s the bean definition added to the configuration file:
 image
What does the code print when the Spring container is started?

Medium

Behavioral Economics
Behavioral Economics
Statistical Analysis
Solve
In a complex study on consumer behavior, Dr. Chen investigates the relationship between psychological factors and spending habits. The study involves a diverse sample of 500 participants, divided into two groups based on their self-reported levels of stress: High-Stress Group (250 participants) and Low-Stress Group (250 participants). The participants were tracked for six months. Key findings include:

- Average monthly spending:
  - High-Stress Group: \$1,200
  - Low-Stress Group: \$800

- Spending categories (as a percentage of total spending):
  - High-Stress Group: 40% on luxury goods, 30% on essentials, 30% on entertainment.
  - Low-Stress Group: 20% on luxury goods, 50% on essentials, 30% on entertainment.

- Psychological assessments showed:
  - 70% of the High-Stress Group experienced impulse buying.
  - 30% of the Low-Stress Group occasionally engaged in impulse buying.

- Income levels:
  - No significant difference in average income between the two groups.

Dr. Chen proposes multiple conclusions about the impact of stress on spending habits. Based on the data, select the conclusion that is most supported by the study's findings.
A: High levels of stress lead to decreased overall spending.
B: Stress levels do not influence spending on essentials.
C: Individuals with high stress spend more on luxury goods and entertainment compared to those with low stress.
D: Low-stress individuals are more likely to engage in impulse buying.
E: The spending habits between the two groups are largely influenced by income levels.
F: High-stress individuals prioritize essentials over other spending categories.

Medium

BGP Path Selection
BGP Configuration
BGP Troubleshooting
Solve
You are a senior network engineer analyzing a BGP configuration issue in a Cisco router. The router is receiving multiple routes to a particular network, 192.168.100.0/24, from different BGP peers. Your task is to ensure that the router always prefers the path through the neighbor 10.10.10.1, irrespective of other path attributes like AS path length, MED, or local preference. Currently, the BGP configuration includes several route maps and prefix lists but doesn't enforce this specific requirement.

Given this scenario, which of the following additions to the BGP configuration would ensure that the route through 10.10.10.1 is always preferred?
A: Apply a route map to neighbor 10.10.10.1 setting a lower MED value for 192.168.100.0/24.
B: Set a higher local preference for routes received from 10.10.10.1 using a route map.
C: Use a prefix list to filter all routes to 192.168.100.0/24 except those from 10.10.10.1.
D: Implement an AS path access list to prepend fake AS numbers to routes from other neighbors.
E: Modify the existing route maps to set a higher weight for routes from 10.10.10.1.
F: Adjust the BGP router ID to a lower value than that of the other BGP peers.

Easy

Biker REST API URIs
Solve
Given a service that returns information about bikes, including the various drivers of each bike, what might the URIs look like for 1) getting the second driver of the third bike? 2) getting all of the drivers of the fifth bike?

Medium

Binary Logic
Binary Logic
Solve
At DreamTeam conference, all participants answer any questions with two sentences, one of which is always true and the other is a lie.

I asked Andrew, Sid and Drew, "What is your favourite startup?" and got the following replies:

Andrew: Our favourite startup is SpeckX. We do not like playing baseball.
Sid: Our favourite startup is Cuber. We love playing baseball.
Drew: Our favourite startup is Drab. We love playing baseball.

1: The favourite startup of the participants of DreamTeam is SpeckX.
2: DreamTeam participants like playing baseball.
3: DreamTeam participants do not like playing baseball.
4: The favourite startup of the participants of DreamTeam is Cuber.
5: The favourite startup of the participants of DreamTeam is Drab.
Which of the following options is/are correct?

Medium

Bitcoin prices
Axios
Promises
Solve
Review the following JavaScript code and pick the correct options: 
 image
Assume that the API returns a successful 200 response code and a JSON object as the response body. What would the value of ‘a’ be after the code is executed?

Medium

Block Inventory
Solve
Harvey Pekar works at Tintin Corp who are implementing inventory management in Dynamics 365 SCM. Tintin Corp needs to block inventory and ensure that physical inventory will not be reserved by other outbound transactions. Harvey need to select the appropriate option to block the inventory in the system. Which of the following solutions should Harvey use?
A: Select the full blocking option in the item sampling page
B: Manually create a transaction on the inventory blocking page
C: Create a quality order on the quality orders page for the quantity to be blocked

Easy

Evidence
Solve
Breed Chasing, solo engineer is planning to create new cryptocurrency, NEWCRAIGLIST and build a blockchain that facilitates buying and selling second-hand items with NEWCRAIGLIST from each other. Breed expects the platform to be used for international transactions and devised the following process:

- Before a transaction is considered complete, the purchaser must put the funds in an escrow service
- The sender must enter the courier tracking number into that same escrow
Palmart, toy store giant in US is asked by lawmakers to provide evidence that proves the store’s toys are not produced through child labour. Palmart’s toys are transferred between 7 parties between creation and placement at the store. Palmart is considering using blockchain to solve this problem. Discretion in the reading and writing of transactions is highly important to the store chain to protect its proprietary interests. Review the following possible solutions and pick the best approach that solves Palmart’s problem:
Option A:
Use a public blockchain that supports assets.
Then create a new toy asset for each item created. 
When the toy is transferred to the next party, mandate that the associated blockchain asset to be transferred to the next party's blockchain account with required metadata.
Lawmakers can now view transactions and transfers at any time.

Option B: 
Use a permissioned blockchain.
Require that every party involved in the process to host a node on the Palmart's network. 
Create a new toy asset for each item created. 
When the toy is transferred to the next party in the process, have the previous party use a web portal to initialize a chain code Smart Contract to transfer control of the asset. 
When the next party receives the asset have them use a web portal to initialize a chain code Smart Contracts to acknowledge receipt of the asset. 
Provide read-only permissions to the lawmakers so they can receive the evidence they are looking for.

Medium

Blockchain Interoperability
Smart Contract Logic
Interoperability
Decentralized Applications
Solve
Consider a blockchain ecosystem where a decentralized application (dApp) is designed to operate across two different blockchains: Blockchain A, which uses a unique smart contract language and execution environment, and Blockchain B, which supports Ethereum Virtual Machine (EVM) compatible smart contracts. The dApp includes a cross-chain functionality where certain actions triggered in Blockchain A's smart contract result in specific operations in a smart contract on Blockchain B. The interoperability is facilitated through a decentralized oracle that verifies and relays information between the two blockchains. Given this setup, which of the following statements most accurately reflects the challenges and considerations in implementing this dApp's cross-chain functionality?
A: Cross-chain functionality cannot be achieved due to the different smart contract languages and execution environments.
B: The decentralized oracle introduces a single point of failure, compromising the security of the dApp.
C: Synchronizing state between the two blockchains is seamless and does not introduce any additional latency.
D: The dApp can maintain consistency and atomicity in transactions across the blockchains, but it faces challenges in data validation and oracle reliability.
E: Smart contract execution on Blockchain B is entirely dependent on the state of the smart contract on Blockchain A.
F: The interoperability poses no significant challenges, as EVM compatibility ensures seamless cross-chain communication.

Easy

Odd One Out
Pattern recognition
Solve
Shown below is a group of 4 objects, which might be rotated in different directions. One of the 4 objects is different from the other 3 in some way. Can you figure out which one?
 image

Medium

Boomi Connector Configuration
Connector Configuration
Data Flow
Web Services
Solve
You are working on a Dell Boomi process that pulls data from a web service API, transforms it, and then pushes it to a database. Your Boomi process has the following steps:

1. HTTP Client connector: Retrieve data from a web service API.
2. Data Process Shape: Transform the retrieved data.
3. Database connector: Push transformed data to a database.

While testing the process, you notice that the data pulled from the web service API isn't being received by the Database connector. The HTTP Client connector and the Data Process Shape appear to be working correctly. 

Which of the following configurations in the Database connector could be causing this issue?
 image

Medium

Boot Autowiring
Spring Boot
Solve
Review the following Spring Boot application code:
 image
Here are two possible SampleConfig class definitions:
 image
When the code is run as @SpringBootApplication, what would happen?

A: Using X as SampleConfig will print- true SimpleDateFormat
B: Using X as SampleConfig will print - true class java.text.SimpleDateFormat
C: Using X as SampleConfig will print a NullPointerException stacktrace
D: Using X as SampleConfig will print a BeanDefinitionParsingException stacktrace

E: Using Y as SampleConfig will print- true SimpleDateFormat
F: Using Y as SampleConfig will print - true class java.text.SimpleDateFormat
G: Using Y as SampleConfig will print a NullPointerException stacktrace
H: Using Y as SampleConfig will print a BeanDefinitionParsingException stacktrace

Medium

Green or red balls
Solve
A bag contains 5 red balls, 6 yellow balls and 3 green balls. If two balls are picked at random, what is the probability that both are red or both are green in colour?

Medium

Broker Replication
System Design
Solve
You are working on a large-scale, distributed, and fault-tolerant message processing system designed to handle high throughput and low latency requirements. The system is based on the publish-subscribe pattern and uses multiple brokers to distribute messages across various topics and partitions. In this architecture, both publishers and subscribers are considered clients. The brokers are responsible for replicating messages among themselves to ensure fault tolerance and data durability.
 image
A client reports successfully publishing a message on a specific topic. However, one of the subscribers has not received the message. To investigate the issue, you have gathered detailed logs and system design data, as shown below:
 image
Based on the information provided, which of the following is the most likely reason for the issue?

A: The message was not published on the topic
B: Client C is not subscribed to the correct topic
C: There is a replication lag between brokers B1 and B2
D: Client C is consuming from the wrong broker
E: The message processing system failed to acknowledge the message

Medium

Bug Risk Analysis
Risk Analysis
Quality Management
Stakeholder Management
Solve
You are the project manager for a software product that is scheduled for launch in two weeks. Your team brings two bugs to your attention.

Bug 1, if unattended, could lead to loss of critical customer data but is hard to replicate. There's an estimated 2% chance it could occur under normal conditions.

Bug 2 affects the usability of a secondary feature and happens frequently. The feature is nice-to-have and does not impact core functionality.

To address these bugs, you have five options:

A) Delay the launch by one week and deploy resources to fix both bugs.

B) Proceed with the launch as scheduled, with a built-in monitoring system to alert if Bug 1 occurs. If it does, immediately release a patch. Bug 2 will be addressed in the next scheduled update.

C) Share the information about both bugs with the stakeholders, highlighting the potential risks and impacts, and ask them for guidance.

D) Ignore Bug 2 and deploy additional resources to fix Bug 1 without delaying the launch.

E) Delay the launch by two weeks to conduct a thorough investigation and ensure that both bugs are resolved.

What is the most suitable course of action according to project management principles?

Medium

Business Meeting
Sentence Structure
Solve
Seleccione la oración con una estructura gramatical correcta:

A: Ayer vamos a ir a una reunión de negocios.
B: El informe del proyecto se presentó por ella en la reunión el mes pasado.
C: Un aumento salarial recibieron los empleados en la semana pasada.
D: La presentación el próximo martes realizará.
E: La prensa fue atendida por el director de comunicación.
F: La estrategia de marketing por el equipo de ventas fue desarrolló.

Medium

Memory Allocation
Solve
Check the following three C functions:
 image
Which among these will likely cause issues with pointers?

Medium

Pointers and Structs
Solve
What is the output of the following C code?
 image

Medium

Strings
Strings
Solve
What is the output of the following C code?
 image

Medium

Comprehensive income
Income statement
Solve
ProCoder Inc. reported the following information on Dec 31st. If we ignore income tax, what should ProCoder report as comprehensive income as of Dec 31?
 image

Medium

Calculated Properties
Data Analysis
Solve
Here’s sample data imported into Tableau:
 image
Assume only three rows of data is present in the source. Once the data is imported, we added to new calculated fields:

Measure 1 with the formula: SUM([Profit])/SUM([Sales])
Measure 2 with the formula: SUM([Profit]/[Sales])

If we dragged Profit, Sales, Measure 1 and Measure 2 in the viewer as shown here:
 image
Pick the correct statements regarding columns Measure 1, Measure 2 and the row Grand total:
A: Values of Measure 1 would be 0.08, 0.075 and 0.1
B: Values of Measure 2 would be 0.08, 0.075 and 0.1
C: Values of Measure 1 would be 0.08, 0.769 and 0.08
D: Values of Measure 2 would be 0.08, 0.769 and 0.08
E: Values of Measure 1 would be 0.08, 0.155 and 0.255
F: Values of Measure 2 would be 0.08, 0.155 and 0.255
G: Grand total of Measure 1 would be 0.08
H: Grand total of Measure 2 would be 0.08
I: Grand total of Measure 1 would be 0.255
J: Grand total of Measure 2 would be 0.255

Medium

Call Gurj Clooners
Solve
 image
Folks should call Gurj Clooners if they want to:

Medium

Capturing Blocks
Liquid Templating
Variable Scoping
Blocks
Solve
You are developing a Shopify theme and using Liquid, Shopify's templating language. In your template, you have written the following pseudo code:
 image
The code should display the collection and product headings for each product and then print the heading of the last product in each collection. However, after running this code, the 'Last product' print statement for each collection shows 'Product: ' but no product title. What is causing this issue?
A: You can't reassign the 'global_var' inside the 'for' loop.
B: The 'capture' block doesn't create a new scope for its content.
C: The 'product_heading' variable is not accessible outside its 'capture' block.
D: The 'collection_heading' variable should be assigned globally.
E: You can't use the 'assign' statement inside a 'for' loop.

Medium

Chaining Event Handlers
Chaining
Events
Solve
Consider the following HTML and jQuery code:
 image
What happens when the "Create Element" button is clicked multiple times?

A: Only the first new element created will have a click event handler.
B: All new elements will have a click event handler that changes their text color to red.
C: Only the last new element created will have a click event handler.
D: No new elements will be created, and no click event handlers will be attached.
E: New elements will be created, but no click event handlers will be attached.

Medium

Change display icon
Solve
What steps would you take to change the following view so that Office Supplies is represented by a different symbol?
 image
A: Click on shapes in the marks area. Then select Office Supplies and the icon of choice and click okay.
B: Right-click on product category, select default properties, and select shape. Then select Office Supplies and the icon of choice and click okay.
C: Right click on the square and select "change shape" from the popup menu. Select the icon of choice and click okay.
D: A, B or C
E: None of these would work

Medium

Changed decision boundary
Solve
We have trained a model on a linearly separable training set to classify the data points into 2 sets (binary classification). Our intern recently labelled some new data points which are all correctly classified by the model. All of the new data points lie far away from the decision boundary. We added these new data points and re-trained our model- our decision boundary changed. Which of these models do you think we could be working with?
The 2 data sources use SQL Server and have a 3-character CompanyCode column. Both data sources contain an ORDER BY clause to sort the data by CompanyCode in ascending order. 

Teylor wants to make sure that the Merge Join transformation works without additional transformations. What would you recommend?
A: Perceptron
B: SVM
C: Logistic regression
D: Guassion discriminant analysis

Easy

Character count
Solve
Penny created a jar file for her character count example written in Java. The jar name is attempt.jar and the main class is com.penny.CharCount.java, which requires an input file name and output directory as input parameters. Which of the following is the correct command to submit a job in Spark with the given constraints?
 image

Medium

China manufacturing
Economic reasoning
Cost analysis
Solve
The cost of manufacturing phones in China is twenty percent lesser than the cost of manufacturing phones in Vietnam. Even after adding shipping fees and import taxes, it is cheaper to import phones from China to Vietnam than to manufacture phones in Vietnam. Which of the following statements is best supported by the given information. 
A: The shipping fee from China to Vietnam is more than 20% of the cost of manufacturing a phone in China.
B: The import taxes on a phone imported from China to Vietnam is less than 20% of the cost of manufacturing the phone in China. 
C: Importing phones in Vietnam will cut 20% of the manufacturing jobs in Vietnam.
D: It takes 20% more time to manufacture a phone in Vietnam than it does in China.
E: Labour costs in Vietnam are 20% higher than in China.

Hard

CID Agent
Logical Deduction
Pattern Recognition
Solve
A code ("EIG AUC REO RAI COG") was sent to the criminal office by a CID agent named Batra.  However, four of the five words are fake, with only one containing the information. They also included a clue in the form of a sentence: "If I tell you any character of the code word, you will be able to tell how many vowels there are in the code word." Are you able to figure out what the code word is?
A: RAI 
B: EIG
C: AUC
D: REO
E: COG
F: None

Medium

Cigarette taxation regime
Solve
Cigarettes account for only 23% of tobacco consumption, and only 16% of 250 million tobacco consumers use cigarettes. However these 16% contribute 85% of the tax revenues to the Exchequer from the tobacco sector. The punitive cigarette taxation regime has kept the tax base narrow, and lowering taxes will expand this base. Which of these best bolsters the conclusion that lowering duties will expand the tax base?
A: The cigarette manufacturers’ association has decided to indulge in aggressive promotion.

B:  Cigarette manufacturers are lobbying for a reduction on duties.

C: There is a likelihood that tobacco consumers will shift to cigarette smoking if cigarette prices reduce.

D: An increase in duties on non-cigarette tobacco may lead to a shift in favor of cigarette smoking.

E: There is a likelihood that tobacco consumers will shift to cigarettes if cigarette prices reduce.

F: A decrease in duties on non-cigarette tobacco may lead to more tobacco consumers shifting to cigarettes. 

G: Cigarette smokers are becoming increasing aware of associated health risks.

H: Increased health warnings could reduce the tax base.

Medium

Claims for a new drug Xylanex
Critical Thinking
Evaluating Arguments
Identifying Assumptions
Solve
A pharmaceutical company claims that their new drug, Xylanex, is highly effective in treating a specific medical condition. They provide statistical data from a clinical trial to support their claim. However, a group of scientists has raised concerns about the validity of the study design and potential bias in the data collection process. They argue that the results may be inflated and not truly representative of the drug's effectiveness.

Which of the following assumptions is necessary to support the pharmaceutical company's claim?
A: The clinical trial participants were randomly selected and representative of the target population.
B: The scientists raising concerns have a conflict of interest and are biased against the pharmaceutical company.
C: The statistical analysis of the clinical trial data was conducted by independent experts.
D: The medical condition being treated by Xylanex is widespread and affects a large number of individuals.
E: The pharmaceutical company has a proven track record of developing effective drugs for similar medical conditions.

Hard

Classes and Constructors
OOPs
Solve
What is the output of the following C# code?
 image

Medium

ClassicRead's Digital Outreach
Digital Marketing
Content Monetization
Value Proposition
Solve
Despite recently modernizing their website for e-commerce, ClassicRead Publishers, esteemed for their classic literature, struggle to resonate with the younger audience. The following insights have been noted:

1. Customer Segmentation Data: While 60% of their audience is aged 40 and above, there's an untapped 30% aged 20-35, consuming content mainly digitally.
2. Market Analysis: E-books and audiobooks, especially via subscription models like Audible, are on the rise.
3. Brand USP: ClassicRead’s editions shine with scholarly annotations, an edge not offered by generic free versions or mainstream platforms like Audible.
4. Digital Presence: Their modern website, though enriched, isn't pulling in the younger crowd. Their social media traction is also modest.
5. ROI Concerns: Further digital endeavors must promise solid ROI, considering the fierce digital content competition.

Desiring to magnetize younger readers and maximize their annotation USP, which strategy should ClassicRead champion next?
A: Introduce a referral program on their website for annotated e-books, incentivizing youth to share and purchase.
B: Join forces with leading e-book platforms, but make annotated versions solely available through a ClassicRead app, which is actively promoted on platforms popular among the youth.
C: Design a ClassicRead app that offers e-books and audiobooks with a feature highlighting and sharing favorite annotations, backed by partnerships with popular online book clubs.
D: Organize periodic online webinars with literature enthusiasts analyzing book annotations, with exclusive e-book offers for attendees.
E: Develop virtual reality experiences of classic literature settings, where annotations are discussed in an immersive environment.
F: Collaborate with schools and universities to integrate ClassicRead's annotated e-books into the curriculum, thereby targeting the youth directly.

Medium

CNN Architecture Tuning
Convolutional Neural Networks
Hyperparameter Optimization
Solve
You are fine-tuning a Convolutional Neural Network (CNN) for image classification. The network architecture is as follows:
 image
The model is trained using the following parameters:

- Batch size: 64
- Learning rate: 0.001
- Optimizer: Adam
- Loss function: Categorical cross-entropy

After several training epochs, you observe that the training accuracy is high, but the validation accuracy plateaus and is significantly lower. This suggests possible overfitting. Which of the following adjustments would most effectively mitigate this issue without overly compromising the model's performance?
A: Increase the batch size to 128
B: Add dropout layers with a dropout rate of 0.5 after each MaxPooling2D layer
C: Replace Adam optimizer with SGD (Stochastic Gradient Descent)
D: Decrease the number of filters in each Conv2D layer by half
E: Increase the learning rate to 0.01
F: Reduce the size of the Dense layer to 64 units

Medium

CNN for Imbalanced Image Dataset
Convolutional Neural Networks
Imbalanced Datasets
Solve
You are fine-tuning a Convolutional Neural Network (CNN) for an image classification task where the dataset is highly imbalanced. The majority class comprises 70% of the data. The initial model setup and subsequent experiments yield the following observations:

**Initial Setup:**

- CNN architecture: 6 convolutional layers with increasing filter sizes, followed by 2 fully connected layers.
- Activation function: ReLU
- No class-weighting or data augmentation.
- Results: High overall accuracy, but poor precision and recall for minority classes.

**Experiment 1:**

- Changes: Implement class-weighting to penalize mistakes on minority classes more heavily.
- Results: Improved precision and recall for minority classes, but overall accuracy slightly decreased.

**Experiment 2:**

- Changes: Add dropout layers with a rate of 0.5 after each convolutional layer.
- Results: Overall accuracy decreased, and no significant change in precision and recall for minority classes.

Given these outcomes, what is the most effective strategy to further improve the model's performance specifically for the minority classes without compromising the overall accuracy?
A: Increase the dropout rate to 0.7
B: Further fine-tune class-weighting parameters
C: Increase the number of filters in the convolutional layers
D: Add batch normalization layers after each convolutional layer
E: Use a different activation function like LeakyReLU
F: Implement more aggressive data augmentation on the minority class

Medium

Code language
Solve
In a new code language called Adira, 

- '4A, 2B, 9C' means 'truth is eternal'
- '9C, 2B, 8G, 3F' means 'hatred is not eternal'
- '4A, 5T, 3F, 1X' means 'truth does not change'

What is the code for 'hatred' in Adira?

Easy

Colorful sentences
Solve
Our intern is writing a colorful blog post, and has written the following code. What colors will the sentences be?
 image
A: Sentence 1 will be gray, Sentence 2 will be pink.
B: Both sentences will be gray.
C: Sentence 1 will be pink, Sentence 2 will be gray.
D: Both sentences will be pink.
E: The code does not make sense; will throw an error.

Medium

Commerical Premises
Reading comprehension
Solve
A large real estate company conducted a recent study of their customers. The study was designed to uncover insights regarding the main criteria for choosing to invest in a residential property. A majority of the customers surveyed stated the 'returns profile' was their main priority, followed by 'development potential' and 'stability of income'. 'Portfolio legacy' ranked at the bottom in the list of factors. It was interesting to note that respondents were less likely to have residential holdings that formed part of mixed-use assets i.e. as an add on to commercial investment. One might assume that more investors are proactively investing in residential real estate rather than having incidental exposure via business investments. 
Based on the given passage, what can we say about the following statement?

Business owners having commercial premises often have a residential property as part of their portfolio.

Medium

Completion Handlers
Views
Animations
Solve
Consider the following iOS (Swift) code snippet:
 image
What will happen when this view controller appears?

A) The squareView will move 100 points to the right instantly and then change its background color to blue.
B) The squareView will not move, and its background color will not change.
C) The squareView will change its background color to blue instantly and then move 100 points to the right over 1 second.
D) The squareView will move 100 points to the right and change its background color to blue simultaneously over 1 second.
E) The squareView will move 100 points to the right over 1 second, and the background color will change to blue after 1 second.

Medium

Complex GDPR Compliance
GDPR
Email Segmentation
Data Protection Rights
Solve
As the Email Marketing Lead of a multinational company, you manage campaigns targeting subscribers from various regions including the European Union. You decide to send a product update email only to subscribers who have used the product in the past year. To do so, you need to use customer usage data stored in your company's database. 

One of your subscribers, an EU citizen, had opted out of usage-based email marketing a few months ago, but they have been an active user of the product. 

Keeping the GDPR guidelines in mind, select the best course of action:
A: Exclude this subscriber from your product update email because they opted out of usage-based email marketing.
B: Include this subscriber in your product update email because they are an active user of the product.
C: Contact this subscriber to get explicit consent to receive the product update email.
D: Include this subscriber in your product update email because the product updates are crucial for a good user experience.
E: Delete this subscriber's usage data from your database because they opted out of usage-based email marketing.
F: Send a general product update email to this subscriber, excluding specific usage-based information.

Medium

Components and Attributes
LWC
Solve
Review the following Salesforce Lightning web component- adafaceComponent:
 image
Here are two possible JS files for this component: (notice the missing this.setAttribute line in option II)
 image
Here are the possible generated html files: (Notice the missing inp attribute in option B)
 image
Pick the correct statements:

Medium

Composite entity
Solve
Sam works as Dynamics 365 finance developer at Altman inc. Altman has following entities:
 image
Sam is tasked with creating the required fields and relationships in the staging tables. Which object should Same use for each of the following actions (to develop a composite entity that uses the OrderHeader and OrderLine entities)?
 image

Medium

Compound Revenue Growth Rate
Projections
Income Statement
Solve
Given the following information for the company NotOpenAI:
 image
What is the projected Year 6 Revenue based on the historical compound annual growth rate (CAGR)?

Medium

Comprehensive Performance Analysis
Key metrics
Performance Analysis
Solve
You are analyzing a detailed quarterly report for a Google Ads account that manages campaigns for three distinct product categories: Electronics, Home & Garden, and Apparel. The report includes various metrics such as CTR, CPC, CPA, ROAS, and Conversion Rate for each category. Here are the details:

- Electronics:
    - CTR: 2.8%
    - Average CPC: $1.2
    - Total Conversions: 340
    - Total Conversion Value: $102,000
    - Total Spend: $40,800
- Home & Garden:
    - CTR: 3.5%
    - Average CPC: $0.85
    - Total Conversions: 250
    - Total Conversion Value: $50,000
    - Total Spend: $21,250
- Apparel:
    - CTR: 4.2%
    - Average CPC: $0.65
    - Total Conversions: 480
    - Total Conversion Value: $72,000
    - Total Spend: $31,200

Calculate the Conversion Rate (CR) for each category and determine which product category is underperforming considering the ROAS and CR, and what possible steps can be taken to optimize it?
A: Electronics, consider reducing the CPC and refining the target audience.
B: Home & Garden, consider increasing the budget and using more targeted keywords.
C: Apparel, consider reducing the CPC and refining the target audience.
D: Electronics, consider increasing the budget and using more targeted keywords.
E: Home & Garden, consider reducing the CPC and improving the ad creatives.

Medium

Conditional Processing
Row Filtering
Component Linking
Job Design
Solve
Consider a Talend job that reads rows from a tFileInputDelimited component and intends to process them through a series of transformations. Here's a pseudocode representation of a segment of your Talend job:
 image
You need to implement this logic within your Talend job such that rows with a "columnValue" greater than 100 follow one transformation path and others follow a different transformation path. Which of the following actions would help achieve this desired behavior?
A: Use a tFlowToIterate component after the tFileInputDelimited to iterate over rows and use a Java condition to route the data.
B: In the tMap component, set filters on the output links to achieve conditional routing based on "columnValue".
C: Place two tMap components side by side after tFileInputDelimited and use "columnValue" in each to filter rows.
D: Use a tSplitRow component after tFileInputDelimited to split rows based on the condition and connect to respective tMap components.
E: Implement a custom code component like tJavaRow to determine the flow of rows.

Medium

Conditional Stage Execution
Conditional Stages
Jenkinsfile
Build Optimization
Solve
You are given a Jenkinsfile for a pipeline that builds, tests, and deploys an application. The pipeline has multiple stages, and you need to optimize it by ensuring certain stages are executed only under specific conditions. The current Jenkinsfile looks like this:
 image
Your task is to modify the Jenkinsfile so that:

1. The 'Test' stage is executed only if the 'Build' stage is successful.
2. The 'Deploy' stage is executed only for builds triggered by commits to the 'master' branch.
3. All stages should always run for scheduled nightly builds regardless of the branch.

Which of the following modifications to the Jenkinsfile will meet these requirements?
 image

Medium

ConfigMap and Secrets Interaction
Resource Management
Security
Solve
In a Kubernetes cluster, you are working on configuring a new deployment that should be able to access specific environment variables through both ConfigMap and Secrets resources. The deployment YAML is structured as follows:
 image
You have applied the above YAML successfully without any errors. Now, you are about to configure a service to expose the deployment. Before doing that, you want to confirm the security and setup implications.

Based on the above configuration, which of the following statements are true?
1. The DATABASE_PASSWORD will be mounted as an environment variable in plain text.
2. The ConfigMap data can be updated and the changes will be reflected automatically in the running pods without any need for a redeployment.
3. If a potential attacker gains access to the cluster, they would be able to retrieve the DATABASE_PASSWORD in plain text from the secrets resource as it is defined in stringData.
4. The APP_ENV and DATABASE_URL values are securely stored and cannot be accessed by non-admin users.
5. If a new container in the same pod is created, it would automatically have the DATABASE_PASSWORD environment variable configured.

Medium

Configuration for SSL
SSL Configuration
Performance Tuning
Server Blocks
Solve
An organization wants to configure an Nginx server to serve both HTTP and HTTPS traffic efficiently. The requirements are as follows: redirect all HTTP traffic to HTTPS, utilize the SSL protocol for secure communication, and ensure optimal performance by enabling gzip compression for text files. Given the configuration snippets below, select the correct combination that meets these requirements.

1.
 image
2.
 image
3.
 image
4.
 image
5.
 image

Easy

Configuring Load Balancing
Load Balancing
Web Hosting
Server Configuration
Solve
A client has a high-traffic website that is currently hosted on a single server. To ensure high availability and to distribute the load across multiple servers, they have decided to implement a load balancing solution.

The client has set up two additional servers identical to the original one, and all three servers are configured to serve the website. They have also set up a load balancer and updated their DNS records so that the website's domain now points to the load balancer.

Now, the client approaches you to verify the configuration. While reviewing the setup, you discover that the client hasn't configured session persistence (also known as sticky sessions) on their load balancer.

Which of the following are potential issues the client might face due to the lack of session persistence?
A: Users may experience slower website load times.
B: User sessions might be lost, causing them to be logged out unexpectedly.
C: The load balancer may not distribute traffic evenly across the servers.
D: The website may not be accessible if one of the servers goes down.
E: Users may not be able to establish a secure connection to the website.

Medium

Configuring Network Services
Network Services
Firewall Configuration
Solve
You are administering a Windows Server that hosts a critical application accessible within the internal network. The server is configured to use a static IP address. Your task is to ensure the server can communicate with a specific range of IP addresses on the internal network (192.168.10.0/24) while blocking all other inbound and outbound network traffic. The server also needs to be accessible via Remote Desktop for maintenance purposes. Given these requirements, which of the following configurations would best achieve this goal?
A: Configure Windows Firewall to allow inbound RDP traffic and outbound traffic to 192.168.10.0/24; block all other traffic.
B: Set up a Network Security Group (NSG) to allow traffic from 192.168.10.0/24 and enable RDP access.
C: Implement an inbound firewall rule to allow RDP and an outbound rule to allow traffic to 192.168.10.0/24.
D: Create a VPN tunnel for the 192.168.10.0/24 subnet and configure RDP access through the VPN.
E: Enable RDP in the firewall settings and use a third-party firewall to restrict network traffic.
F: Disable the Windows Firewall and rely solely on router-based network security to manage traffic.

Medium

Content Marketing and Email Campaigns
Email Marketing
Conversion Optimization
Solve
Your company has recently launched a new product, and as a content marketer, you have been asked to utilize email marketing to increase awareness and conversions. After carefully analyzing the email open rates, click-through rates, and conversion rates of your initial email campaigns, you notice a trend: emails with longer, in-depth content have higher open rates, but lower conversion rates, whereas emails with shorter, concise content have lower open rates but higher conversion rates. Which of the following would be the best approach to optimize your future email campaigns?
A: Continue sending longer, in-depth emails to maintain high open rates
B: Switch to shorter, concise emails to improve conversion rates
C: Send a mix of longer, in-depth emails and shorter, concise emails
D: Send longer, in-depth emails to engaged subscribers and shorter, concise emails to less engaged subscribers
E: Experiment with different email formats and content lengths to find the optimal balance
F: Focus on improving the email subject lines and preview text to increase both open rates and conversion rates

Medium

Content Marketing Metrics
SEO
Data Analysis
Solve
You are the content manager for a growing e-commerce startup. You've been tasked with developing a content marketing strategy to increase brand awareness and drive more sales. To measure the success of your content marketing efforts, you decide to monitor several key performance indicators (KPIs). Which of the following KPIs would be most valuable in assessing the effectiveness of your content marketing strategy?
A: Website traffic, social media followers, and email newsletter subscribers
B: Time spent on page, bounce rate, and click-through rate
C: Website traffic, conversion rate, and customer acquisition cost
D: Number of blog posts published, email open rate, and social media post engagement
E: Social media followers, number of blog posts published, and customer acquisition cost
F: Email newsletter subscribers, bounce rate, and number of blog posts published

Medium

Content Query Web Part
Customization
Solve
You are working as a SharePoint Consultant and have been tasked to create a custom view for the Content Query Web Part (CQWP) on a client's SharePoint site. The client would like to display news articles, grouped by the month they were published in. The title, publish date, and author of each article should be displayed, along with the total number of articles for that month.
The following is a part of the XSLT code you are working with:
 image
Which modification should you make to the XSLT code to achieve the desired output?

A. Replace <xsl:param name="Month" /> with <xsl:param name="PublishDate" />

B. Add <xsl:value-of select="$RowCount" /> after the closing </h2> tag

C. Replace select="count($Rows[@Month = $Month])" with select="count($Rows[@PublishDate = $Month])"

D. Add <xsl:value-of select="substring(@Author, 0, 3)" /> after the closing </h2> tag

E. Add <xsl:value-of select="@Title" /> inside the <div class="monthGroupContent"> tag

Hard

Context re-renders
React Context API
Conditional Rendering
Component Lifecycle State
Solve
Review the following React code:
 image
Pick the correct statements:

A: The code renders 10 INDIAN RUPEE
B: The code renders 10 SINGAPORE DOLLAR
C: The code does not render anything and throws an error since JavaScript objects are not valid as React children
D: When the currency portion is clicked, the parent component is re-rendered
E: When the currency portion is clicked, parent component will skip the re-render because shouldComponentUpdate returns false
F: Parent component can be converted to a functional component with memoization (useMemo or memo) to avoid the re-render

Medium

Conversion Tracking
Conversion tracking
Attribution models
Solve
Your e-commerce website recently launched a Google Ads campaign for a new line of products. After a month, you analyze the conversion data and notice that a significant number of conversions are not being tracked. You are using the last click attribution model. You find that most of the missed conversions are coming from users who clicked on your ad, left, and then returned to make a purchase within a week.

Given this situation, how should you modify the conversion tracking settings to ensure that all conversions are accurately tracked?
A: Change the attribution model to first click.
B: Extend the conversion window to cover a longer period.
C: Switch to a time decay attribution model.
D: Set up a new conversion action specifically for these products.
E: Change the attribution model to a linear model.

Medium

CostPerTrack
DataWeave
Solve
Review the following Mulesoft exhibit:
 image
Which of the given DataWeave expressions will transform the above input to the following XML output?
 image
 image

Easy

Count number of occurrences
Mappers
Reducers
Solve
Chusk works as Hadoop developer at Pesla Inc. Chusk is tasked with processing input data to count number of occurrences of each unique word. Chusk did the following to achieve this:

1. Tokenize each word and emit lateral value 1 with Mapper
2. Reducer increments counter for each literal 1 it receives
Chusk is now tasked with optimizing this by using a combiner. Will Chusk be able to reuse existing reducers as combiners?
A: Yes
B: No
C: Because the sum operation is both associative and commutative and the input and output types to the reduce method match
D: Because the sum operation in the Reducer is incompatible with the operation of a combiner
E: Because the combiner is incompatible with a Mapper, which doesn't use the same data type for both the key and value
F: Insufficient information

Medium

Overloading
OOPs
Solve
What will the following C++ code output?
 image

Medium

Exceptions
Exceptions
Solve
What will the following C++ code output?
 image

Easy

Namespaces
Solve
What will the following C++ code output?
 image

Medium

Struct Class
Solve
What will the following C++ code output?
 image

Medium

Component Lifecycle
Solve
Consider the following Vue2 component:
 image
What will be printed in the console?
 image

Medium

Sales Table
Solve
Here's a proposal for SALES table in Oracle SQL:
 image
Of the following statements about creating SALES table and storing data, which are true?
A: The CUST_STATUS column would store exactly one character
B: The SALE_VALIDITY column would have a maximum size of one character
C: The CUST_CREDIT column would be able to store decimal values
D: The SALE_VALIDITY column would give an error

Easy

Crop marks
Solve
Cho's boss has asked set up a document containing artwork for printing in InDesign CS5. The boss has also mentioned that they need the artwork to contain a bleed or slug area. When Cho is setting crop marks, what should they make a note of?
 image

Medium

Cross-Border Trade Complications
Trade Agreements
Customs
Cross-Border Transactions
Solve
Case Study:

*EuraCraft Ltd.*, a luxury furniture maker, uses Dynamics 365 SCM for its operations. They've recently expanded their market reach and have started exporting their products to multiple countries. Each of these countries has specific trade agreements, customs duties, and taxations that *EuraCraft* needs to comply with.

They are keen on setting up Dynamics 365 SCM in a manner that automatically adjusts pricing, applies correct customs duties, and ensures compliance for each international order based on the destination country.

Question:

How should *EuraCraft Ltd.* tailor their Dynamics 365 SCM setup to seamlessly manage varying cross-border trade regulations and ensure proper pricing and compliance for each international transaction?
A: Implement country-specific Item Pricing and tie them to customer profiles based on their location.
B: Set up Trade Agreements in SCM, specifying conditions, pricing, duties, and taxes for each country they export to.
C: Use the International Module to auto-convert currency rates and apply flat international fees for simplicity.
D: Activate the Global Address Book, ensuring customer data from different countries is segregated and priced differently.
E: Rely on third-party integrations for tax calculations, leaving pricing and duties to be handled manually.

Medium

Cookie Security Analysis
Web Application Security
HTTP Cookies
Cross-Domain Communication
Solve
You are a cybersecurity officer and a new third-party payment gateway is integrated into your company's e-commerce website. The payment gateway API is hosted on a different domain (pay-gateway.com) than your e-commerce site (my-ecommerce.com). You receive some reports that users are unable to complete their transactions intermittently. 

You obtain the following set of HTTP cookies from an affected user:

1. user_session=1; Domain=my-ecommerce.com; Path=/; Secure; HttpOnly
2. payment_session=xyz123; Domain=pay-gateway.com; Path=/; Secure; HttpOnly
3. cart_id=abcd1234; Domain=my-ecommerce.com; Path=/; Secure
4. csrf_token=efgh5678; Domain=my-ecommerce.com; Path=/; Secure
5. currency=USD; Domain=my-ecommerce.com; Path=/;
6. same_site_test=1; Domain=my-ecommerce.com; Path=/; Secure; SameSite=None
7. payment_verification=; Domain=my-ecommerce.com; Path=/; Secure; HttpOnly

Which of the following configuration modifications would likely solve the intermittent transaction failure issue?
A: Set SameSite=Strict attribute on all cookies.
B: Set "SameSite=None; Secure" attribute on the payment_session cookie.
C: Change the Domain attribute of payment_session cookie to my-ecommerce.com.
D: Set HttpOnly attribute on cart_id and csrf_token cookies.
E: Remove Secure attribute from user_session cookie.

Easy

Arrays and Exceptions
Arrays
Exceptions
Solve
What is the output of the following C# code?
 image

Medium

Multiple Namespaces
Solve
Class Student exists in both firstnamespace and secondnamespace namespaces. Which of the following are the correct ways to use the Student class?
 image

Medium

Static and constructors
OOPs
Solve
What is the output of the following C# code?
 image

Easy

Custom Exception
Exception Handling
Custom Exceptions
Solve
What does the following code output?
 image

Medium

Custom Validation Rule
Validation
Request Handling
Custom Rules
Solve
In your Laravel application, you are implementing a registration form where users enter their birthdate as a string in the 'Y-m-d' format. You want to ensure that only users aged 18 years or older can register. To achieve this, you decide to write a custom validation rule. Consider the following implementation of the custom rule and a function to handle the registration request:
 image
Which of the following code snippets correctly fills the passes method in the AgeRestriction class to ensure that only users aged 18 or older can register, given that the birthdate is a string in the 'Y-m-d' format?
 image

Medium

Custom WordPress Shortcode
Shortcodes
Solve
You're creating a custom WordPress shortcode that users can insert into their posts and pages to display a promotional banner. Your initial PHP code is as follows:
 image
A user inserts your shortcode into a post like this:
 image
However, when the user previews the post, the content inside the `[promo-banner]` shortcode isn't displayed. Instead, the user sees the shortcode itself.

What change can you make to fix this issue?
A: Replace `'promo-banner'` with `'[promo-banner]'` in the `add_shortcode` function.
B: Replace `'promo-banner'` with `'[promo-banner]'` in the shortcode inserted into the post.
C: Change the `promo_banner_shortcode` function to accept only one parameter.
D: Use `do_shortcode` function to process the `$content` inside the `promo_banner_shortcode` function.
E: Replace `$content` with `$atts['content']` in the `promo_banner_shortcode` function.

Medium

Customized Solutions
Client Profiling
Customization Options
Value Proposition
Solve
As a Senior Sales Consultant at CustomSoft, you specialize in selling bespoke software solutions to large enterprises. CustomSoft's pricing is highly dependent on the customization level required by the client. The basic package starts at $20,000, with added costs for customization: $5,000 for each basic feature customization and $10,000 for advanced feature customization.

Your current prospect is BetaCorp, a multinational corporation in the manufacturing sector. BetaCorp's profile is as follows:

- Annual Revenue: $500 million
- Employee Count: 5,000
- Current IT Infrastructure: Outdated, primarily manual systems
- Main Objectives: Streamlining operations, integrating various departments
- Budget Constraints: Moderate, prefers value-for-money solutions
- Decision-Making Process: Lengthy, requires demonstration of ROI
- Previous Vendor Experience: Unhappy with the lack of customization and support

Based on this information, which TWO of the following statements should be emphasized in your proposal to effectively align with BetaCorp's needs and decision-making criteria?
1) "Our basic package, combined with two advanced feature customizations, will comprehensively address your need for operational streamlining and department integration."
2) "Considering your budget constraints, our basic package without additional customizations offers the best value for money."
3) "CustomSoft's commitment to post-sale support will address the issues you've faced with previous vendors."
4) "With your focus on data security, investing in three advanced feature customizations will ensure robust protection against threats."
5) "Given your company's size and revenue, our complete customization package would be the most suitable, ensuring all specific needs are met."

Medium

Data Aggregation and Transformation
Data Aggregation
Data Transformation
Solve
You are working with a dataset, `df`, that contains columns 'A', 'B', and 'C'. You need to perform the following tasks:

1. Group the DataFrame `df` by column 'A'.
2. Compute the sum of column 'B' for each group.
3. Append this sum as a new column 'D' to the original DataFrame `df`.

You wrote the following code to perform these tasks:
 image
However, you notice that the new column 'D' contains many missing values. What is the cause of this issue?
A: The groupby method did not work as expected.
B: The sum method did not work as expected.
C: The new column 'D' should be appended to grouped instead of df.
D: The grouped object should be mapped to df['A'] before assigning to a new column in df
E: The groupby method should be called on df['A'] instead of df.

Easy

Data Filtering
Data Filtering
Data Process Shape
Solve
As a seasoned Dell Boomi developer, you're working on a process that involves fetching customer records from a database. The requirements state that only the records of customers who are 'active' and whose 'last_purchase_date' is within the last 30 days should be processed.

Among the options listed below, which approach will best allow you to filter the records as per the given conditions?
A: Use a Decision Shape with the conditions for 'active' status and 'last_purchase_date'.
B: Use a Set Properties Shape to set the conditions for 'active' status and 'last_purchase_date'.
C: Use a Data Process Shape with a custom scripting step to filter based on 'active' status and 'last_purchase_date'.
D: Use a Business Rules Shape to enforce the conditions for 'active' status and 'last_purchase_date'.
E: Use a Branch Shape to segregate records based on 'active' status and 'last_purchase_date'.

Medium

Data Filtering
Report Development
M Language
Data Visualization
Solve
You are creating a Power BI report where users need to dynamically filter data based on a range of dates. The report has a Sales table with columns Date, ProductID, and Amount. You decide to use a Power Query parameter to allow users to select a start and end date, which will then filter the Sales table accordingly. The parameter is named DateRange and has a type of List. You need to write a Power Query M formula to filter the Sales table based on the selected date range. The DateRange parameter contains two dates: the first item is the start date, and the second item is the end date. How should the M formula be structured to achieve this functionality?
A: Table.SelectRows(Sales, each [Date] >= DateRange{0} and [Date] <= DateRange{1})

B: Sales{[Date] >= DateRange{0}, [Date] <= DateRange{1}}

C: Table.FilterRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))

D: Table.SelectRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))

E: Filter.Table(Sales, [Date] >= DateRange{0}, [Date] <= DateRange{1})

Medium

Data Integration
Complex Data Integration
Error Handling
Dynamic Document Properties
Solve
You're a Dell Boomi expert who is currently engaged in a complex integration project. The integration process needs to be created which involves pulling sales order data from a cloud-based CRM, transforming it, and then sending it to an on-premise ERP system. The CRM provides an API endpoint that returns JSON data. After fetching the data, you need to transform it into a specific XML format that the ERP system can consume.

The process is supposed to run daily at midnight and should handle any error situations gracefully. It should also handle retry mechanism and make use of dynamic document properties for setting some of the values in the XML document.

Which of the following configurations would be the most suitable for handling this requirement?
A: Start Shape -> JSON Profile -> HTTP Client Connector -> Data Process Shape -> XML Profile -> Dynamic Document Property -> Connector for ERP -> Try/Catch Shape -> Stop Shape

B: Start Shape -> HTTP Client Connector -> Data Process Shape -> JSON Profile -> Dynamic Document Property -> XML Profile -> Connector for ERP -> Try/Catch Shape -> Stop Shape

C: Start Shape -> HTTP Client Connector -> JSON Profile -> Data Process Shape -> Dynamic Document Property -> XML Profile -> Connector for ERP -> Exception Shape -> Stop Shape

D: Start Shape -> HTTP Client Connector -> JSON Profile -> Data Process Shape -> XML Profile -> Dynamic Document Property -> Connector for ERP -> Try/Catch Shape -> Stop Shape

E: Start Shape -> HTTP Client Connector -> Data Process Shape -> JSON Profile -> XML Profile -> Dynamic Document Property -> Connector for ERP -> Try/Catch Shape -> Stop Shape

Medium

Data Merging
Data Merging
Conditional Logic
Solve
A data engineer is tasked with merging and transforming data from two sources for a business analytics report. Source 1 is a SQL database 'Employee' with fields EmployeeID (int), Name (varchar), DepartmentID (int), and JoinDate (date). Source 2 is a CSV file 'Department' with fields DepartmentID (int), DepartmentName (varchar), and Budget (float). The objective is to create a summary table that lists EmployeeID, Name, DepartmentName, and YearsInCompany. The YearsInCompany should be calculated based on the JoinDate and the current date, rounded down to the nearest whole number. Consider the following initial SQL query:
 image
Which of the following modifications ensures accurate data transformation as per the requirements?
A: Change FLOOR to CEILING in the calculation of YearsInCompany.
B: Add WHERE e.JoinDate IS NOT NULL before the JOIN clause.
C: Replace JOIN with LEFT JOIN and use COALESCE(d.DepartmentName, 'Unknown').
D: Change the YearsInCompany calculation to YEAR(CURRENT_DATE) - YEAR(e.JoinDate).
E: Use DATEDIFF(YEAR, e.JoinDate, CURRENT_DATE) for YearsInCompany calculation.

Medium

Data Processing in ABAP
SQL Joins
Internal Tables
Solve
In the given ABAP pseudo code, data from two tables `zemployee` and `zdepartment` is being retrieved and processed. The code aims to handle records from employees in the 'Sales' department with a salary greater than 5000. Consider the efficiency and optimization of the code:
 image
The goal is to optimize the code for performance, especially considering the potential size of the data in the tables. Which of the following options would be the most effective optimization?
A: Replace nested IF with a single IF statement using AND.
B: Use a JOIN statement in SELECT to combine tables and directly apply the conditions for 'Sales' department and salary > 5000.
C: Implement a secondary index on zemployee for the salary field.
D: Use FOR ALL ENTRIES instead of nested SELECT statements.
E: Optimize the READ TABLE statement with a binary search.
F: Change LOOP AT it_employee to a parallel cursor technique.

Medium

Data Provider DispatchQueue
Closures
Asychronous operations.
Solve
Consider the following code snippet:
 image
What will be printed after the code execution?

Medium

Data sync task
Data Integration Connectors
Solve
Instakram uses Informatica for data integration. They want to use Informatica Salesforce Analytics Connector to connect between Data Integration and Salesforce Analytics. Instakram has  a data synchronization task that

- Performs a lookup on the Salesforce Account object
- Returns Salesforce lD and matches contacts to their correct Account records

The task is running very slowly. What could be the possible reason for poor performance of the task and how can the speed of the task be increased?
 image

Medium

Data Updates
Staging
Data Warehouse
Solve
Jaylo is hired as Data warehouse engineer at Affflex Inc. Jaylo is tasked with designing an ETL process for loading data from SQL server database into a large fact table. Here are the specifications of the system:
1. Orders data from SQL to be stored in fact table in the warehouse each day with prior day’s order data
2. Loading new data must take as less time as possible
3. Remove data that is more then 2 years old
4. Ensure the data loads correctly
5. Minimize record locking and impact on transaction log
Which of the following should be part of Jaylo’s ETL design?

A: Partition the destination fact table by date
B: Partition the destination fact table by customer
C: Insert new data directly into fact table
D: Delete old data directly from fact table
E: Use partition switching and staging table to load new data
F: Use partition switching and staging table to remove old data

Medium

Database Performance Tuning and Data Consistency
Database Performance Tuning
Transaction Management
Locking Mechanisms
Solve
Consider the following DB2 database scenario. You are managing a stock trading platform that uses a DB2 database to track user transactions and market prices. The database has two tables, Users and Stocks.
 image
A user transaction to buy a stock is a two-step process:

1. Decrease the user's balance in the Users table.
2. Increase the quantity of the stock owned by the user in the Stocks table.

Both these steps need to be performed atomically to maintain data consistency.

Recently, with the increase in the volume of transactions, you are experiencing performance issues. Additionally, you have observed that during peak trading hours, a large number of user transactions are getting blocked, leading to user dissatisfaction.

Which of the following strategies would BEST address the performance and blocking issues, while ensuring data consistency?
A: Implement an optimistic concurrency control mechanism.
B: Reduce the transaction isolation level to READ UNCOMMITTED.
C: Break the transaction into two separate transactions
D: Increase the database's buffer pool size.
E: Implement row-level locking.

Medium

Database testcase
Regression Testing
Solve
Adaface is developing a new database system called “Helen”. The tester at Adaface developed the following testcase for regression testing:
1. Open Helen
2. Open “Students” database
3. Enter data for “Sid”
4. Set checkpoint
5. Store “Sid” data in “Students” 
6. Restart Helen
7. Read “Sid” data from “Students”
8. Compare checkpoint with the contents
When the tester ran the testcase the first time, it worked as expected. Pick the correct statements:

A: When the test case is ran the second time, the data entry for “Sid” already exists in the database. 
B: When the test case is ran the second time, it performs exactly as it did the first time
C: The testcase is a good example for regression testing “Helen”
D: The testcase is not a good example for regression testing “Helen” since the system behaves differently when the testcase is ran the second time

Medium

Dataframe Transform
Solve
Review the following Dataframe 'bazinga':
 image
Which of the following commands would turn it into the Dataframe shown below:
 image
 image

Medium

Date Functions and Table Filtering
Date functions
SQL
Solve
In a Sybase ASE database, there's a table named ‘employees’ with the following columns:

- emp_id (int)
- emp_name (varchar)
- date_joined (datetime)

You are tasked with fetching the names of employees who joined the company in January 2022. Which of the following pseudocode SQL statements would correctly give you the desired result?
 image

Medium

DB2 Isolation Levels and Data Consistency Revisited
Transactions
Isolation Levels
Data Consistency
Solve
Consider two users executing the following transactions concurrently on DB2:

Transaction 1 (User A):
 image
Transaction 2 (User B):
 image
Table1 has thousands of records, and the value 'Value1' for Column1 is not unique in Table1. Both transactions are executed almost simultaneously with Transaction 2 executed a bit earlier. Considering the isolation levels set for the transactions, which of the following is the potential data inconsistency issue that might arise?
A: A deadlock situation may occur.
B: Transaction 1 will wait indefinitely for Transaction 2 to commit.
C: Both transactions might update the same record leading to a lost update.
D: Transaction 1 can experience a dirty read due to the changes made by Transaction 2.

Medium

Debugging Issues
Environment Variables
Debugging
Solve
You are working on a Linux system and have recently installed a new program named myprogram. The executable is located in /opt/myprogram/bin/. You want to be able to run this program from any directory in your shell without specifying the full path.
You executed the following command:
export PATH="/opt/myprogram/bin"
However, when you try to run the program using myprogram, you get the following error message:
-bash: myprogram: command not found

Which of the following commands can fix this issue and allow you to run the program?
A: export PATH=$PATH:/opt/myprogram/bin/
B: export PATH="/opt/myprogram:$PATH"
C: export PATH="/opt/myprogram/bin:$PATH"
D: ln -s /opt/myprogram/bin/myprogram /usr/local/bin/myprogram

Medium

Debugging Redux Actions and Reducers
JavaScript ES6
Reducers
Actions
Solve
A developer is working with a Redux application for managing todo items. After some changes to the code, they started facing a problem: When they try to add a new todo item, it doesn't appear on the list. However, deleting a todo item works as expected.

Here is the error message they see in the console when trying to add a todo: `Cannot read property 'undefined' of undefined.`

And here is the relevant Redux code:
 image
Which of the following changes will resolve the issue?
A: Change payload to todo in addTodo action creator.
B: Change action.todo to action.payload in todoReducer for ADD_TODO case.
C: Change action.todo to action.payload in todoReducer for ADD_TODO case and change action.index to action.payload for DELETE_TODO case.
D: Change payload to todo in addTodo action creator and index to payload in deleteTodo action creator.

Medium

Debugging Redux with Complex State and Action
JavaScript ES6
Reducers
Actions
Immutability
Object manipulation
Solve
A developer is working on a Redux application where each action carries an array of items, and each item is an object with an `id` and `value`. The state is an object where each key is an item's `id` and each value is the item's `value`. However, they notice that the `ADD_ITEMS` action isn't updating the state as expected.

Here is the relevant Redux code:
 image
What change should the developer make to correct the issue?
 image

Medium

Decision Control
Arithmetic Operations
Decision Structures
Data Types
Solve
Consider the following COBOL program:
 image
What will the program display when it is executed?

Medium

Decision Table
Solve
Check the following decision table:
 image
What are the expected actions for following testcases?

I: Joey's age is 22. He is a smoker residing in India

II: Jennifer's age is 62. She is a non-smoker not residing in India

A) I - Insure, 10% discount. II - Insure, no discount
B) I - Don't insure. II - Don't insure
C) I - Insure, no discount. II - Don't insure
D) I - Insure, no discount. II - Insure, 10% discount

Medium

Decryptor
Strings
Solve
What does the following pseudo code print?
 image

Medium

Defer, Panic, and Recover
Control Flow
Error Handling
Solve
Consider the following Go code snippet, where we're exploring the use of defer, panic, and recover:
 image
In this pseudo-code, badCall function is deliberately causing a panic. test function uses a deferred function to handle the panic and recover from it. What will the output of this code be when it is run?
 image

Medium

Delegated Contract Execution
Delegatecall
Modifiers
Contract Security
Solve
In the Solidity code provided, there are two contracts: MainContract and HelperContract. MainContract uses delegatecall to execute a function in HelperContract. Carefully analyze the code and determine the outcome of specific operations.
 image
After deploying both contracts and setting the HelperContract address in MainContract, what will be the result of calling setHelperVars(100) from an EOA (Externally Owned Account)?
A: Only HelperContract's state is modified.
B: Only MainContract's state is modified.
C: States of both MainContract and HelperContract are modified.
D: Transaction fails due to the onlyOwner modifier in MainContract.
E: MainContract's sender and value are modified, but num remains unchanged.
F: HelperContract's sender and value are modified, but num remains unchanged.

Easy

Delete in Entity Dimension
Solve
AWSCORP uses Hyperion Planning and plans a major reorganization of the company structure. As part of the change, you are asked to rebuild the Entity dimension from scratch. To start, you have to delete members in the Entity dimension. Which of these would you do:

A. You must delete members one by one.
B. You must delete a reference to a member from all data forms before deleting it from the dimension.
C. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
D. A database refresh is required after deleting members from the Entity dimension.

Easy

Delete item popup
Solve
We recently added the feature to enable a user to delete items from their dashboard. The feature was built on the request of a customer who needed it urgently, so the product engineer was the one who designed it, without consulting a designer. Can you review the design and recommend any changes if required?
 image

Medium

Dependencies and conditionals
Resources
Tags
Solve
Given the following Terraform code:
 image
What would be the value of the extra_security_group_id output when create_security_group is set to true, project_environment is set to "staging", and enable_additional_security_group is set to false?

Medium

Deployment and Resource Binding
Application Deployment
Resource Binding
JNDI
Solve
You are deploying a web application on IBM WebSphere Application Server, which uses a JDBC datasource and a JMS Queue. Below are snippets from the application's web.xml and ibm-web-bnd.xml files.

web.xml snippet:
 image
ibm-web-bnd.xml snippet:
 image
Assuming the JDBC datasource and JMS Queue are already correctly configured in the WebSphere Admin Console, which of the following is the required action to ensure the application deployment correctly references these resources?
A: Define JNDI names jdbc/myDataSource and jms/myQueue in the server's namespace.
B: Bind the application's JDBC datasource to jdbc/MyAppDataSource and JMS Queue to jms/MyAppQueue in the ibm-web-bnd.xml.
C: Update web.xml to reference the JNDI names jdbc/MyAppDataSource and jms/MyAppQueue.
D: Bind the resources in web.xml to the server's JDBC and JMS resources with matching names.
E: Modify the application code to reference jdbc/MyAppDataSource and jms/MyAppQueue directly.

Medium

Depreciation on new Capex
Depreciation Schedule
Projections
Solve
Our financial intern deleted the entries for the Depreciation from new CapEx by mistake. Can you help them calculate the total depreciation on new CapEx in Year 3?
 image

Medium

Design Workflow
Workflows
REST
Solve
A SharePoint Consultant is designing a workflow for a document library using SharePoint Designer. The workflow needs to use an impersonation step to create a list item in a different site collection when a document is uploaded. The SharePoint Designer must use the REST API to accomplish this task.
Consider the following code snippet for the REST API call in the impersonation step:
 image
Which of the following actions should the consultant add to the impersonation step and configure the appropriate properties?

A: Add a 'Call HTTP Web Service' action, set the HTTP method to POST, set the REST endpoint URL, configure the request headers, and set the request body with the JSON payload

B: Add a 'Create List Item' action, set the target list URL, and set the item properties using the JSON payload

C: Add a 'Call HTTP Web Service' action, set the HTTP method to POST, set the REST endpoint URL, configure the request headers, and set the request body without the JSON payload

D: Add a 'Copy Document' action, set the target list URL, and set the item properties using the JSON payload

Medium

Security Incident
Log Analysis
Solve
You are the security analyst for a company and are currently investigating a security incident. You found the following log entries in your HTTP server logs, which appear to be linked to the incident:

1. 192.0.2.4 - - [24/May/2023:13:15:30 +0000] "GET /wp-login.php HTTP/1.1" 200 167 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; yie8)"
2. 192.0.2.4 - - [24/May/2023:13:15:31 +0000] "POST /wp-login.php HTTP/1.1" 302 152 "http://www.example.com/wp-login.php" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; yie8)"
3. 192.0.2.4 - - [24/May/2023:13:15:32 +0000] "GET /wp-admin/install.php HTTP/1.1" 200 125 "http://www.example.com/wp-admin/" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; yie8)"

Based on this information, which of the following statements are correct?
A: The attacker was unable to compromise the Wordpress login page but was successful in accessing the installation page.
B: The attacker attempted to login to a Wordpress site and, despite the login failing, was able to access the Wordpress installation page.
C: The attacker was attempting a dictionary attack on the Wordpress site and accessed the Wordpress installation page.
D: The logs indicate that the attacker was able to compromise the Wordpress login and directly access the installation page.
E: The attacker attempted to login to a Wordpress site, succeeded, and then tried to access the Wordpress installation page.

Medium

Reason the input II
Solve
 image

Medium

Digital Channels for Subscriptions
Digital Marketing
Conversion Rate Optimization
Data Analysis
Solve
You are tasked with evaluating the performance of a digital marketing campaign designed to promote a new financial planning app targeting young professionals. The campaign utilized a mix of digital channels with the primary objectives being to increase app downloads and convert users into premium subscribers. Following the campaign's first quarter, you've compiled the following performance data:

- Total ad spend: $50,000
- Total impressions: 500,000 across all channels
- Total clicks: 25,000 across all channels
- Total app downloads: 5,000
- Total premium subscription sign-ups: 425
- The marketing is split into Email marketing, Social Media ads and Google AdWords.
- The campaign utilized three digital channels: social media ads, Google AdWords, and email marketing. Of these Social media ads contributed to 2,500 downloads with 125 premium subscriptions. Google AdWords contributed to 1,500 downloads with 150 subscriptions. The rest of the downloads and subscriptions came from Email Marketing.

Given this campaign performance data, which digital channel proved most effective for achieving the primary goal of converting users into premium subscribers and should be prioritized in future campaigns?
A: Social media ads, due to their largest contribution to app downloads.
B: Google AdWords, for its balanced performance in both generating downloads and converting subscriptions.
C: Email marketing, because of its highest conversion rate to premium subscriptions, indicating better targeting and engagement.
D: Google AdWords because of its highest conversion rate to premium subscriptions, indicating better targeting and engagement.
E: Social Media ads because of its highest conversion rate to premium subscriptions, indicating better targeting and engagement.

Medium

Direct State Mutation in Redux
JavaScript ES6
Reducers
Actions
Mutations
Solve
A developer is creating a Redux application to manage a list of blog posts. Each post is represented by an object with id, title, and content properties.

The Redux state should store the post list as an array. The developer observes that the modifications to the posts are not reflecting in the components.

Here is an example of what the state could look like:
 image
Here is the relevant Redux code:
 image
Which of the following changes will resolve the issue?
 image

Medium

Disposition Parameters
JCL Syntax
Dataset Management
Solve
Consider the following JCL snippet:
 image
In MYJOB, PROG1 in STEP1 uses the dataset MY.DS.INPUT with a disposition of (OLD,DELETE,KEEP). PROG2 in STEP2 also uses the dataset MY.DS.INPUT with a disposition of (NEW,PASS,DELETE).

Assume that STEP1 executed successfully, but STEP2 failed during its execution. What would be the status of the dataset MY.DS.INPUT after the job MYJOB is run?
A: MY.DS.INPUT will be deleted.
B: MY.DS.INPUT will be kept and can be used by other jobs.
C: MY.DS.INPUT will be newly created.
D: MY.DS.INPUT will be available for the duration of the job, then deleted.
E: MY.DS.INPUT status cannot be determined with the provided information.

Medium

Dividends
Financial Analysis
Percentage and Average Calculations
Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
 image
 image

Easy

URL Dispatcher
Routes
Solve
Review the following sample Django URL.conf:
 image
Pick the correct statements if settings.APPEND_SLASH=False:

A: A request to /books/2015/04/ would match the third entry in the list. Django would call the function views.month_books(request, year=2015, month=4).
B: A request to /books/2015/04/ would match the second entry in the list. Django would call the function views.year_books(request, year=2015).

C: A request to /books/2023/ will match the first entry in the list. Django would call the the function views.custom_newyear_2023(request).
D: A request to /books/2023/ would match the second entry in the list. Django would call the function views.year_books(request, year=2023).

E: /books/2022 would not match any of these patterns, because each pattern requires that the URL end with a slash.
F: A request to /books/2022 would match the second entry in the list. Django would call the function views.year_books(request, year=2022).

Medium

DNS Propagation Troubleshooting
DNS
Web Hosting
Solve
You are a technical support specialist and a client contacts you reporting they are unable to access their website after changing their domain's DNS records to point to a new web host. They receive an error message stating the server's IP address could not be found.

Upon investigation, you determine that:

1. The client made the DNS changes 24 hours ago.
2. The client's device is unable to resolve the domain to the new IP address.
3. Other devices in the client's local network also can't access the website.
4. The client is able to access other websites without issues.
5. Using an external tool, you find that DNS propagation has completed in most parts of the world.

Given these facts, what should the client do to resolve the issue?
A: Wait for another 24 hours for DNS propagation to complete.
B: Update the domain's DNS records again.
C: Reset the router and clear the DNS cache on their devices.
D: Contact the new web host and ask them to check their server configuration.
E: Change the domain's DNS records to point to the old web host.

Medium

Docker Multistage Build Analysis
Multistage Builds
Optimization
Solve
Consider the following Dockerfile, which utilizes multistage builds. The aim is to build a lightweight, optimized image that just runs the application.
 image
The Dockerfile first defines a base image that includes Node.js and npm, then it creates an intermediate image to install the npm dependencies. Afterwards, it runs the tests in another stage and finally, creates the release image.

Which of the following statements are true?

A: The final image will include the test scripts.
B: If a test fails, the final image will not be created.
C: The node_modules directory in the final image comes from the base image.
D: The final image will only contain the necessary application files and dependencies.
E: If the application's source code changes, only the release stage needs to be rebuilt.

Easy

Docker Networking and Volume Mounting Interplay
Networking
Volume Mounting
Solve
You have two docker containers, X and Y. Container X is running a web service listening on port 8080, and container Y is supposed to consume this service. Both containers are created from images that don't have any special network configurations.

Container X has a Dockerfile as follows:
 image
And, you build and run it with the following commands:
 image
Container Y is also running alpine with python installed, and it's supposed to read data from the `/app/data` directory and send a GET request to `http://localhost:8080` every 5 minutes. The Dockerfile for container B is:
 image
And you run it with:
 image
Assuming all the python scripts work perfectly and firewall isn't blocking any connections, you find that container Y can't access the web service of container X via `http://localhost:8080` and also it can't read the data in `/app/data` directory. What could be the potential reason(s)?
A: Y can't access X's web service because they're in different Docker networks.
B: Y can't read the data because the volume is not shared correctly.
C: Both A and B are correct.
D: Both A and B are incorrect.

Medium

Dockerfile Optimization
Dockerfile
Multi-stage builds
Layer Caching
Solve
You have been asked to optimize a Dockerfile for a Python application that involves a heavy dependency installation. Here is the Dockerfile you are starting with:
 image
Given that the application's source code changes frequently but the dependencies listed in requirements.txt rarely change, how can you optimize this Dockerfile to take advantage of Docker's layer caching, reducing the build time?
A: Move the `RUN pip install` command to before the `COPY` command.
B: Change `COPY . /app` to `COPY ./app.py /app` and move the `RUN pip install` command to before the `COPY` command.
C: Add `RUN pip cache purge` before `RUN pip install`.
D: Replace the base image with `python:3.8-slim`.
E: Implement multi-stage builds.

Medium

Dockerfile Updates
Cache
Solve
Check the following Dockerfile used for a project (STAGE 1):
 image
We created an image from this Dockerfile on Dec 14 2021. A couple of weeks after Dec 14 2021, Ubuntu released new security updates to their repository. After 2 months, we modified the file (STAGE 2):
 image
Couple of weeks later, we further modified the file to add a local file ada.txt to /ada.txt (STAGE 3): (Note that ada.txt exists in /home/adaface and the dockerfile exists in /home/code folders)
 image
Pick correct statements:

A: If we run “docker build .” at STAGE 2, new Ubuntu updates will be fetched because apt-get update will be run again since cache is invalidated for all lines/layers of Dockerfile when a new line is added.
B: If we run “docker build .” at STAGE 2, new Ubuntu updates will not be fetched since cache is invalidated only for last two lines of the updated Dockerfile. Since the first two commands remain the same, cached layers are re-used skipping apt get update.
C: To skip Cache, “docker build -no-cache .” can be used at STAGE 2. This will ensure new Ubuntu updates are picked up.
D: Docker command “docker build .” at STAGE 3 works as expected and adds local file ada.txt to the image.
E: Docker command “docker build .” at STAGE 3 gives an error “no such file or directory” since /home/adaface/ada.txt is not part of the Dockerfile context.

Medium

Document Management
File Organization
Record Keeping
Solve
You are an administrative assistant at a busy law firm. Today, your task is to organize client files. For each client, you have several types of documents: legal agreements, payment records, correspondence, and court filings. You've been asked to create a file hierarchy system that will allow the lawyers to easily locate the type of document they need for any given client. 

Below are the different options for the file hierarchy. Which one is the most efficient and logical structure for document management?
A: Client --> Legal Agreements, Payment Records, Correspondence, Court Filings
B: Legal Agreements --> Client, Payment Records --> Client, Correspondence --> Client, Court Filings --> Client
C: Client --> Court Filings --> Legal Agreements, Payment Records, Correspondence
D: Legal Agreements, Payment Records, Correspondence, Court Filings --> Client
E: Client --> Correspondence --> Legal Agreements, Payment Records, Court Filings
F: Correspondence, Legal Agreements --> Client, Payment Records, Court Filings --> Client

Medium

Document Properties
Document Properties
Data Mapping
Solve
As an experienced Dell Boomi developer, you're creating a process that involves fetching data from an external service via HTTP Client Connector. The service returns a JSON response containing multiple fields. One of these fields, 'record_status', can contain the values 'new', 'updated', or 'deleted'. This value will dictate the operation (insert, update, delete) that should be performed on your local database. 

In the Map shape used for mapping between the response JSON and your database schema, how could you leverage document properties to dynamically set the operation based on the 'record_status' field in the JSON response?
A: Use a Set Properties Shape before the Map shape to assign the 'record_status' value to a dynamic document property, and then use this property to determine the operation in the Map shape.
B: Set a dynamic process property to 'record_status' value and use a decision shape to route the process.
C: Use a Content Modifier to assign 'record_status' value to a dynamic document property and then use a decision shape to route the process.
D: Use a Set Properties Shape to assign 'record_status' value to a dynamic document property and then use a decision shape to route the process.
E: Set a dynamic process property to 'record_status' value and use this property to determine the operation in the Map shape.

Medium

DOFOR CHGVAR
Control processing
Solve
Review the following CL Program:
 image
If no other commands inside DOFOR affect &INTB and &INTA, what will the values of &INTA and &INTB be after completely running DOFOR?

Easy

Downtime and Workload
EC2
Solve
ChickTok is a dating app that runs on EC2 behind an ALB. The EC2 instances run in an EC2 Auto Scaling group across multiple AZ. On every Saturday night, the app becomes atleast 5 times slower. Upon investigation, it is found that the CPU utilization reaches 100% within a matter of seconds instead of being a gradual increment. This is happening due to a batch core dating algorithm update that happens on every Saturday 9PM. 
ChickTok wants a solution that

- Tackles the extra workload
- Avoids downtime
Which of the following would you recommend?
 image

Easy

DROP SUM bar
Solve
What will the following PostgresSQL snippet below output?
 image

Medium

Dynamic Function Calls
Arrays
Strings
Functions
Solve
Consider the following PHP pseudo code:
 image
The processArray function processes the $data array based on the transformation operations defined in the $operations array. The operations array dictates which transformation function to call for each sub-array key. What will be the output of the above code?
 image

Medium

Dynamic Function Invocation
Dynamic Expressions
Array Manipulation
Function Invocation
Solve
You're tasked with dynamically invoking functions based on their names stored in an array. Additionally, you're required to filter out functions that have the term "Admin" in their name. Your colleague suggests the following approach:
 image
Assuming no other functions are defined in the session, which of the following will $results contain after executing the script?

Medium

Dynamic Product API
Schema Evolution
Dynamic Data Types
API Integration
Solve
You're building a Talend job that integrates with an e-commerce platform's Product API. Over time, the platform has added, removed, or changed fields within the API response, making it a challenge to keep up with the schema changes. A typical API response might look like:
 image
However, fields like specs might have additional attributes in the future, or some fields might be deprecated.

The primary goal of your Talend job is:
 image
Given this scenario, how should you best handle the dynamic nature of the Product API schema in your Talend job?
A: Use tExtractJSONFields and adjust the XPath query every time the API changes.
B: Set a fixed schema in tMap based on the most common fields and ignore new additions.
C: Define the input schema of tMap as "Dynamic", and map necessary fields to a stable output schema.
D: Set the tOutputDB schema to "Dynamic" and let the database adjust to incoming changes.
E: Process the raw JSON strings directly in tMap and use string manipulations for transformations.

Medium

Dynamic Sales Cycle Management
Sales Prioritization
Time Management
Customer Engagement
Solve
You are a Sales Director at a dynamic software company, responsible for strategizing client interactions across various stages of the sales cycle. The table below provides detailed insights into six distinct client scenarios. Based on this complex information, determine the most effective order in which to address these clients, balancing the nuances of each case to maximize business growth and client satisfaction.
 image

Easy

Dynamic Selector Integration
Workflow Design
Error Handling
Selector Dynamics
Solve
An RPA developer is tasked with automating a web-based application process that involves dynamically generated IDs for interface elements. The developer decides to use a combination of anchor-based and attribute-based selectors to identify UI elements reliably. Given that the application generates new session IDs for each element upon each login, which of the following methods should the developer use to construct a robust selector strategy? Consider the need for error handling in scenarios where elements are not found.
A: Use wildcard characters in the selector for static attributes and avoid using session IDs.
B: Hardcode the session IDs into the selectors for each element for consistency.
C: Create separate workflows for each session ID and invoke them based on the session.
D: Use regular expression matching in selectors to handle dynamic session IDs.
E: Avoid using selectors and rely solely on image-based recognition for element identification.

Medium

Dynamic vs Static Temp Tables
Temporary tables
Performance optimization
Solve
In Sybase ASE, you're tasked with optimizing some database operations. You come across two types of temporary tables being used: local temporary tables (dynamic) which have names prefixed with a single '#' and global temporary tables (static) which have names prefixed with '##'. Now, consider the following scenarios:

1. You need a table that should be available to all connections and users until the database is restarted.
2. A table that is required to exist only for the duration of a single stored procedure.
3. A table that should store a large amount of data that would benefit from creating indexes.

Which of the following options correctly pairs the type of temporary table (dynamic or static) with the given scenarios?

Medium

Switching to a dynamic website
Solve
Sam has an ecommerce startup. With the recent growth, they are looking to convert the website from a static website to a dynamic website. What are the additional SEO considerations they would have to implement?
A: good internal link structure
B: more keywords for better SEO
C: dynamic XML site generation
D: dynamic image generation 
E: dynamic title and description generation 
F: mobile friendly pages
G: higher page speed

Medium

Earnings Per Share
Solve
Consider the following financial data for 3 companies (in millions) for the year 2022:
 image
Which company has the highest Earnings Per Share (EPS) if each company has 50 million outstanding shares?

Medium

EC2DataProcessing
EC2
S3
Security Groups
Network ACLs
Solve
You work as a Solutions Architect for a data analysis firm. The company stores large datasets on Amazon S3, and you've been tasked with setting up an Amazon EC2 instance to process this data. The EC2 instance will fetch data from S3, process it, and then write the results back to a different S3 bucket.

To ensure security, the EC2 instance should not have direct internet access, and it should only be able to communicate with the S3 buckets. You've decided to place the EC2 instance in a VPC private subnet with a CIDR block of 10.0.1.0/24. The associated security group is set to deny all inbound traffic and allow all outbound traffic.

Which additional configuration should you make to enable the EC2 instance to access the S3 buckets while complying with the security requirements?
A: Modify the Network ACL of the subnet to allow outbound connections to the IP range of the S3 service.
B: Assign a Public IP to the EC2 instance and update the security group to allow inbound and outbound traffic to S3.
C: Add a NAT Gateway in the private subnet and update the route tables to direct S3 traffic to the NAT Gateway.
D: Create an S3 VPC Gateway Endpoint and update the route tables for the private subnet to direct S3 traffic to the VPC Endpoint.
E: Create a VPN connection from the VPC to the S3 buckets.

Medium

Efficient Dockerfile
Dockerfile
Solve
Review the following Dockerfiles that work on two projects (project and project2):
 image
All Docker files have the same end result:

- ‘project’ is cloned from git. After running few commands, ‘project’ code is removed.
- ‘project2’ is copied from file system and permissions to the folder is changed.
Pick the correct statements:

A: File 1 is the most efficient of all.
B: File 2 is the most efficient of all.
C: File 3 is the most efficient of all.
D: File 4 is the most efficient of all.
E: Merging multiple RUN commands into a single RUN command is efficient for ‘project’ since each RUN command creates a new layer with changed files and folders. Deleting files with RUN only marks these files as deleted but does not reclaim disk space. 
F: Copying ‘project2’ files and changing ownership in two separate commands will result in two layers since Docker duplicates all the files twice.

Medium

Amazon electronics product feedback
Solve
Amazon's electronics store division has over the last few months focused on getting customer feedback on their products, and marking them as safe/ unsafe. Their data science team has used decision trees for this. 
The training set has these features: product ID, data, summary of feedback, detailed feedback and a binary safe/unsafe tag. During training, the data science team dropped any feedback records with missing features. The test set has a few records with missing "detailed feedback" field. What would you recommend?
A: Remove the test samples with missing detailed feedback text fields
B: Generate synthetic data to fill in missing fields
C: Use an algorithm that handles missing data better than decision trees
D: Fill in the missing detailed feedback text field with the summary of feedback field.

Medium

Eloquent Relationship Handling
ORM
Relationships
Database Operations
Solve
Consider the following code snippet in a Laravel application:
 image
Assume the user 'John Doe' is the first user in the User table. You want to retrieve all comments belonging to a post made by this user ('John Doe'). Which of the following Eloquent expressions is the correct way to achieve this?
 image

Medium

Email Marketing Campaign Analysis
Conversion Rates
A/B Testing
Solve
You are analyzing the results of an A/B testing campaign for a newly launched line of eco-friendly activewear. The goal was to determine which of two email marketing strategies resulted in higher engagement and sales. Strategy A focused on discount offers, while Strategy B emphasized the eco-friendly attributes of the clothing line. The campaign ran for one month, targeting a segmented list of 50,000 subscribers, split evenly between the two strategies. The following data was collected:

- Strategy A (Discount Offers):
    - Emails sent: 25,000
    - Open rate: 22%
    - Click-through rate (CTR): 5%
    - Conversion rate: 0.5%
    - Unsubscribe rate: 2%
- Strategy B (Eco-Friendly Attributes):
    - Emails sent: 25,000
    - Open rate: 18%
    - Click-through rate (CTR): 4%
    - Conversion rate: 1%
    - Unsubscribe rate: 1.5%

Based on the data, which strategy should be prioritized for future email marketing campaigns to maximize sales and engagement, considering both effectiveness and audience retention?
A: Strategy A should be prioritized due to its higher open and click-through rates, indicating better initial engagement.
B: Strategy B should be prioritized because of its higher conversion rate, despite lower open and click-through rates, suggesting stronger sales impact.
C: Strategy A should be optimized for a lower unsubscribe rate before it can be considered for future campaigns.
D: Strategy B's lower unsubscribe rate indicates better audience retention and should be the focus, despite lower engagement metrics.

Medium

Email Review
Communication
Proofreading
Solve
You are an executive assistant tasked with proofreading an email before it's sent to a potential client. Here's the draft:
 image
Which of the following corrections should be made to this email?
A: Change "apprecaite" to "appreciate"
B: Change "optimizes" to "optimize"
C: Change "hesistate" to "hesitate"
D: Changes A and B
E: Changes B and C
F: Changes C and A
G: Changes A, B and C
H: No changes necessary

Medium

Emma's cafe business
Solve
Emma's cafe has been operating successfully for the last 6 years. Profits have been growing every year, with this year (2020) being their best year so far. As a thank you, Emma treated her staff to a meal at a Michelin star restaurant. 
 image
Below are 3 statements about Emma, her staff and her cafe. Can you help us decide whether the 3 statements are "True", "Probably True", "Insufficient Data to Say True or False", "Probably False", or "False".

1. Emma's staff members are happy.
2. Emma's cafe did well in 2016.
3. Emma is rich.

A: True
B: False
C: Probably True
D: Probably False
E: Insufficient Data

Medium

MS SQL: enterpriseDB, GROUP BY
Solve
The following T-SQL statements are run on enterpriseDB database:
 image
uamMembers with MemberPaid as 1 implies that the member payment is complete. We want to find number of paid users for each uamGroup. (If a uamGroup does not have any paid members, we want to have 0 as paid members count). Of the following T-SQL statements, what should we run to achieve this?
 image

Medium

Error Budget Management
Latency Monitoring
Error Budgets
Distributed Tracing
Solve
You are a site reliability engineer responsible for maintaining a microservices-based e-commerce platform. Your system consists of several independent services, each deployed on its separate container within a Kubernetes cluster.

Your organization follows a strict Service Level Objective (SLO) to maintain user satisfaction, which mandates that the 95th percentile latency for all requests over a 30-day period should not exceed 200 ms.

The following pseudo-code represents a simplified version of the request processing in your system:
 image
You realize that over the first two weeks of the current 30-day window, the 95th percentile latency has risen to 250 ms. Analyzing further, you discover that out of 10 million requests, 600,000 requests took more than 200 ms to complete.

Given these facts, which of the following is the most effective course of action that you can take to troubleshoot and reduce the system's latency issues?
A: Change the latency log level to debug to gather more information.
B: Increase the SLO for latency to 250 ms to accommodate the current system performance.
C: Introduce more instances of each microservice to handle the increased load.
D: Implement a distributed tracing mechanism to identify the microservices contributing most to the latency.
E: Implement request throttling to reduce the overall number of requests.

Medium

Error Handling with Try-Catch-Finally
Error Handling
Exceptions
Script Flow
Solve
You're analyzing a script designed to interact with a remote API. The script fetches data, processes it, and then ensures that all temporary files are deleted. You come across the following code block:
 image
After a successful data fetch, the script occasionally throws the custom error. When this happens, what will be the output and state of the system?
A: The output will display "Network error
B: The output will display "General error
C: The script will exit without any output due to the custom error, but the temporary file will be deleted.
D: The output will display "General error
E: The script will terminate prematurely, not executing the finally block.

Medium

Evaluating Sales Strategies
Sales Communication
Market Positioning
Pricing Strategy
Solve
You are a sales executive at TechNovate, a company specializing in cloud-based CRM solutions. Your product, CloudCRM, is known for its advanced analytics and user-friendly interface. The pricing structure for CloudCRM is as follows: A base fee of $10,000, plus $300 per user for the first 200 users, and $150 for each additional user beyond 200. You are tasked with drafting a proposal for a potential client, XYZ Corp, a mid-sized retail company looking to improve customer relationship management. XYZ Corp has 600 employees, out of which 400 need access to the CRM. They currently use a competitor's product priced at $8,000 base fee and $230 per user without any tiered pricing.

Given this scenario, which of the following statements should be included in your proposal to effectively communicate the value of CloudCRM to XYZ Corp?
A: "Our tiered pricing model will be particularly cost-effective for your company, as it will reduce the cost per user for your large team."
B: "Switching to CloudCRM will save you money immediately, as our base fee is lower than your current provider."
C: "Our advanced analytics features are unique in the market and will provide insights that your current CRM cannot."
D: "XYZ Corp will benefit from our exclusive partnership with leading retail analytics firms making out offering cheapest in the market"
E: "Given your company's size, our flat-rate pricing model will ensure that you do not incur any unexpected costs."

Medium

Exchange Rate Fluctuations
Invoice Management
Solve
Your organization, headquartered in the US, frequently engages in intercompany transactions with a subsidiary in Europe. At the beginning of the month, a purchase order of €500,000 was made from the subsidiary. The initial exchange rate was 1 EUR = 1.20 USD. However, by the time of invoice payment, the exchange rate had changed to 1 EUR = 1.15 USD.

Considering your organization's payment term is Net 30 days with a 2% early payment discount if paid within 15 days and the payment was made on the 12th day, calculate the USD amount saved due to both early payment and the change in exchange rate.

Medium

Execution Order and Handlers
Task Execution
Handlers
Error Handling
Solve
Analyze the following Ansible playbook, which is designed to set up and verify a web server. Determine the correct order of task execution, including the handler invocation:
 image
In what order will the tasks and handlers be executed?
A: Install web server, Start web server, Verify web server, Notify failure, Restart web server (if notified)
B: Install web server, Start web server, Restart web server (if notified), Verify web server, Notify failure (if failed)
C: Install web server, Restart web server (if notified), Start web server, Verify web server, Notify failure (if failed)
D: Install web server, Start web server, Verify web server, Notify failure (if failed), Restart web server (if notified)
E: Install web server, Verify web server, Start web server, Restart web server (if notified), Notify failure (if failed)
F: Install web server, Start web server, Verify web server (if previous task failed), Notify failure, Restart web server (if notified)

Medium

Execution Order and Return Codes
Job Control
Execution Order
Return Codes
Solve
Consider a JCL job that needs to execute five steps: STEP01, STEP02, STEP03, STEP04, and STEP05. The steps represent data initialization, data processing, data validation, error handling, and job finalization respectively.

The execution rules are as follows:

1. The job should always start with STEP01.
2. STEP02 should only execute if STEP01 completes successfully with a return code (RC) of 0.
3. STEP03 should always run after STEP02, irrespective of STEP02's return code.
4. STEP04 should only execute if either STEP02 or STEP03 fails, i.e., return a code not equal to 0.
5. STEP05 should always be the last step, and should only execute if all the previous steps were successful (each returning a code of 0).

Given these rules, how would you design the JCL job using the IF/THEN/ELSE/ENDIF construct?
 image

Hard

Execution Policy Bypass
Execution Policy
Security
Script Invocation
Solve
A server you are working on has the PowerShell execution policy set to "Restricted", preventing scripts from running. You need to execute a script named "Deploy.ps1". You recall a technique to bypass the execution policy without changing it permanently. Which of the following methods would allow you to run "Deploy.ps1" without permanently altering the execution policy?
A: Set-ExecutionPolicy Unrestricted -Scope Process; .\Deploy.ps1
B: PowerShell -ExecutionPolicy Bypass -File .\Deploy.ps1
C: Invoke-Command -ScriptBlock { .\Deploy.ps1 }
D: Start-Process PowerShell -ArgumentList "-ExecutionPolicy Unrestricted", "-File .\Deploy.ps1"
E: Import-Module .\Deploy.ps1

Medium

Extended Incentives
Behavioral Segmentation
Incentive Strategy
Email Conversion Optimization
Solve
An online boutique is refining its email marketing strategy to enhance conversion rates through behavioral segmentation and tailored incentives. The growth marketer identifies four key customer segments based on their interaction with the boutique's website:

1. High-Interest Browsers (HIB): Users engaged with multiple product pages and spending over 4 minutes on average per visit.
2. Wishlist Enthusiasts (WE): Users who add several items to their wishlist but historically have a purchase conversion rate of less than 2%.
3. Shopping Cart Abandoners (SCA): Users who add products to their cart but leave the site without completing the transaction.
4. New Visitors (NV): Recently signed-up users with minimal browsing activity and no purchase history.

To address the distinct behaviors and potential hesitations of each segment, the marketer designs targeted email campaigns with specific incentives:

- HIB Campaign: Exclusive access to a preview of an upcoming product line.
- WE Campaign: A 15% discount on wishlist items, valid for 15 days.
- SCA Campaign: A 10% discount plus free shipping for cart items, valid for 24 hours.
- NV Campaign: A 5% welcome discount on the first purchase.

Given the tailored nature of these incentives and assuming uniform email open rates across segments, which segment's targeted campaign is expected to deliver the highest incremental increase in conversion rates, taking into account the incentive's alignment with the segment's behavior and conversion barriers?

Medium

Extended Research Timeline
Budget Adjustment
Resource Allocation
Project Scheduling
Solve
You are tasked with adjusting the budget for a year-long research project that involves three sequential phases:

1. The Initial Research (IR) phase has an allocated annual budget of $200,000. By the end of the first quarter, $80,000 has already been spent.
2. The Data Analysis (DA) phase is scheduled to begin after the completion of the IR phase, with a planned quarterly budget of $50,000.
3. The Final Reporting (FR) phase, which follows the DA phase, has a fixed budget of $100,000, irrespective of its duration.

The project encounters a few changes:

1. The IR phase is projected to need an additional $20,000 for each of the remaining three quarters due to increased research complexity.
2. The DA phase is anticipated to extend into an additional quarter, meaning it will now take three quarters instead of the initially planned two.
3. The FR phase will not incur any additional costs and will not be affected by the DA phase extension.

Calculate the additional budget required by the end of the project in light of these changes.

Medium

External Bank Transfer
Database Transactions
Solve
Review the following Django code for a banking application:
 image
The code needs to debit an account with the provided amount and deposit the amount in an external entity. Here’s how the code is broken:

1) First, the amount is debited from the account by creating a new row in BalanceLine table.
2) Next, a new row is created in the DB in ExternalTransfer table and a new id (used as unique reference) is created for the transfer.
3) An external 3rd party API call is made using the new id created in step 2.

The function transfer_to_other_bank is called as shown below:
 image
Pick the correct statements:

A: If post_transfer_emails() raises an exception, the database transactions that happened in transfer_to_other_bank are not rolled back since they are listed in a separate atomic transaction.
B: If post_transfer_emails() raises an exception, the database transactions (new rows in ExternalTransfer and BalanceLine tables) are rolled back. The banking_api call is called again with a null reference.
C: If post_transfer_emails() raises an exception, the database transactions are rolled back but the banking_api is not called again.
D: If post_transfer_emails() raises an exception, the banking_api is called again with rollback=True. If the response is success, then the database transactions are rolled back. If the response is failure, the database transactions are committed.

Medium

Fair Scheduler
Informatica BDM
Solve
You have a Hadoop cluster running with the fair Scheduler enabled. There are currently no jobs running on the cluster, and you submit a job A, so that only job A is running on the cluster. A while later, you submit Job B. Now Job A and Job B are running on the cluster at the same time. How will the Fair Scheduler handle these two jobs?
 image

Medium

Fallback Error
Error Boundaries
Solve
Review the following React Native Code:
 image
We have two ErrorBoundary classes. Notice that both MyComponent and ErrorBoundaryOne throw errors. What ‘Text’ would be rendered in the screen?

Medium

Functions and arguments
Fallback functions
Solve
Review the following Solidity code:
 image
We want to add a fallback function to the contract. Pick the correct fallback function and correct statements:
 image
E: Fallback function is executed if contract receives plain Ether without any data
F: Fallback function is executed if caller calls a function that is not available
G: If multiple unnamed functions are defined for a contract, the cheapest function is used as fallback function

Easy

Registration Queue
Logic
Queues
Solve
We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount.
For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition.
⚠️⚠️⚠️ Note:
- The first line of the input is the length of the array. The second line contains all the elements of the array.
- The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function.
- You need to "print" the final result (not return it) to pass the test cases.

For the example discussed above, the input will be:
5
20 70 -40 30 -10

Your code needs to print the following to the standard output:
20 70 30 -40 -10

Hard

Fibonacci codes
Time Complexity
Pseudo Code
Solve
Here are three pseudocodes for calculating the Nth Fibonacci number. Which of the following statements about these codes are true?
 image
A: Time complexity/efficiency of CODE 1, CODE 2, CODE 3 is the same.
B: CODE 2 is more space-efficient than CODE 3.
C: CODE 3 is more space-efficient than CODE 2.
D: CODE 2 is more time-efficient than CODE 1.
E: CODE 3 is more time-efficient than CODE 1.

Easy

File Structure and Navigation
Files
Basic Commands
Solve
Consider the following directory structure:
 image
You start at /home/user and execute the following commands:
 image
What will be the resulting directory structure?
 image

Medium

File system director
Spark Scala API
Spark Streaming
Solve
Review the following Spark job description:

1. Monitor file system director for new files. 
2. For new files created in the “/rambo” dictionary, perform word count.

Which of the following snippets would achieve this?
 image

Medium

Fin copied over data
Data entry
Solve
Fin copied the data from a printed sheet to the computer to upload to our server. How many attributes did they make an error in copying?
 image

Medium

Finance Integration
Data Entities
Security Roles
Ledger Setup
Solve
You are a Dynamics 365 Finance consultant at a large multinational corporation. The company is implementing a new subsidiary and has the following requirements:

1. They need to import legacy data from the subsidiary's previous ERP system.
2. The CFO of the new subsidiary needs to have access to high-level financial reports but should not have access to employee-specific salary details.
3. The subsidiary operates in a country with a specific requirement to maintain dual ledgers: one standard and one adjusted, with periodic reconciliations.

Given these requirements:

Which of the following steps and configurations in Dynamics 365 Finance would BEST meet the company's needs?
A: Use Data Management workspace for data import, assign the CFO the "Chief Financial Officer" security role, and set up an additional ledger with Ledger Setup.
B: Import data using Excel Add-in, assign the CFO a custom role with restricted HR access, and utilize dual-currency features in Ledger Setup.
C: Use the Data Management workspace with relevant data entities for import, provide the CFO with the "Financial Reporter" role and limit HR data access, and set up a secondary ledger in Ledger Setup for the adjusted ledger.
D: Use RapidStart services for data import, provide the CFO with only "General Ledger Manager" access, and set up the subsidiary as a separate legal entity.
E: Directly use SQL Server Integration Services for data import, assign all financial roles to the CFO, and maintain dual ledgers manually through journal entries.

Medium

Finance Ledger Integration
Ledger Management
Financial Reporting
Data Entities
Solve
You are a Dynamics 365 Finance Functional Consultant tasked with integrating an external system's financial data into Dynamics 365 Finance. The external system provides data in a comma-separated values (CSV) format. You need to ensure that the data from the external system can be integrated into the General Ledger in Dynamics 365 Finance, and then used for financial reporting. Which sequence of actions should you perform to accomplish this task?

A: Create a new data entity for the CSV format, import the data into the General Ledger, then generate financial reports.

B: Directly import the CSV into the General Ledger, then generate financial reports.

C: Convert the CSV format into a data package, import the data into the General Ledger through the Data Management framework, then generate financial reports.

D: Import the CSV into the General Ledger, map the data fields using the Data Management framework, then generate financial reports.

E: Use the Financial Reporting framework to import the CSV, then generate financial reports directly.
A: Create a new data entity for the CSV format, import the data into the General Ledger, then generate financial reports.
B: undefined
C: Directly import the CSV into the General Ledger, then generate financial reports.
D: undefined
E: Convert the CSV format into a data package, import the data into the General Ledger through the Data Management framework, then generate financial reports.
F: undefined
G: Import the CSV into the General Ledger, map the data fields using the Data Management framework, then generate financial reports.
H: undefined
I: Use the Financial Reporting framework to import the CSV, then generate financial reports directly.

Medium

Firestore Subcollections
Solve
We want to create a Firestore collection as follows: Collection to be called rooms and for every document in rooms, there should be a subcollection called messages. Here's schema that we wish to achieve:
 image
Which of the following statements are true?

A: Collections cannot exist inside documents
B: Collections can exist inside documents as subcollections
C: When a document is deleted, subcollections within the document are automatically deleted
D: When a document is deleted, subcollections are not deleted and has to be deleted manually

Easy

Flex
Solve
What is the best way to create following React Native layout with containers 1,2,3?
 image
 image

Easy

Floating points
Solve
Check the following Jest tests:
 image
Which of the tests will pass?

Medium

Focus Group and Interview Data
Focus Groups
Interview Techniques
Consumer Behavior
Solve
A market research firm conducted a study to understand consumer preferences for eco-friendly packaging. The study involved two primary methods: focus groups and individual interviews. The participants were divided into two age groups: 18-35 years and 36-55 years. Key insights include:

Focus Group Data:
- 18-35 years: Expressed a strong preference for minimalistic eco-friendly packaging, citing environmental concerns. 60% were willing to pay more for such packaging.
- 36-55 years: Showed a moderate preference for eco-friendly packaging but placed higher importance on packaging durability and functionality.

Interview Data:
- 18-35 years: 70% indicated that brand image aligned with environmental sustainability influenced their purchasing decisions.
- 36-55 years: 50% stated that while eco-friendly packaging is a plus, it's not a primary factor in their purchasing decisions.

Additional Observations:
- Both age groups expressed that clear labeling indicating eco-friendliness was crucial.
- The 18-35 age group showed more engagement and enthusiasm during discussions about environmental impact.

Based on this data, the research firm is considering several conclusions about consumer preferences and behaviors. Identify the conclusion that is most supported by the combined focus group and interview findings.
A: All age groups prioritize eco-friendly packaging equally.
B: The 18-35 age group is more influenced by environmental sustainability in their purchasing decisions than the 36-55 age group.
C: Durability and functionality are the primary concerns for all consumers when it comes to packaging.
D: Price is a significant barrier to the adoption of eco-friendly packaging in both age groups.
E: Clear labeling of eco-friendliness is only important to the 18-35 age group.
F: Brand image is not a significant factor in purchasing decisions related to packaging.

Medium

Fork mellow yellow
Solve
How many times will the following code will print "Mellow Yellow"?
 image

Medium

Form Logs
Forms
Solve
A web app for a popular AI conference (conducted in New York, with attendees from around the world) uses a signup/login page before users can access their dashboard. The signup/login page uses a form for users to input details and submit. The details are then sent to the backend service for processing. All user actions are logged in a log server. Senior Frontend Engineer, Musk, observed patterns in the issues users are facing with the the web app. Here are the two common patterns that Musk observed in the issues that have been occurring for most users:
 image
 image
Which of the following should Musk do to enhance the user experience with the page?

A: Implement validation using JS event listeners on client-side (e.g., on input or change)
B: Utilize HTML5 built-in form validation attributes (e.g., required, pattern)
C: Use server-side validation and refresh the page on form submission
D: Use a serverless function that processes the user’s form details, saves the user’s entries in the database and responds with validation data

Medium

Four Blocks
Direction sense
Logical movement
Solve
The city has been divided into 4 blocks. Block 1 in the north and Block 4 in the east of the city.
 image
A postman, who delivers the letter in the city is standing at the intersection of the two lines. The postman travels the city in the following order:

1. North-West 20 steps
2. South-West 30 steps
3. South-East 40 steps
4. North-East 50 steps
5. North-West 15 steps 
Now, find the location where the postman is standing?
A: Block 3
B: Block 2
C: Block 4
D: Block 1
E: On the line intersecting Block 1 and Block 4
F: On the line intersecting Block 3 and Block 4

Easy

Fraud detection model
Logistic Regression
Solve
Your friend T-Rex is working on a logistic regression model for a bank, for a fraud detection usecase. The accuracy of the model is 98%. T-Rex's manager's concern is that 85% of fraud cases are not being recognized by the model. Which of the following will surely help the model recognize more than 15% of fraud cases?

Medium

French Test
Question and Response
Solve
Listen to the following audio:

You will hear a question or a statement. After you hear a question or a statement, choose the best response:

Easy

Frequency distribution
Solve
Convert the following into an ordinary frequency distribution:

- 5 users gave less than 3 rating
- 12 users gave less than 6 rating
- 25 users gave less than 9 ratings
- 33 users get less than 12 ratings
 image

Medium

Email on Friday evening
Solve
Emily spent the entire week at a client's site as part of the accounting team. Emily is just about to leave for the weekend, when she notices that there is an email from another small, but growing client that they have been working closely for the past 3 months. Emily has a good professional relationship with Rebecca, who sent the email. Rebecca has a question, which she needs an urgent response to. Answering the question in detail will require Emily to access a number of files in her own office. What should Emily do first?
A: Reply immediately that she needs more information before she can respond in detail, and that she will do it first thing on Monday morning.

B: Rebecca will have gotten an out of office (OOO) response, so she can leave it for now and respond first thing on Monday morning.

C: Call Rebecca to find out by when they need the information. If they need it right away, Emily can go to office, give the required details and provide a more detailed response on Monday.

D: Reply to the email immediately, based on the information Emily has already and assure Rebecca that she will double check and send over a more detailed response first thing on Monday.

Medium

git commit without git add
Solve
Suppose a remote repository is cloned in local system and a old file named “modified_file” is modified and now if following command is run, what will "git status" return?
 image
 image

Medium

Global Query Filters
Global Query Filters
Soft Delete
Solve
In an Entity Framework Core project, you're working on an e-commerce application where products can be 'soft deleted'. A soft deleted product is not physically removed from the database, but is flagged as deleted and should not appear in normal query results. Assume that your Product model includes an IsDeleted boolean property.

Your task is to implement a global query filter to exclude soft deleted products from all queries throughout the application.

Which of the following is the correct way to implement this requirement in your DbContext derived class, ProductContext?
 image

Medium

Go Maps
Maps
Solve
Which of the following statements are true regarding the order of output for following Go code:
 image
A. Output will be ordered by values
B. Output will be ordered by keys
C. Output will be ordered randomly
D. Output will be ordered by position in the code

Medium

File Handling and Defer
File Handling
Solve
Consider the following Go code. Where should we use *defer*?
 image

Easy

Go WaitGroup
Concurrency
Solve
What does the following Go code output?
 image

Medium

Grade-Division-Points
Spark Scala API
DataFrame
Solve
Consider the following Spark DataFrame:
 image
Which of the given code fragments produce the following result:
 image
 image

Easy

Gradient descent optimization
Gradient Descent
Solve
You are working on a regression problem using a simple neural network. You want to optimize the model's weights using gradient descent with different learning rate schedules. Consider the following pseudo code for training the neural network:
 image
Which of the following learning rate schedules would most likely result in the fastest convergence without overshooting the optimal weights?

A: Constant learning rate of 0.01
B: Exponential decay with initial learning rate of 0.1 and decay rate of 0.99
C: Exponential decay with initial learning rate of 0.01 and decay rate of 0.99
D: Step decay with initial learning rate of 0.1 and decay rate of 0.5 every 100 epochs
E: Step decay with initial learning rate of 0.01 and decay rate of 0.5 every 100 epochs
F: Constant learning rate of 0.1

Hard

Graph Traversal and Data Storage
Graph Theory
Algorithm Analysis
Solve
Consider the following pseudo code implementing a specific graph traversal algorithm:
 image
What is the order in which the nodes are processed, and which data structure best represents the graph `G` for efficient traversal?

Medium

Handling Disruption in Supply Chain Management
Supply Chain Management
Risk Mitigation
Strategic Planning
Solve
You are the Head of Supply Chain for a large automobile manufacturer. Your supply chain is highly globalized, with key components sourced from various international suppliers. Recently, a significant geopolitical event has caused disruption to the supply of a critical component sourced from a particular region, causing production delays. You need to quickly resolve this issue while also planning for future disruptions. How should you approach this situation?
A: Find a local supplier for the critical component, regardless of cost and quality.
B: Stockpile components to mitigate future disruptions.
C: Invest in developing the component in-house, regardless of the time and resources it may take.
D: Lobby with government bodies to prioritize your company's needs.
E: Seek alternative international suppliers, renegotiate contracts with a risk mitigation clause, and invest in dual sourcing for critical components.
F: Shift the burden to the production department to figure out how to handle the component shortage.
G: Initiate legal action against the current supplier for not fulfilling their contract.

Medium

Handling Dynamic Elements
Multiple Iframes
Dynamic Element Handling
Solve
You are automating a test for a webpage that contains multiple iframes. One of these iframes contains a button with a dynamic ID that always contains the substring "btn". Upon clicking this button, a text box appears within the same iframe, having a dynamic ID containing the substring "txtBox". You have to input text into this text box. The correct iframe does not have any unique identifiable attribute.

Below is the simplified pseudo code to illustrate your initial setup:
 image
How should you modify your code to perform these operations efficiently, ensuring reliable element location and interaction among multiple iframes?
 image

Easy

Handling Missing Data
Data Cleaning
Missing Data
Solve
You are working with a dataset, `df`, that contains several columns with missing values. You want to replace all missing values in the dataset with the mean of the non-missing values of their respective columns.

You wrote the following code to perform this task:
 image
However, you notice that some missing values are still not replaced. What is the cause of this issue?
A: The fillna method does not work with the mean method.
B: The mean method does not work with missing values.
C: The fillna method should be called on df.mean() instead of df.
D: The fillna method does not work inplace by default. You should use df.fillna(df.mean(), inplace=True).
E: The mean method should be called on df.fillna() instead of df.

Medium

Handling Mouse Actions
Keyboard and Mouse Actions
Solve
You are automating a test case where a user has to hover over an image, causing a tooltip to appear. After the tooltip appears, the user has to right-click on the tooltip to see a context menu. You have to validate that the context menu appears correctly. The tooltip has an ID of tooltip and the context menu has an ID of contextMenu.

Given the below pseudo code for the page:
 image
Which of the following Selenium Python code snippets should be used to perform the above-described actions and validations?
 image

Easy

Handling Multiple Windows
Window Handles
Switching Windows
Solve
You are working with Selenium to automate a test case where clicking a button on a webpage (http://example.com) opens a new window. You have to perform operations in the new window and then return to the original window. Below is a simplified version of your initial code:
 image
After clicking the button, a new window opens, and you need to input text into a text box in the new window with id="textBox". Afterwards, you need to close this new window and click another button in the original window with id="originalWindowButton".

How should you modify your code to handle the multiple windows and perform the necessary operations?
 image

Medium

Handling Push Notifications
Push Notifications
Application State
Solve
In a Flutter application, you are using the firebase_messaging package to handle incoming FCM (Firebase Cloud Messaging) push notifications. Consider the pseudocode below:
 image
In the _handleNotification method, the application is supposed to navigate to a details page if the action key in the notification data is equal to 'navigate'. However, this might not work as expected if the app is in the background or terminated state when the notification is received and the user clicked on it.

How would you modify the _handleNotification method or handle the onMessage event to ensure that the navigation occurs when the user taps on the notification to open the app, no matter what state the app is in when the notification is received?
A: Use _firebaseMessaging.onMessageOpenedApp to handle navigation when the user taps the notification to open the app.
B: Use _firebaseMessaging.onLaunch to handle the navigation when the user taps the notification.
C: Check the message.messageType and navigate only if it is 'opened'.
D: Use _firebaseMessaging.onBackgroundMessage for handling navigation when the app is in the background.
E: Use a GlobalKey<NavigatorState> to handle navigation in _handleNotification.

Medium

Hate Speech Detection Challenge
Text Classification
Data Imbalance
Solve
You are working on a project to detect hate speech in social media posts. Your initial model, a basic binary classification model, has achieved high accuracy during training, but it's not performing well on the validation set. You also notice that your dataset has significantly more non-hate-speech examples than hate-speech examples. Given this situation, which of the following strategies could likely improve the performance of your model?
A: Collect more data and retrain the model.
B: Introduce data augmentation techniques specifically for hate-speech examples.
C: Change the model architecture from binary classification to multi-class classification.
D: Replace all the words in the posts with their synonyms to increase the diversity of the data.
E: Remove the non-hate-speech examples from the dataset to focus on the hate-speech examples.

Medium

Health Report Scrutiny
Data Analysis
Solve
You are a public health officer reviewing a report on a recent outbreak of a rare disease in a small town. The report includes the following data:

- The outbreak started on June 1, 2023.
- The peak of the outbreak occurred in mid-July, with over 100 new cases daily.
- The outbreak was controlled by early August 2023.
- A total of 1,250 cases were reported.

However, in the section on patient demographics, the report states, "Of the 1,350 patients affected, 65% were adults (18-64), 20% were seniors (65 and above), and 15% were children (below 18)."

What is the discrepancy in the report?
A: The timeline of the outbreak is inconsistent.
B: The peak of the outbreak is misstated.
C: The total number of reported cases doesn't match with the patient demographics data.
D: The age groups for the demographics are incorrect.
E: No discrepancy was found in the report.

Easy

Healthcare System
Data Integrity
Normalization
Referential Integrity
Solve
You are designing a data model for a healthcare system with the following requirements:
 image
A: A separate table for each entity with foreign keys as specified, and a DoctorPatient table linking Doctors to Patients.
B: A separate table for each entity with foreign keys as specified, without additional tables.
C: A combined PatientDoctor table replacing Patient and Doctor, and separate tables for Appointment and Prescription.
D: A separate table for each entity with foreign keys, and a PatientPrescription table to track prescriptions directly linked to patients.
E: A single table combining Patient, Doctor, Appointment, and Prescription into one.
F: A separate table for each entity with foreign keys as specified, and an AppointmentDetails table linking Appointments to Prescriptions.

Medium

Healthy Replica
Google Kubernetes Engine
Solve
Sam Sankman works as Cloud Associate at FTXX Inc. FTXX’s core application is deployed in a Google Kubernetes Engine cluster. When a new version of the application is released, CI/CD tool updates the spec.template.spec.containers[0].image value to reference the Docker image of the new application version. When the Deployment object applies the change, Sam wants to deploy at least 1 replica of the new version and maintain the previous replicas until the new replica is healthy. Which change should Sam make to the Kubernetes Engine Deployment object shown below?
 image
A: Set the Deployment Strategy to Rolling Update
B: Set the Deployment Strategy to Recreate

C: Set maxSurge to 0
D: Set maxSurge to 1

E: Set maxUnavailable to 0
F: Set maxUnavailable to 1

Medium

EntityManager
Solve
Here's a way to insert 100,000 entries into Hibernate:
 image
Which of the following statements are true about this implementation?
A: The code might fail with OutOfMemoryException
B: Long running transactions can deplete connection pool
C: Every insert statement requires a database roundtrip

Medium

Hiring Developer
Skewed Data
Graph
Solve
Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. 
 image
 image
Now select the statements that are true based on the given details.

A: The data given for Company A is skewed to the left.
B: The data given for Company B is skewed to the right.
C: The data given for Company A is skewed to the right.
D: For Company B, mean and mode are equal.
E: For Company B, mean is equal to median but less than mode.
F: For Company A, median is less than mode but greater than mean.

Medium

Hive Archive
Solve
You have a partitioned Hive table sales_data with the following schema:
 image
You want to archive the oldest partition (date='2023-01-01', region='North America') and store it in the Hadoop Distributed File System (HDFS) at /archive/sales_data. Which of the following steps is the correct approach to perform the archiving operation?
A: Enable archiving on the table, and then issue an ALTER TABLE statement to move the partition to the archive directory.

B: Issue an ALTER TABLE statement to move the partition to the archive directory, and then lock the partition to prevent further modifications.

C: Enable archiving on the table, and then use the EXPORT command to export the partition to the archive directory.

D: Use the EXPORT command to export the partition to the archive directory, and then lock the partition to prevent further modifications.

E: Use the EXPORT command to export the partition to the archive directory, and then drop the partition from the sales_data table.

Medium

Hive ngrams
Solve
Assuming the following Hive statements execute successfully, choose the correct statements that describe the result:

from fooddata select context_ngrams(sentences(lines),
array("twiggy", "romato", null), 68);

A. A bigram of the top 68 sentences that contain the substring "twiggy romato" in the lines column of the input data A1 table.
B. An 68-value ngram of sentences that contain the words "twiggy" or "romato" in the lines column of the fooddata table.
C. A trigram of the top 68 sentences that contain "twiggy romato" followed by a null space in the lines column of the fooddata table.
D. A frequency distribution of the top 68 words that follow the subsequence "twiggy romato" in the lines column of the fooddata table.

Hard

Holding References
Solve
What does the following Java code output?
 image

Medium

Home and Details Screen
Navigation
Solve
Review the following React Native code:
 image
The app has two screens (Home and Details) as shown below:
 image
 image
Review the following tests:

Test 1 - Click on ‘Navigate.navigate(’Details’)’ button on Home screen, then the same button on the Details screen. Then click on the “back” button of the device/screen.

Test 2 - Click on ‘Navigate.push(’Details’)’ button on Home screen, then the same button on the Details screen. Then we clicked on the “back” button of the device/screen.

Test 3 -  Click on ‘Navigate.navigate(’Details’)’ button on Home screen, then ‘Navigate.push(’Details’)’ button on the Details screen. Then click on the “back” button of the device/ screen.

Test 4 -  Click on ‘Navigate.push(’Details’)’ button on Home screen, then ‘Navigate.navigate(’Details’)’ button on the Details screen. Then click on the “back” button of the device/ screen.
Pick the correct statements:

Medium

Homeopathy
Solve
Two main axioms constitute the core principles of homeopathy. The "like cures like" principle holds that, if a substance causes a symptom (e.g. onion makes my nose run), then that substance can cure a disease that is characterised by a runny nose (e.g. hayfever or a common cold). The second principle assumes that the serial dilution process used for homeopathic remedies renders them not less but more potent (hence homeopaths call this process "potentiation").

Both of these axioms fly in the face of science. If they were true, much of what we learned in physics and chemistry would be wrong. If anyone shows the concepts of homeopathy to be correct, he or she becomes a serious contender for one or two Nobel prizes. Homeopaths often say that we simply have not yet discovered how homeopathy works. The truth is that we know there is no conceivable scientific explanation that could possibly explain it.

Which of the following options is not a possible conclusion based on the above passage?

Medium

Homepage Layout Optimization
A/B Testing
Decision Making
Conversion Rate Analysis
Solve
An e-commerce platform specializing in sustainable outdoor gear is conducting an A/B test to optimize its homepage layout with the goal of increasing overall conversion rates. The test compares two different designs:

- Layout A focuses on showcasing best-selling products with a simple, clean design aesthetic.
- Layout B emphasizes customer reviews and sustainability credentials of the products in a more detailed layout.

Over a testing period of 30 days, both layouts are exposed to an equal number of visitors, with 60,000 visits directed to each version. At the end of the testing period, Layout A resulted in 3,600 conversions, while Layout B resulted in 4,200 conversions. The growth marketer aims to analyze these results to determine which layout should be adopted based on the test's outcome.

Given the results, what should be the marketer's next steps in deciding whether the observed difference in conversion rates between Layout A and Layout B justifies a full rollout of Layout B? 
A: Immediately implement Layout B across the site, as the higher number of conversions indicates clear superiority.
B: Conduct a follow-up test focusing on specific elements within Layout B to identify which factors contributed most significantly to the higher conversion rate.
C: Calculate the statistical significance of the conversion rate difference before making any changes to ensure the results are not due to random chance.
D: Roll back to Layout A, considering the potential risk and cost of changing the entire site layout based on a single test.

Medium

Hooks with Conditional Rendering
Hooks
Conditional Rendering
Event Handling
Solve
Consider a React functional component that utilizes various hooks and conditional rendering. The component is designed to fetch and display a list of items from an API, with the ability to filter the list based on user input. Here's the pseudo-code structure:
 image
In this component, which of the following is a potential issue or inefficiency?
A: The component will re-render excessively due to the `setFilter` call.
B: The `useEffect` hook will run on every render, causing performance issues.
C: The `fetchItems` function may cause a memory leak if the component unmounts during the fetch.
D: The `useMemo` hook for `filteredItems` is unnecessary and can be removed without impact.
E: The component will fail to display items when the filter is cleared.
F: There are no significant issues; the component is implemented optimally.

Easy

Links
Solve
In the following HTML, what will be the color of link with class "mark"
 image

Medium

Human resources department
Grammar & Vocabulary
Solve
Lea el texto e introduzca el conector discursivo que tenga más sentido en la oración.
El departamento de recursos humanos es fundamental para gestionar el talento dentro de una empresa. Entre sus actividades están: En primer lugar, reclutar a nuevos empleados y una vez contratados se encarga de su formación y desarrollo profesional. ______________ gestiona las relaciones laborales y resuelve cualquier conflicto que pueda surgir.
A: Sin embargo.
B: Pero
C: Claro
D: Además
E: Por lo tanto
F: Nunca

Easy

Identifying Complete Sentences
Complete Sentences
Solve
Which of the following is a complete sentence?
A: Because the weather was nice.
B: The book on the table.
C: My friend and I went to the movies.
D: After finishing my homework.
E: The cat sleeping on the couch.
F: Whenever I go to the park.

Easy

Identifying Fake Reviews
Text Classification
Solve
You are a data scientist at an online marketplace company. Your task is to develop a solution to identify fake reviews on your platform. You have a dataset where each review is marked as either 'genuine' or 'fake'. After developing an initial model, you find that it's accurately classifying 'genuine' reviews but performing poorly with 'fake' ones. Which of the following steps can likely improve your model's performance in this context?
A: Use a more complex model to capture the intricacies of 'fake' reviews.
B: Obtain more data to improve the overall performance of the model.
C: Implement a cost-sensitive learning approach, placing a higher penalty on misclassifying 'fake' reviews.
D: Translate the reviews to another language and then back to the original language to enhance their clarity.
E: Remove the 'genuine' reviews from your training set to focus on 'fake' reviews.

Medium

Identifying Grammatical Errors and Vocabulary Usage
Subject-Verb Agreement
Pronoun Usage
Idioms
Solve
Read the following passage and identify the sentence(s) that contains grammatical or vocabulary usage errors.

"The team of researchers have been working tirelessly on the project. They are confident that their findings will have a significant impact on the field. The lead researcher, Dr. Smith, said, 'We have literally left no stone unturned in our investigation.' However, some experts believe that the research methodology may not be as rigorous as it should be. Despite the criticism, the team remains optimistic and believes that the results speak for themselves."

A: The lead researcher, Dr. Smith, said, 'We have literally left no stone unturned in our investigation.'
B: They are confident that their findings will have a significant impact on the field.
C: The team of researchers have been working tirelessly on the project.
D: However, some experts believe that the research methodology may not be as rigorous as it should be.
E: Despite the criticism, the team remains optimistic and believes that the results speak for themselves.

Easy

Identifying Target Audience
Marketing Strategy
Audience Segmentation
Solve
An online education platform wants to launch a digital marketing campaign to promote its new course on data science. The course is designed for beginners with a basic understanding of mathematics and aims to equip them with foundational knowledge in data science, including statistics, programming in Python, and data visualization. Considering the course content and target learners, which of the following groups should be the primary target audience for the campaign?
A: High school students interested in STEM fields
B: Recent college graduates with degrees in humanities
C: Working professionals with a few years of experience in data analysis
D: Senior data scientists looking to update their skills
E: Middle school teachers seeking professional development
F: College students and recent graduates with a strong interest in data science and basic mathematical skills

Easy

Identifying the Correct Verb Tense
Verb Tenses
Solve
Which sentence uses the correct verb tense?
A: Yesterday, I go to the store.
B: She is reading a book now.
C: They will played soccer tomorrow.
D: He have finished his work.
E: We ate dinner an hour ago.
F: I am study for the test last night.

Medium

Idiomatic Expression and Context Clues
Idioms
Contextual Meaning
Solve
In the following sentence, identify the option that provides the most appropriate definition of the highlighted idiom and correctly explains its role in conveying the sentence's meaning:

Sarah finally decided to  *bite the bullet* and confront her roommate about the constant late-night parties.
A: To eat quickly: Indicates Sarah's impatience to address the situation.
B: To cause discomfort: Suggests Sarah expects a difficult conversation.
C: To accept a challenging situation: Implies Sarah's resolve to deal with the issue.
D: To show aggression: Emphasizes Sarah's anger towards her roommate.
E: To endure pain: Highlights Sarah's ongoing frustration with the noise.
F: To make a bold move:  Underscores Sarah's newfound confidence.

Medium

IDisposable Pattern
Garbage Collection
IDisposable Pattern
Memory Management
Solve
Consider the following .NET C# code snippet implementing IDisposable pattern:
 image
What is true about the garbage collection and resource management in this code?
A: The finalizer will always be called when the object is garbage collected.
B: The `Dispose` method is only called when explicitly invoked.
C: Managed resources will be freed in the finalizer.
D: Unmanaged resources are only freed if `Dispose` is called with `true`.
E: The `GC.SuppressFinalize` method prevents the finalizer from being called.
F: The `using` statement ensures that unmanaged resources are always freed.

Easy

Impact of Exchange Rate Fluctuations
Financial Accounting
Asset Management
Solve
A U.S.-based company using SAP FICO is preparing its financial statements at year-end. The company holds several foreign currency bank accounts, and there have been significant fluctuations in exchange rates over the year. The company's policy is to adjust the value of these accounts to reflect current exchange rates at the end of the fiscal year. Assume the exchange rate movement during the year resulted in a loss. In the SAP system, which of the following steps is correct for reflecting these changes in the financial statements?
A: Run the Foreign Currency Valuation for each account using transaction code F.05 and post the difference to a realized gain or loss account.
B: Manually adjust the balance of each foreign currency account in the General Ledger to reflect the new exchange rate.
C: Use transaction code FB50 to enter adjustment entries directly, bypassing the automated SAP processes.
D: Generate a Balance Sheet Adjustment report and manually update the figures in the financial statements.
E: Use the Automatic Account Determination feature to automatically adjust all foreign currency balances.
F: Ignore the exchange rate fluctuations, as they do not affect the cash basis of accounting.

Medium

Implementing a Browser's Back Button
Stack
Data Handling
Solve
You are tasked with implementing the "Back" button functionality in a web browser. This feature allows users to return to previously visited web pages in the order they were viewed. The browser maintains a history of URLs in a data structure. Considering the nature of web browsing, where users can go back multiple steps and then navigate to a new page (at which point the future history should be cleared), which data structure and algorithm would best implement this functionality?
A: Use a heap, add the current URL when navigating to a new page, and remove the top element when the back button is used.
B: Use a queue, enqueue the current URL when navigating to a new page, and dequeue when the back button is used.
C: Use a single stack, push the current URL when navigating to a new page, and pop when the back button is used.
D: Use an array, add the current URL to the end when navigating to a new page, and remove the last URL when the back button is used.
E: Use a linked list, add the current URL to the head when navigating to a new page, and move backwards when the back button is used.
F: Use two stacks, push the current URL to the first stack when navigating to a new page, and use the second stack to store the pages when the back button is used.

Medium

Implementing a Custom API Call
API integration
HTTP requests
JSON parsing
Solve
You are tasked with integrating Power Automate with a custom REST API to retrieve information about project tasks. The API endpoint is https://api.customdomain.com/tasks and requires an API key for authentication. The endpoint responds with a JSON payload containing an array of tasks, where each task has id, title, description, status, and dueDate. Your objective is to parse this response to filter tasks that are "In Progress" and have a dueDate within the next 7 days. The filtered tasks should then be formatted into an HTML table and sent in an email notification.

Given the JSON schema for the task object is:
 image
Write the expression used in the 'Filter array' action to achieve the filtering criteria, and provide the schema to parse the API response in the 'Parse JSON' action. Additionally, outline the steps to format the filtered tasks into an HTML table.
A: Use the expression @equals(item()['status'], 'In Progress') && @lessOrEquals(item()['dueDate'], addDays(utcNow(), 7)) for the 'Filter array' action. In the 'Parse JSON' action, manually enter the provided JSON schema. To format into an HTML table, use a 'Select' action to transform the filtered array into HTML string elements for each task, then concatenate these strings in a 'Compose' action.

B: The filtering logic is not directly supported in Power Automate without custom code. Use an Azure Function to process and filter the API response.

C: Use the OData filter query directly on the custom API call to filter tasks by 'status' and 'dueDate' before parsing the JSON response.

D: Implement a 'Data Operations - Filter array' action with the expression item().status == 'In Progress' && item().dueDate <= addDays(utcNow(), 7) and use the JSON schema as is. For formatting, use a 'Data Operations - Compose' action to manually construct the HTML table from the filtered tasks.

E: For the 'Filter array' action, write the expression item()['status'] == 'In Progress' && item()['dueDate'] <= formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd'). Use the provided JSON schema in the 'Parse JSON' action. For the HTML table, iterate over the filtered tasks with an 'Apply to each' action, building the HTML table string dynamically.

F: Filtering and formatting tasks as described require preprocessing the JSON response in a script before using Power Automate, as Power Automate does not support complex data manipulations.

Medium

Implementing Domain-Specific Attention
Attention mechanisms
Domain adaptation
Solve
You are customizing a Large Language Model (LLM) like GPT-3 to enhance its performance on financial text analysis. To do this, you decide to implement a domain-specific attention mechanism that prioritizes financial terms and concepts during the training process. This mechanism should adjust the attention scores in the model's layers to focus more on tokens related to financial content.

Consider the following simplified pseudocode for a transformer-based LLM where you need to integrate the custom attention mechanism:
 image
In the above pseudocode, you must define the logic for custom_attention to adjust the attention scores effectively. What is the appropriate logic (marked as X) that should be implemented in the custom_attention function to enhance the model's focus on financial tokens?
A: Multiply the scores by a fixed factor if they correspond to domain-specific tokens.
B: Set scores to zero for tokens not related to the financial domain.
C: Add a constant value to scores for domain-specific tokens.
D: Normalize scores based solely on the presence of financial tokens.
E: Use a softmax function to recalibrate scores based on domain relevance.
F: Replace scores with pre-defined weights for financial tokens.

Medium

Implementing Drip Campaigns
Drip Campaigns
Subscriber Engagement
Email Automation
Solve
You're an email marketing manager for an online course platform. The platform offers various courses on different topics. Recently, you've decided to implement a drip campaign strategy to nurture potential customers who've shown interest in certain courses, but have yet to make a purchase.

Which of the following approaches would be the most effective way to structure your drip campaign?
A: Send daily emails about the benefits of the course they've shown interest in.
B: Send an email every two days, alternating between different courses available on the platform.
C: Send weekly emails with testimonials from students who've completed the course they're interested in.
D: Send an initial email about the course they've shown interest in, followed by periodic emails that provide value related to the course topic.
E: Send an email only when there's a discount on the course they're interested in.
F: Send a daily reminder about the course they've shown interest in until they make a purchase.

Medium

Implicit and Explicit Loading
Loading Strategies
Relationships
Solve
In an Entity Framework Core project, you have two related entities, Product and Category. Each Product entity has a navigation property Category that represents the Category entity associated with the product.

You have the following code that retrieves a product:
 image
The Product and Category entities are defined as follows:
 image
You call the GetProduct method and then access the Category.Name property of the returned Product entity. What will happen?
A: The Category.Name property will have the name of the category associated with the product.
B: The Category.Name property will be null
C: An NullReferenceException error will be thrown when accessing the Category.Name property.
D: The Category.Name property will have the default value for a string

Easy

Import records
Data Management
Solve
Adaface uses Sales CRM to maintain lead records. Adaface received two new lists of lead records:

- List 1 contains 13,459 records
- List 2 contains 3.2 million records
List 1 comes from an unclean source and likely has many duplicate records. Which of the following would be best suited to import these lists into Salesforce?

Medium

Improving SEO through Content Marketing
SEO strategies
Audience engagement
Solve
Your company, AlphaTech, has been putting consistent effort into creating high-quality blog posts for the past year. Despite this, the organic traffic to your website is not significantly increasing. You decide to use Google Analytics to analyze the situation and find the following information:

1. The average time users spend on your website is quite low.
2. The bounce rate is high.
3. The exit rate from the blog page is also high.

Considering these data points and given your expertise in content marketing and SEO, which of the following strategies would you implement to increase organic traffic to your blog?
A: Publish more content.
B: Increase the keyword density in your articles.
C: Develop engaging content and implement internal linking.
D: Run paid advertisement campaigns to increase blog visibility.
E: Invest in better web design for your blog.

Easy

Cart Checkout
Incident Report
Solve
Review the following incident report written QA team of LWB, Little White Book (an e-commerce app):
1. Place any items in the cart (Say “Nike FST Men”).
2. Place any other (different) item in the shopping cart (Say “Nike Air Max”).
3. Remove “Nike FST Men” from the shopping cart, but leave “Nike Air Max” in the cart.
4. Click on “Check out” button.
5. Expect the app to display the check out screen, instead ‘No items in the shopping cart. Click continue to go back to shopping.’ error message is shown as a popup.
6. Click “Continue”.
7. Expect the app to go to shopping screen to add/remove items from the cart. Instead the app crashes. 
8. The error in steps 5 and 7 occurred in every attempt of 5 attempts (1 2 3 4 and 6).
Which of the following information is missing from the incident report?

Medium

Incident Response Procedure
Incident Management
Disaster Recovery
System Optimization
Solve
You are an SRE for a large-scale distributed system. The system architecture includes five primary servers (P1 to P5) and three backup servers (B1 to B3). The system uses an advanced load balancer that distributes the workload across the primary servers evenly. 

One day, the monitoring system triggers an alert that server P5 is not responding. The pseudo-code for the current incident response procedure is as follows:
 image
The function 'replaceServer(server)' replaces the failed server with a new one from a pool of spare servers, which takes around 30 minutes. 

The current discussion revolves around modifying this procedure to improve system resilience and minimize potential downtime. The backup servers are underutilized and could be leveraged more effectively. Also, the load balancer can dynamically shift workloads based on server availability and response time.

Based on the situation above, what is the best approach to optimize the incident response procedure?
A: Implement an early warning system to predict server failures and prevent them.
B: Upon failure detection, immediately divert traffic to backup servers, then attempt to reboot the primary server, and replace if necessary.
C: Replace the failed server without attempting a reboot and keep the traffic on primary servers.
D: Enable auto-scaling to add more servers when a primary server fails.
E: Switch to a more advanced load balancer that can detect and handle server failures independently.

Medium

Increase conversion
Solve
Your friend, Missy opened a new online store to sell heels. The heels come in 6 sizes: 34, 36, 38, 40, 42, 44. Missy did not want to invest too much capital upfront, so she decided to stock only 3 sizes: 36, 38 and 40 and display “out of stock” message for the remaining sizes. She used Google and Facebook ads to get visibility, and the market responded well. A lot of people ordered heels in the sizes she stocked, so she kept restocking the same sizes as they kept selling out.
She meets you over a cup of coffee and shares her story, and asks if you have any recommendations to increase conversion. What would you recommend?
A: Set up analytics and custom events on her online store to check how many people are clicking on the sizes she doesn’t have in stock.

B: Setting up analytics is not a good idea since it reduces website speed and impacts user experience.

C: Change CTA button to “Buy Now” to increase sales.

D: Procure a larger variety of heels in the same sizes that have been selling out.

E: It is possible that a different combination of heel sizes would increase conversion. 

F: Try a smaller stock of all the other sizes just to see if it sells.

G: Call up some of her customers to understand which sizes they are looking for and understand the market need.

H: Use FOMO (fear of missing out) to your advantage with messaging like “this item is in 43 carts”

I: Pick only 5 star reviews you have received and display on your store for each product to increase trust.

Medium

Increasing monthly gross profit
Percentage Calculations
Solve
The CEO of Snipr. Inc wants to grow monthly gross profit by 4%. If costs stay the same, what does the sales turnover need to be in February to achieve this goal?
 image

Medium

Index key order
Solve
Consider the following indexes on "musk" collection and the written queries. Select the queries that will use an index:
 image
A) db.musk.find( { title : "SpaceX" } )
B) db.musk.find( { _id : 22, date: ISODate("2020-01-01" } ) 
C) db.musk.find( { date: ISODate("2020-01-01"), biz : "ElonSpaceX" } )
D) db.musk.find( { contact : "111-111-1111"), info : "000-000-0000" } )

Medium

Indexer Failure
Solve
Broadwausical has an indexer cluster supporting search needs like- scheduled search, data model acceleration and summary indexing. Can you recommend a strategy for Broadwausical that represents the minimum and least disruptive change necessary to protect the searchability of the indexer cluster in case of indexer failure? Here's an excerpt from the cluster masters server.conf:
[clustering]
replication_factor=2
search_factor=1
summary_replication-false
 image

Medium

Indexing Ready
Indexer
Solve
Sankman Fried works as Splunk developer at Binnance Inc. Binnance’s new single-site three indexer cluster is being stood up with replication_factor = 2 and search_factor = 2. At which step would the Indexer Cluster be classed as ‘Indexing Ready’ and be able to ingest new data?
 image

Medium

Ingress from namespace
Network
Network Policies
Solve
You are tasked with deploying a Kubernetes network policy. Here are the specifications:

- Name of the policy: adaface-namespace
- Policy to be deployed in ‘chatbot’ namespace
- The policy should allow ALL traffic only from ‘tester’ namespace
- Policy should not allow communication between pods in the same namespace
- Traffic only from ‘tester’ namespace is allowed on all ports
Which of the following configuration files is BEST suited to create required dependencies and deploy the network policy?
 image

Medium

Insert Queries
Database API
Solve
Review the following Drupal code:
 image
Pick the correct statements:
A: Both the snippets create the queries to run but are not executed until $query→execute() is called
B: When Snippet 2 is run, the insert statements are executed one after the other always. Equivalent to calling →execute() two separate times for each item in $values.
C: When Snippet 2 is run, depending on the database, the insert statements will be executed together in a transaction
D: The return value of $result→execute will be the inserted record entry

Easy

Instance Security Group
AWS
Resources
Solve
Consider the following Terraform code:
 image
Which statement is true about this Terraform code?

A. The code creates an EC2 instance and assigns an EIP to it within a VPC.
B. The code creates an EC2 instance, but it is not associated with the specified security group.
C. The code creates an EC2 instance and an EIP, but does not associate the EIP with the instance.
D. The code creates a security group that allows SSH access to the EC2 instance from anywhere.
E. The code creates an EC2 instance with the specified security group, but does not assign an EIP to it.

Medium

Integrating Financial Statements and Asset Accounting
Asset Accounting
Financial Posting
Integration
Solve
In an SAP FICO system, a company wants to integrate its asset accounting with the general ledger. The purchase of a new machine is recorded in asset accounting with an acquisition value of 50,000 EUR and is subject to a 20% input tax. This transaction needs to be correctly reflected in the financial statements. How should this transaction be posted in the SAP system to ensure accurate reflection in the financial ledger?
A: Dr. Machinery account 50,000 EUR, Cr. Cash/Bank 50,000 EUR
B: Dr. Machinery account 60,000 EUR, Cr. Cash/Bank 50,000 EUR, Cr. Input Tax 10,000 EUR
C: Dr. Machinery account 40,000 EUR, Cr. Cash/Bank 50,000 EUR, Dr. Input Tax 10,000 EUR
D: Dr. Machinery account 60,000 EUR, Cr. Cash/Bank 60,000 EUR
E: Dr. Machinery account 50,000 EUR, Cr. Cash/Bank 60,000 EUR

Medium

Integrating JMS with WebSphere
Java Message Service
Application Integration
Message-Driven Beans (MDB)
Solve
You are configuring a message-driven bean (MDB) in IBM WebSphere Application Server to consume messages from a JMS queue. The MDB needs to process messages from a remote JMS provider, and you must ensure the configuration supports high availability and load balancing. Given the following pseudo code:
 image
Considering the requirements and the given code, which of the following configurations would be most appropriate?
A: Use the default connection factory and modify the MDB to use JNDI lookup for the remote JMS provider.
B: Configure an MDB activation specification with a custom resource adapter to connect to the remote JMS provider.
C: Deploy the MDB to a WebSphere cluster and configure a JMS queue connection factory with workload management (WLM) enabled.
D: Implement a custom message listener interface instead of using the javax.jms.MessageListener.
E: Use a local JMS provider and replicate messages to the remote provider for high availability.
F: Configure the MDB with a direct IP address to the remote JMS provider instead of using JNDI names.

Medium

Integrating RPA with Database
Database Connectivity
Transaction Management
Error Handling
Solve
An RPA process involves retrieving data from a SQL database, processing the data, and then updating the database with new values. It's critical if an error occurs at any point, the database changes must be rolled back to maintain data integrity. What is the most effective approach for implementing this operation within an RPA workflow?
A: Establish a continuous loop that retries the database update until it succeeds, with a delay between each attempt.
B: Implement separate database connection activities for each data retrieval and update, with custom error handling logic.
C: Employ a state machine design, with states for data retrieval, processing, and updating, and transitions based on success or failure.
D: Use an external script (e.g., Python or PowerShell) to manage the database transaction, and invoke it from the RPA process.
E: Utilize a database transaction block with commit and rollback activities integrated into the RPA workflow.

Easy

Intent & Activity
Solve
We want to pass a value to next activity in Android. Which of the following options are the right way to do it?
 image

Medium

Interactive Application
JavaScript Rendering
Solve
A senior front-end engineer is tasked with optimizing the loading speed of a web application. The current bottleneck is the large number of JavaScript files that must be downloaded before the application becomes interactive. The engineer noticed that the browser spends a lot of time parsing and executing the JS code before making the application interactive. Which of the following techniques should the engineer apply to address this issue?

Medium

Intercompany Transactions
Intercompany Setup
Ledger Posting
Data Sharing
Solve
You are a Dynamics 365 Finance Functional Consultant working with a conglomerate that has multiple subsidiary companies. These companies frequently engage in intercompany transactions, purchasing goods and services from each other. The CFO has expressed concerns over the current manual process of recording these transactions and has approached you for a solution.

The conglomerate has the following requirements:

1. When Company A sells a product to Company B, the transaction should automatically generate a sales invoice in Company A and a purchase order in Company B.
2. For taxation purposes, each subsidiary company must maintain its ledger. However, the parent company should be able to view consolidated financial statements.
3. Data related to product details, customer, and vendor information should be shared across all companies to avoid redundancy and ensure consistency.

Given these requirements, how should you configure Dynamics 365 Finance to meet the conglomerate's needs?
A: Enable intercompany accounting and manually create corresponding purchase orders and invoices for intercompany transactions. Set up individual ledgers for each company and use the financial consolidation tool for consolidated reports. Use data entities to export and import shared data across companies.
B: Set up intercompany trading relationships to automate the creation of corresponding transactions. Assign individual ledger accounts to each subsidiary while maintaining a master ledger at the parent company. Use cross-company data sharing for shared information.
C: Use a single ledger for all companies to simplify the consolidation process. Manually adjust the ledger for intercompany transactions. Rely on data duplication across companies for shared information to ensure data integrity.
D: Implement third-party software specifically designed for intercompany transactions. Integrate this software with Dynamics 365 Finance. Use separate databases for each company and develop custom scripts for data synchronization.
E: Activate intercompany process automation in Dynamics 365 Finance. Create separate legal entities for each company, defining their individual ledgers. Use the Common Data Service (CDS) platform to ensure consistent data across all entities.

Medium

Internal users traffic
Solve
Jon, who is our marketing manager realized that a significant chunk of the website traffic is coming from internal users, and skewing customer data. What do you recommend to clean the report data?
 image

Medium

Interpersonal Skill in Team Management
Conflict Resolution
Emotional Intelligence
Decision Making
Solve
You are the team leader of a project team in a software development company. Your team consists of experienced and talented individuals. However, two of your team members, Alice and Bob, are frequently having disagreements, which is affecting the team's morale and overall productivity. The disagreements seem to stem from a clash in their working styles. Alice is very detail-oriented and likes to plan ahead while Bob is more spontaneous and likes to tackle problems as they come. You need to address this issue to ensure the project deadlines are met. What approach would you take?
A: They are both adults, wait for them to fix the issue by themselves. 
B: Pick the more competent team member's side and ask the other team member to adjust.
C: Have a private conversation with both Alice and Bob separately, to give feedback on their behaviors.
D: Organize team-building activities to improve team dynamics.
E: Report the situation to your manager and ask for their advice.
F: Terminate the less competent team member from the project team, and move them to another project.
G: Organize a meeting with both Alice and Bob, facilitating a discussion where they understand each other's perspectives and find a middle ground.

Medium

Invention & Business
Reading Comprehension
Solve
Leer el texto y señalar la respuesta correcta de la lista a continuación:
En un mundo cada vez más interconectado es evidente la importancia de la innovación en el desarrollo empresarial. Las empresas que se mantienen a la vanguardia son aquellas que están dispuestas a adoptar nuevas tecnologías, métodos y enfoques para satisfacer las demandas cambiantes del mercado. La innovación no solo impulsa el crecimiento y la competitividad, sino que también permite a las empresas adaptarse a un entorno empresarial en constante evolución. Desde la implementación de nuevas estrategias de marketing hasta la creación de productos revolucionarios, la innovación se ha convertido en un pilar fundamental para el éxito empresarial en el siglo XXI.
A: La innovación solo impulsa el crecimiento y la competitividad de las empresas.
B: El marketing es la única clave del desarrollo empresarial dado que permite desarrollar ideas innovadoras
C: La innovación es fundamental en un mundo cambiante para el éxito empresarial.
D: La innovación no es fundamental para el éxito empresarial.
E: La innovación es fundamental desde el siglo XVIII para el éxito empresarial.
F: El entorno de las empresas no está en constante evolución.

Medium

I/O cycle and main module
Event Loop
Solve
Review the following NodeJS code:
 image
Pick the correct statements:

A: X will be logged after Y always
B: Y will be logged after X always
C: The order of executing timeout and immediate callbacks is non-deterministic and is bound by the performance of the process
D: In this case, the function calls are scheduled in the main module and not in the I/O cycle
E: In this case, the function calls are scheduled in the I/O cycle so setImmediate is always executed before any timers scheduled in the I/O phase, independently of how many timers are left

Medium

IP Addressing and Routing Scenario
IP Addressing
Subnetting
Routing
Solve
You are a network administrator for a company that has a main office and a branch office. The main office and the branch office are connected via a VPN tunnel. You are tasked with configuring the IP addressing scheme for both offices and ensuring proper routing between them. Here are the details:

- The main office has three departments: Sales, Finance, and IT. Each department requires its own subnet.
- The branch office has two departments: Sales and Finance. Each department requires its own subnet.
- Each subnet requires a maximum of 30 host addresses.
- The main office uses the IP address range 192.168.0.0/24.
- The branch office uses the IP address range 192.168.1.0/24.
- All routers and VPN gateways are properly configured for routing and VPN connectivity.

Given the above information, which of the following subnet masks should you use to create the subnets for each department in both offices?

Medium

Verify admin user
Solve
For her productivity tool app, Wu wants to verify if the account being checked on the frontend is an admin account. Which of the following snippets of code should she use?
 image
 image
 image
 image

Easy

Iterable Sync
Asynchronous Programming
Solve
What would the following Dart code print?
 image

Medium

Iteration in WordPress Plugin
Asynchronous JavaScript
Solve
You're developing a WordPress plugin where you need to fetch comments for a list of posts from a WordPress database using AJAX. The JavaScript code is as follows:
 image
The processComments function processes the comments for other operations and is working as expected.

However, when running the code, you notice that the console logs for fetched comments don't appear in the order of the post IDs. Instead, the logs appear in a seemingly random order each time.

What change can you make to ensure the comments are fetched and processed in the order of the post IDs?
A: Use a traditional for loop instead of forEach.
B: Use setTimeout to delay the execution of fetchComments.
C: Use sort on postIDs before calling forEach.
D: Change forEach to map and use Promise.all.
E: Make processComments function asynchronous and await it in the forEach loop.

Easy

ITIL Inventory Principle
Solve
City Mont school is looking to build a service to automatically fulfill food coupon orders for the staff members. Currently food coupons are filled manually by the cafeteria head once an order is received from a staff member by copy-pasting the coupon number from a spreadsheet into an email template and sending the emails out to the staff members. To automate this process, the project lead first takes an inventory of current services, procedures and processes that are being used by the cafeteria head to see if it is possible to reuse them. What guiding principle best describes this scenario?
A: Focus on value
B: Collaborate and promote visibility
C: Start where you are
D: Keep it simple and practical

Medium

Ivory's new startup
Solve
Statement: Ivory started a new startup. We know for a fact that almost all startups fail within the first 2 years. 
Conclusion: Ivory's startup will fail.
Does the conclusion follow from the statement?

Medium

Abstract Interface
OOPs
Interfaces
Solve
Given following interface:
 image
Which of these are correct classes?
 image

Medium

Garbage Collection
Garbage Collection
Solve
After which line is "bs" object, created on Line 4, eligible for garbage collection?
 image

Hard

Jobs file
Solve
Assuming the following Hive statements execute successfully, choose the correct statements that describe the result:
 image
A. Hive reformats JobsFile2 into a structure that Hive can access and moves into to /user/steve/fenty/
B. The file named JobsFile2 is moved to to/user/steve/fenty/
C. The contents of JobsFile2 are parsed as comma-delimited rows and loaded into /user/steve/fenty/
D. The contents of JobsFile2 are parsed as comma-delimited rows and stored in a database

Easy

Join Handles
Concurrency
Solve
Review the following two Rust code snippets:
 image
Notice the handle.join().unwrap() line added in snippet two. Pick the correct statements:

A: Snippet one prints 1 to 5 in the spawned thread and 1 to 3 in the main thread always.
B: Snippet one prints 1 to 3 in the main thread but spawned thread might be closed before it prints all the numbers.
C: Snippet two prints 1 to 5 in the spawned thread and 1 to 3 in the main thread always. 
D: Snippet two prints 1 to 3 in the main thread but the spawned thread might be closed before it prints all the numbers.

Easy

Joins and Aggregate Functions
SQL
Joins
Aggregation
Solve
You are working with a Sybase ASE database that has two tables: orders and products.

The orders table has columns:

- order_id (int)
- product_id (int)
- quantity (int)

The products table has columns:

- product_id (int)
- product_name (varchar)
- price (float)

You're tasked with writing a query that lists product names that have been ordered more than 5 times in total, along with their average price and total quantity ordered. Which of the following pseudocode SQL statements would achieve this?
 image

Easy

JSON Schema: Pick valid data
Solve
Consider the following JSON Schema specification:

{
  "type": "object",
  "properties":
    { "ProductID": { "type":"string", "pattern":"Product*" },
      "ProductName": { "type":"string" },
      "Price": { "type":"integer", "minimum":20, "maximum":200 },
      "Shippers": { "type":"array", "maxItems":4,
                   "items": { "type":"string" }},
      "Favourites": { "type":"array",
                   "items":
                      { "type": "object",
                        "properties": {"User":
                                       {"type": "string", "optional": true},
                                       "Rating":
                                       {"type": "integer", "minimum":1,
                                        "maxiumum":10}}}},
      "AvgScore": { "type":"number", "optional":true },
      "FreeCancellation": {"type":"boolean" }
    }
}

Select, from the choices below, the JSON data that is valid according to the JSON Schema specification above.
OPTION A:
{ "ProductId": "Product123",
  "ProductName": "desk",
  "Price": "50",
  "Shippers": ["Amy","Pond"],
  "Favourites": [{"User":"Eleven", "Score":5}, {"Score":1},
              {"User":"Mandosa", "Score":4}],
  "AvgScore": 3.33,
  "FreeCancellation": true }
OPTION B:
{ "ProductId": "Product123",
  "ProductName": "desk",
  "Price": 50,
  "Shippers": ["Amy","Pond"],
  "Favourites": [ ],
  "AvgScore": 3.33,
  "FreeCancellation": true }
OPTION C:
{ "ProductId": "Product123",
  "ProductName": "desk",
  "Price": 50,
  "Shippers": ["Amy Pond","Doctor Strange","Will","Clara Oswald", "Minnesota"],
  "Favourites": [{"User":"Eleven", "Score":5}, {"Score":1},
              {"User":"Mandosa", "Score":4}],
  "AvgScore": 3.33,
  "FreeCancellation": true }
OPTION D:
{ "ProductId": "123",
  "ProductName": "desk",
  "Price": 50,
  "Shippers": ["Amy","Pond"],
  "Favourites": {"User":"Amy", "Score":5},
  "AvgScore": 3.33,
  "FreeCancellation": true }

Medium

succeeding test
Solve
Consider the following JUnit test. Which of the following statements are true?
 image
A: beforeAll() is executed before each of succeedingTest and anotherSucceedingTest

B: beforeAll() is executed only once before both succeedingTest and anotherSucceedingTest

C: beforeEach() is executed only once before both succeedingTest and anotherSucceedingTest

D: beforeEach() is executed before each of succeedingTest and anotherSucceedingTest

E: The order of which of the tests (succeedingTest and anotherSucceedingTest) to be executed first is decided by JUnit using a deterministic, but unpredictable order

F: The order of which of the tests (succeedingTest and anotherSucceedingTest) to be executed first is decided by JUnit using alphaNumberic order of test methods

Easy

twoWheeler Interface
OOPs
Solve
What will the following code output?
 image

Medium

Land Sale
Balance Sheet
Asset Classification
Acquisition Accounting
Solve
Here’s the balance sheet for SinkedIn Ltd as of December 31, 2022:
 image
SinkedIn Ltd acquires a smaller company for $100,000 cash. The acquisition adds $60,000 in goodwill and increases the long-term investments by $40,000. 

Here’s the new balance sheet created after these changes:
 image
Which of the following rows are erroneous rows in the balance sheet after the acquisition?

Medium

Laptop Brands
Proportions and Percentages
Financial Reasoning
Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
 image

Medium

Le parcours inspirant d'une auteure passionnée
B2
Comprehension
Solve
La vie d'une auteure est souvent un voyage passionnant, marqué par des hauts et des bas, des moments de doute et de succès éclatants. Cet itinéraire particulier offre un aperçu de la persévérance, de la créativité et de l'amour pour les mots.Depuis son jeune âge, cette écrivaine avait un goût prononcé pour l'écriture. Ses cahiers étaient remplis de poèmes, d'histoires imaginaires et de réflexions sur le monde qui l'entourait. Elle a décidé de poursuivre sa passion pour l'écriture en suivant des études littéraires, mais la route était semée d'embûches.La vie d'auteure est faite de rejets éditoriaux, de critiques constructives et d'heures passées à perfectionner son art. Pourtant, elle a persévéré, refusant de laisser les obstacles l'arrêter. Elle a écrit de nombreux manuscrits avant de trouver enfin un éditeur qui a cru en son talent.
Avec le temps, ses écrits ont gagné en reconnaissance, touchant les cœurs de lecteurs du monde entier. Ses romans ont été traduits dans plusieurs langues, et elle a été invitée à des salons du livre et des conférences littéraires prestigieuses.Mais le succès ne l'a pas changée. Elle reste une écrivaine humble, dévouée à son art et soucieuse de partager ses connaissances avec les jeunes écrivains en herbe. Elle encourage la créativité et la diversité dans l'écriture, affirmant que chaque voix est unique et mérite d'être entendue. Au fil des ans, cette auteure a laissé un héritage durable dans le monde de la littérature. Son parcours est une source d'inspiration pour ceux qui aspirent à donner vie à leurs histoires et à toucher le cœur des lecteurs avec leurs mots. Quelle qualité est mise en évidence dans le parcours de cette auteure qui l'a aidée à surmonter les défis et à atteindre le succès?

Medium

Le pronom relatif
A2
Vocabulary
Pronouns
Solve
Quel mot convient le mieux pour compléter cette phrase ? 
J'aime lire des livres __________ aident à développer mon vocabulaire __________ il y a beaucoup d’illustrations. J’ai prêté des livres  __________ tu m’a parlé. 

Medium

Les sociétés en changement
B2
Verbal Reasoning
Solve
Lisez le paragraphe suivant et choisissez les vraies options:
Et, en France, la classe politique pourrait bien ressembler, tout du moins en nombre d'années, à un « pouvoir gris ». Plus de la moitié des sénateurs ont plus de 60 ans, l'âge moyen des maires de communes de plus de 3 500 habitants est de 54 ans. Idem pour ceux qui les élisent. Alors qu'ils représentent 20 % de la population, les retraités forment déjà 30 % des électeurs. Bref, la démocratie a les tempes blanchies. Or, quand les papy-boomers seront à la retraite, ils auront encore plus de temps. Ne vont-ils pas accaparer les affaires publiques à leur avantage ? Faut-il redouter une gérontocratie à la française ? « Fantasme ! » Jean-Philippe Viriot-Durandal, maître de conférences en sociologie à l'université de Franche-Comté, en est convaincu. Vieux ne veut pas forcément dire réac. Il en veut pour preuve deux exemples, décortiqués dans son livre. D'abord, la dernière élection présidentielle, où le vote pour le Front national fut autant le fait des jeunes électeurs que de leurs aînés. La preuve aussi avec l'adoption de l'euro. « Six mois après l'introduction définitive de la monnaie unique européenne, les nostalgiques du franc étaient à peine plus nombreux chez les plus de 65 ans que dans l'ensemble de la population – 53 %, contre 48 % », écrit le sociologue. Qui ajoute que « l'opposition entre les jeunes générations, ouvertes sur le monde et sur l'avenir, et les anciennes, rétives au changement et réfractaires à la nouveauté », ne serait que caricature.
A: La démographie électorale en France rajeunit, moins de la moitié des sénateurs ayant plus de 60 ans et l'âge moyen des maires des communes de plus de 3,500 habitants étant inférieur à 54 ans. 

B: Selon le sociologue Jean-Philippe Viriot-Durandal, la perception des générations plus âgées plus opposées au changement et aux idées nouvelles par rapport aux plus jeunes est une véritable représentation de la dynamique sociétale actuelle en France.

C: L'analyse de Jean-Philippe Viriot-Durandal suggère que les « papy-boomers », malgré leur âge, restent individualistes et prêts au changement, soulignant leur capacité propension à se reconstruire même bien après l'âge de la retraite.

Medium

Less complex decision tree model
Model Complexity
Overfitting
Solve
You are given a dataset to solve a classification problem using a decision tree algorithm. You are concerned about overfitting and decide to implement pruning to control the model's complexity. Consider the following pseudo code for creating the decision tree model:
 image
Which of the following combinations of parameters would result in a less complex decision tree model, reducing the risk of overfitting?

A: max_depth=5, min_samples_split=2, min_samples_leaf=1
B: max_depth=None, min_samples_split=5, min_samples_leaf=5
C: max_depth=3, min_samples_split=2, min_samples_leaf=1
D: max_depth=None, min_samples_split=2, min_samples_leaf=1
E: max_depth=3, min_samples_split=10, min_samples_leaf=10
F; max_depth=5, min_samples_split=5, min_samples_leaf=5

Medium

Let's Hack
CSS Property
Solve
Consider the following HTML and CSS:
 image
 image
Which additional CSS rule(s) will render the following image? Choose ALL that apply.
 image
A:
div{
  flex-direction : column;
  align-items : center;
}
B:
div{
  flex-direction : row;
  align-items: center;
}
C:
div{
  flex-direction: column;
  justify-content: center;
}
D:
div{
  flex-direction: row;
  justify-content: center;
}

Medium

Lifecycle Event Order in Blazor
Blazor
Component Lifecycle
Event Handling
State Management
Solve
Consider a Blazor Server application that implements a simple component for displaying user profiles. The component is designed to fetch user data asynchronously from an API upon initialization and update its state accordingly. The component also includes a button that, when clicked, updates a piece of local state within the component. Consider the following pseudo-code representation of the component:
 image
Assuming the component is navigated to and then navigated away from, which of the following correctly lists the order in which lifecycle methods and event handlers are called, including `Dispose` for cleanup?
A: OnInitializedAsync, FetchUserDataAsync, UpdateUserStatus, Dispose
B: FetchUserDataAsync, OnInitializedAsync, UpdateUserStatus, Dispose
C: OnInitializedAsync, FetchUserDataAsync, Dispose, UpdateUserStatus
D: FetchUserDataAsync, UpdateUserStatus, OnInitializedAsync, Dispose
E: OnInitializedAsync, Dispose, FetchUserDataAsync, UpdateUserStatus
F: Dispose, FetchUserDataAsync, OnInitializedAsync, UpdateUserStatus

Easy

Linear Layout
Solve
Check the following XML layout file. 
 image
What will the UI for this layout file look like?
1. An edit text to the right of a text view and a button beneath them
2. An edit text to the right of a text view and a button to the right of the text view
3. A text view, an edit text beneath it and the button beneath the edit text
4. An edit text to the left of a text view and a button beneath it

Easy

Linked List Element Removal
Linked Lists
Element Removal
Solve
Consider a singly linked list where each node contains an integer value. Write a function `removeElement` that removes all occurrences of a specific value from the linked list. The function should return the head of the modified linked list.

Pseudo code:
 image
What will be the content of the linked list referred to by `result` after executing the above pseudo code?

Medium

base code and queries
Solve
Check the following base LINQ code and two LINQ queries that follow:
 image
 image
Which of the following statements are true about the output of CODE ONE with base code and CODE TWO with base code?

Easy

IEnumerable
Solve
What does the following LINQ code output?
 image

Medium

Load Balancer Latency
Debugging
Solve
A backend service is experiencing intermittent latency spikes while processing incoming requests. The service is deployed in a multi-node environment with a load balancer in front. You suspect that the issue might be related to resource contention. You collect the following performance metrics from the affected nodes during a spike:
 image
Which of the following is the most probable cause of the latency spikes?
A: High memory usage on the affected nodes.
B: Disk I/O bottlenecks on the affected nodes.
C: Insufficient CPU resources on the affected nodes.
D: Uneven distribution of incoming requests by the load balancer.
E: Network latency between the load balancer and the backend nodes.

Easy

Load/migrate data
Solve
Rinsha works at a private equity fund, where they have subscribed to feeds from several companies that track startups. The feeds are delivered in multiple formats such as CSV files,  access to their RDBMS or NOSQL (Cassandra) database or daily incremental data. What should Rinsha use in Cassandra to load/ migrate data from one Cassandra cluster to another?

Medium

Locking Mechanisms
Transaction management
Locking mechanisms
Solve
Imagine you're the database administrator for a large online retail platform using Sybase ASE. During Black Friday sales, the platform experiences a significant increase in traffic, leading to concurrent database transactions.

Scenario 1: The finance team runs a transaction to tally total sales every hour. They need an absolute accurate count and cannot afford any discrepancy due to ongoing transactions.

Scenario 2: The product recommendation engine constantly fetches product data to make real-time recommendations to users. The engine favors speed over absolute data accuracy, as a slight delay in fetching data can lead to a sluggish user experience.

Which of the following transaction isolation levels would be the most suitable for the scenarios described?

Medium

Logging with Transcript
Logging
Transcription
Error Handling
Solve
You're reviewing a script designed to automate server maintenance tasks. One requirement is to log every action and potential error for auditing purposes. The script utilizes Start-Transcript and Stop-Transcript cmdlets to capture the session. Here's a snippet:
 image
After several successful runs, you notice that some logs are missing crucial information regarding errors. Which of the following could be a reason for the missing error details?
A: The -Append parameter is causing overwritten logs.
B: Not all errors are displayed in the console, hence not captured by the transcript.
C: The Stop-Transcript cmdlet needs to be invoked with an -ErrorAction Continue parameter.
D: Transcription only captures standard output, not error streams.
E: The log file path should be specified again in Stop-Transcript.

Easy

Logic Black Box
Solve
Consider the following logic box. There are three inputs A, B, C and three outputs not A, not B and not C (not A = !A, not B = !B, not C = !C).

Is it possible to achieve the expected outputs from the inputs using:

- Only AND and OR gates
- Just two (2) NOT gates
- No NAND, NOR, XOR, or XNOR gates
 image

Medium

LOOKUP employees
Functions
Solve
Review the following RPG program:
 image
What would the value of a and b be?

Medium

Loop Large Value
Solve
Consider the following pseudo code. 
 image
What does foo() return for very large value of B (Choose closest option)

Medium

Loops Output Estimation
Time Complexity
Solve
What does sample(number) return in following pseudo code? (Select the closest approximation)
 image

Medium

Mac address and IP on router hop
Routers
Switches
Solve
Refer to the following exhibit:
 image
Host A is sending a packet to Host B. 

1. What is the source and destination MAC address at point PA?
2. What is the source and destination IP address at point PB?
// Option A
PA: source MAC - Mac-A
PA: destination MAC - Mac-B
PB: source IP - 192.168.1.1
PB: destination IP - 192.168.3.1

// Option B
PA: source MAC - Mac-A
PA: destination MAC - Mac-RA
PB: source IP - 192.168.3.3
PB: destination IP - 192.168.3.1

// Option C
PA: source MAC - Mac-A
PA: destination MAC - Mac-B
PB: source IP - 192.168.3.3
PB: destination IP - 192.168.3.1

// Option D
PA: source MAC - Mac-A
PA: destination MAC - Mac-RA
PB: source IP - 192.168.1.1
PB: destination IP - 192.168.3.1

Hard

Magic bag
Arithmetic Sequences
Solve
Alex’s uncle is a magician who gave them a magic bag in which coins get doubled each time you put those coins into it. Initially, Alex had few coins with them. So, Alex put all the coins, and the coins got doubled. Alex took out all the coins and gave a few to their friend and then again put the remaining coins back in the bag. The coins doubled again; Alex took out all the coins again and gave a few coins to their second friend. Alex then put the remaining coins in the bag and the coins doubled again. Alex took out all the coins and gave a few coins to their third friend. 
There were no coins left with Alex when Alex gave coins to the third friend and Alex gave an equal number of coins to each friend. What is the minimum number of coins Alex had initially and how much did Alex give to each friend?
A: Started with 3 coins
B: Started with 5 coins
C: Started with 6 coins
D: Started with 7 coins
E: Started with 9 coins
F: Gave 3 coins in every turn
G: Gave 4 coins in every turn
H: Gave 5 coins in every turn
I: Gave 7 coins in every turn
J: Gave 8 coins in every turn
K: Gave 9 coins in every turn

Medium

Managing Dependencies
Backlog Management
Dependencies
Cross-functional Teams
Solve
You are a Scrum Master in an organization that is transitioning to Scrum. You have multiple Scrum Teams working on different parts of a large software product. Each team is working on different features, but those features have dependencies on one another. For example, Team A is working on a feature that cannot be completed until Team B completes another feature.

During the Sprint Planning, Team A chose a user story from its backlog that depends on the completion of a user story from Team B’s backlog. However, Team B can't guarantee that their user story will be done in the next sprint.

What should be the Scrum Master's approach to handle this scenario following Scrum principles?
A: Have Team A start working on the dependent user story with the hope that Team B finishes their part within the sprint.
B: Ask Team A to choose a different user story for this sprint that doesn't depend on Team B's work.
C: Arrange a joint session between Team A and Team B to revise their sprint plans, ensuring dependent user stories are completed in the same sprint.
D: Merge Team A and Team B for the next sprint to ensure they work together on the dependent user stories.
E: Delay the start of Team A’s sprint until Team B completes their user story.

Medium

Managing Interruptions
Time Management
Multitasking
Solve
You are an administrative assistant who is juggling multiple tasks on a busy day. You are currently working on a high-priority report that is due in two hours when you are faced with the following interruptions:

1. A team member asking for help with a computer issue.
2. A phone call from a supplier who is insisting on immediate payment.
3. A surprise visit from a client who insists on speaking with the CEO, who is currently unavailable.
4. An urgent request from the marketing team for meeting minutes you have recently typed.

Given your immediate obligations and the urgency of the report, how should you prioritize handling these interruptions?
A: Handle the computer issue, take the phone call, meet the client, address the marketing team's request.
B: Address the marketing team's request, meet the client, handle the computer issue, take the phone call.
C: Meet the client, address the marketing team's request, take the phone call, handle the computer issue.
D: Take the phone call, handle the computer issue, address the marketing team's request, meet the client.
E: Handle the computer issue, meet the client, take the phone call, address the marketing team's request.
F: Address the marketing team's request, take the phone call, handle the computer issue, meet the client.

Medium

Managing Stock and Procurement Processes
Stock Management
Procurement Cycle
Document Types
Solve
A company uses SAP MM to manage its inventory and procurement processes. The purchasing department is required to order 500 units of a specific material that needs to be available within the next month. They are planning to use a standard purchase order. The material is not subject to batch management and does not have a material master that allows for automatic reorder. The procurement process involves a purchasing group responsible for electronic items. Consider the following information and options related to creating and managing this purchase order:

- The company's typical lead time for electronic components is 3 weeks.
- There are currently 200 units in stock.
- The safety stock level for this material is 100 units.

Given the situation above, select the correct course of action from the options listed below:
A: Create a standard purchase order for 500 units with the standard purchasing group for electronic items.
B: Create a rush order for 500 units to ensure delivery within the required timeframe.
C: Issue a purchase requisition for 300 units, considering the current stock and safety stock levels.
D: Create a standard purchase order for 300 units to cover the deficit after considering the current stock against the required safety stock.
E: Set up a reorder point for the material at 100 units with an automatic order for 500 units whenever the stock falls below this level.
F: Recommend a review of the material master to include automatic reorder functionality and proceed with a standard order for 300 units.

Medium

Resource Attributes
Resource Dependencies
Resource Attributes
Solve
Consider the following Terraform code snippet, which represents a simplified infrastructure for a web application:
 image
In the above code, a security group (`web`) and a web server (`web`) are being created. An Elastic IP (`web`) is also being created and associated with the web server. The `web` Elastic IP has a lifecycle policy that prevents it from being destroyed.

Which of the following statements is true?
A: The Elastic IP (`web`) will not be associated with the `web` instance if the security group fails to create.
B: The Elastic IP (`web`) can be disassociated manually in the AWS console without affecting the Terraform state.
C: The Elastic IP (`web`) will be released when the `web` instance is destroyed.
D: A Terraform destroy operation will fail due to the lifecycle policy of the `web` Elastic IP.
E: The `web` instance must be manually terminated before the security group can be deleted.

Medium

Many-to-one error
Data Modeling
Solve
Consider the following two tables in Power BI:
 image
We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?

Medium

Marker ink component
Solve
Consider the following component, which can be used to model a marker and the ink it writes.
 image
Which statements about the given component are true?
A: The 'marker' parameter of the @Input('marker') declaration does not alter the interface of the component.
B: Component, Input and Output are all required imports for this component.
C: Both marker and ink inputs must be provided when including the MarkerInk component in a template.
D: When included in a components template, the MarkerInk component creates a span containing the interpolated marker's name and a button bound to writeInk().
E: The MarkerInk component can be included in another template using the <MarkerInk> tag.

Medium

Marketing Database
Columnar Storage
Data Warehousing
Analytical Queries
Solve
You are a data warehouse engineer at a marketing agency, managing a large-scale database that stores extensive data on customer interactions, campaign metrics, and market research. The database is used predominantly for complex analytical queries, such as segment analysis, trend identification, and campaign performance evaluation. These queries often involve aggregations, filtering, and joining over large datasets.

The existing setup, using traditional row-oriented storage, is struggling with performance issues, particularly for ad-hoc analytical queries that span multiple tables and require aggregating large volumes of data.

The main tables in the database are:

- Customer_Interactions (millions of rows): Stores individual customer interaction data.
- Campaign_Metrics (hundreds of thousands of rows): Contains detailed metrics for each marketing campaign.
- Market_Research (tens of thousands of rows): Holds market research data and findings.

Considering the nature of the queries and the structure of the data, which of the following changes would most effectively optimize the query performance for analytical purposes?
A: Normalize the database further by splitting large tables into smaller, more focused tables and creating indexes on frequently joined columns.
B: Implement an in-memory database system to facilitate faster data retrieval and processing.
C: Convert the database to use columnar storage, optimizing for the types of analytical queries performed in the marketing context.
D: Create a series of materialized views to pre-aggregate data for common query patterns.
E: Increase the hardware capacity of the server, focusing on faster CPUs and more RAM.
F: Implement partitioning on the main tables based on commonly filtered attributes, such as campaign IDs or time periods.

Easy

Markup DOM
Templates
Solve
Review the following Angular components:
 image
What will be rendered to the DOM based on the following markup usage?
 image
 image

Medium

MATCH INDEX LOOKUP
Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
 image

Medium

Material Valuation and Price Control
Material Valuation
Price Control
Accounting Integration
Solve
A multinational corporation operates using SAP MM to manage its extensive inventory across various locations. The company has recently decided to update its inventory valuation method for a key raw material (Material X) due to fluctuating market prices. Material X is crucial for the company's manufacturing process, and accurate valuation is essential for financial reporting and cost management. Previously, the material was managed using the Standard Price method, but considering the market volatility, the company is contemplating a shift to the Moving Average Price (MAP) method.

The finance team needs to ensure that the transition to MAP does not disrupt the ongoing accounting processes and that it aligns with the company's strategic financial objectives. They must consider the impact of this change on the material ledger, future purchase orders, and the overall inventory valuation in SAP MM.

Given this scenario, which of the following actions should the finance team take to effectively manage the transition from Standard Price to Moving Average Price for Material X, ensuring seamless integration with SAP MM functionalities and financial accounting requirements?

Options are included in the question text for clarity.
A: Immediately change the price control setting from Standard Price (S) to Moving Average Price (V) in the material master record of Material X, and revaluate existing inventory at the current market price.
B: Implement a dual valuation approach, where both Standard Price and Moving Average Price are used concurrently for Material X to hedge against market volatility.
C: Adjust the Standard Price periodically to reflect market changes until the transition to Moving Average Price is feasible, minimizing the impact on financial reporting.
D: Directly update the price control setting to Moving Average Price without adjusting the existing inventory valuation, relying on future transactions to normalize the valuation.
E: Conduct a thorough impact analysis on financial reports and inventory valuation under both price control methods before making any changes to the material master record.

Medium

Matrix Eigenvalues and Diagonalization
Linear Algebra
Matrix Operations
Solve
Consider the following code snippet:
 image
After running this code, which of the following statements is true regarding the B matrix?

Medium

Matrix Manipulation
Matrices
Lists
Solve
Consider the following pseudo code:
 image
What will be the state of list_of_matrices after running the script?
 image

Hard

Median
Trend Analysis
Statistical Reasoning
Solve
 Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.
 image

Easy

Meetings
Listening Comprehension
Solve
Escucha atentamente este audio y di cuál de las siguientes respuestas es la correcta:
A: Todas las reuniones son necesarias.
B: Solo son necesarias las reuniones que duran menos de 20 minutos.
C: El momento más productivo del día son las reuniones.
D: Las reuniones innecesarias suponen una pérdida de dinero.
E: Las reuniones innecesarias te hacen perder tiempo y dinero.
F: Las reuniones innecesarias te hacen perder tiempo y concentración.

Medium

Memory Map
Memory Architecture
Solve
Review the following Embedded Systems code and memory map of 16-bit microcontroller:
 image
 image
Here are the specifications of the microcontroller:

- The stack grows from area D, whereas the program and static variables are stored in area C
- ‘int’ in the system is a 16-bit number
- There is no operating system and no memory protection
- The program is compiled and loaded into area C
Pick the correct statements:

A: first_var, second_var and input will be in area D
B: first_var and second_var will be in area C, input will be in area D
C: If the contents of 0x0010 at the start of the program is 7, the program will print 0 and exit
D: If the contents of 0x0010 at the start of the program is 42, the program will print 0 and exit
E: If the contents of 0x0010 at the start of the program is 42, the program will overflow the stack overwriting the program and static variables region
F: If the program overflows and overwrites the program and static variables region, arbitrary data is executed as if it is the program, causing unpredictable results

Medium

Merge into live branch
Solve
Which of the following commands will merge dev-fixes into the master-live branch?

a. git checkout master-live and git merge dev-fixes
b. git checkout dev-fixes and git merge master-live
c. git merge master-live and git checkout dev-fixes
d. git merge dev-fixes and git checkout master-live

Medium

Method Overriding
Constructors
Inheritance
Method Overriding
Solve
Consider the following Dart code:
 image
What will be the output of the above Dart code?
 image

Hard

ER Diagram and minimum tables
ER Diagram
Solve
Look at the given ER diagram. What do you think is the least number of tables we would need to represent M, N, P, R1 and R2?
 image
 image
 image

Medium

Missing element
Solve
Which of the following figures do you think would complete the pattern shown below?
 image
 image

Easy

Missing element
Solve
Which of the following figures do you think would complete the pattern shown below?
 image

Medium

Mixed Methods Research
Data Analysis
Comparative Study
Solve
A mixed-methods study was conducted by Dr. Garcia to understand the effects of digital literacy programs on academic performance in high school students. The study comprised both quantitative and qualitative components:

Quantitative Data:
- 200 students participated, with 100 in the digital literacy program (Group A) and 100 not enrolled in any program (Group B).
- Pre-test and post-test scores were collected. The average score improvement in Group A was 15%, whereas Group B showed an average improvement of 5%.

Qualitative Data:
- Interviews with 30 students from each group were conducted.
- 20 out of 30 students in Group A reported increased confidence in research and assignments.
- 15 out of 30 students in Group B felt overwhelmed by the increasing digital demands of their coursework.

Dr. Garcia concluded several impacts of the digital literacy program on students' academic performance. Based on the given data, identify which conclusion is most supported by both the quantitative and qualitative findings.
A: Digital literacy programs have no significant impact on students' academic performance.
B: Students not enrolled in digital literacy programs perform better academically.
C: Digital literacy programs primarily improve students' confidence, with little impact on academic performance.
D: The digital literacy program significantly improves academic performance and student confidence.
E: Students in digital literacy programs only show improvement in confidence, not in academic performance.
F: The increasing digital demands of coursework negatively impact all students equally.

Easy

n-gram generator
Solve
Our newest machine learning developer want to write a function to calculate the n-gram of any text. An N-gram means a sequence of N words. So for example, "black cats" is a 2-gram, "saw black cats" is a 3-gram etc. The 2-gram of the sentence "the big bad wolf fell down" would be [["the", "big"], ["big", "bad"], ["bad", "wolf"], ["wolf", "fell"], ["fell", "down"]]. Can you help them select the correct function for the same?
 image

Medium

Modifying lists
Apex
Solve
Review the following Salesforce Apex code:
 image
What would the values of size1 and size2 be?

Medium

Unwind
Solve
Given the following movies document in MongoDB, What will be the output of the query:
 image

Medium

Indexing Sorting
Solve
Given the following sample document in Mongodb:

{ x: 5, y: 3, z: 2, w: 1 }
If the collection name is 'adaface' with a compound index { x: 1, y: 1, z: 1, w: 1}, which of the following queries will not use in-memory sorting?
 image

Hard

Movie query problem
Solve
Our intern created the following model scope
 image
and they want to use in this view:
 image
Which of these code snippets they use to fetch the correct results, and avoid the N+1 query issue?
 image

Medium

Multi Dimensional Arrays
Arrays
Data Processing
Subroutines
Solve
Consider the following pseudocode snippet in COBOL:
 image
After executing this program, what will be the final state of StrArr?

Medium

Multi Select
JOIN
GROUP BY
Solve
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Medium

Multi-source Data Aggregation
Data Transformation
Joins
Lookup
Aggregation
Data Filters
Solve
You're working with three different data sources in a Talend job: a MySQL table (users), an Oracle table (transactions), and a CSV file (rewards). The goal is to create a report containing the user's name, total transaction amount, and reward points, but only for users who have both made a transaction and earned rewards. Here are the key columns from each source:

- users: user_id, user_name
- transactions: trans_id, user_id, amount
- rewards: reward_id, user_id, points

Which of the following sequences best accomplishes this?
A: Use tMySQLInput, tOracleInput, and tFileInputDelimited in parallel -> tDenormalize to combine all results. Filter and aggregate results using tMap and then pass to tOutput.
B: Use tMySQLInput and tOracleInput in parallel -> tJoin to combine results on user_id. Use tFilterRow to filter transactions and then join the filtered result with tFileInputDelimited using tMap.
C: Use tMySQLInput -> tMap to join with tOracleInput based on user_id. Use another tMap to join the result with tFileInputDelimited. Aggregate results using tAggregateRow based on user_name, and filter using tFilterRow.
D: Use tMySQLInput -> tMap to join with tOracleInput based on user_id. Then, join the result with tFileInputDelimited on user_id. Apply filters in tMap to exclude rows where users neither made a transaction nor earned rewards.
E: Use tMySQLInput -> tMap to lookup and join with tFileInputDelimited based on user_id. Then, join this result with tOracleInput using another tMap. Apply filters in the final tMap to only include the desired rows.

Medium

Multi-tasking
Multi-tasking
Solve
Review the following Embedded Systems code:
 image
Here’s the specification for the program:
- first_var and second_var are global variables shared among several threads
- first_lock and second_lock are mutex locks that protect access to first_var and second_var
- Reads and writes to variables first_var and second_var are not guaranteed to be atomic
- No locks must be acquired unnecessarily
- Acquire second_var lock first before acquiring first_var lock by any thread that is going to use both first_var and second_var
Assume that if a thread attempts to acquire a lock it already holds, then it is immediately granted the lock. Pick the correct statements:

A: The provided code does not meet the specification completely since second_lock is not acquired before acquiring first_lock for procedure 'foo'

B: Replacing foo with logic of foo1 makes sure locks are not acquired unnecessarily and  second_lock is acquired before acquiring first_lock

C: Replacing foo with logic of foo1 makes sure second_lock is acquired before acquiring first_lock but there are cases when second_lock is acquired unnecessarily (when first_var < input)

D: Replacing foo with logic of foo2 makes sure locks are not acquired unnecessarily

E: Replacing foo with logic of foo2 is optimized version of foo1 but there are cases when second_lock is still acquired unnecessarily (when first_var value changes from the time ‘res’ value is computed and by the first_lock is acquired again.

Medium

Multibranch Pipeline Strategy
Pipelines
Build Strategies
Solve
A Jenkins multibranch pipeline is configured to build projects from a version control system (VCS) with multiple branches. The pipeline is set up with specific build strategies to optimize resource usage and build times. The Jenkins administrator needs to ensure that the pipeline:

1. Automatically triggers builds for the 'master' and 'develop' branches upon new commits.
2. Does not automatically build feature branches but allows manual builds.
3. Automatically builds a branch if it has a pull request open with the 'master' branch.

Which combination of build strategies and configurations should the Jenkins administrator use?
A: Enable SCM polling, add a regular expression to include 'master' and 'develop', and use the Pull Request build strategy.
B: Use the Discover Branches strategy with filters for 'master' and 'develop', and the Pull Request build strategy with a target branch filter for 'master'.
C: Enable SCM polling with a cron expression, use a script to exclude feature branches, and add a webhook for pull request events.
D: Use the Discover Branches strategy, add a regular expression to exclude feature branches, and enable webhooks for pull request events.
E: Enable SCM polling for all branches, use the Discover Tags strategy, and add a post-receive hook in VCS for 'master' and 'develop'.
F: Use the Discover Branches strategy for all branches, add a property to manually trigger builds for feature branches, and use the Pull Request build strategy.

Medium

Multidimensional Data Modeling
Multidimensional Modeling
OLAP Operations
Data Warehouse Design
Solve
As a senior data warehouse engineer at a large retail company, you are tasked with designing a multidimensional data model to support complex OLAP (Online Analytical Processing) operations for retail analytics. The company operates in multiple countries and deals with a wide range of products. The primary requirement is to enable efficient analysis of sales performance across various dimensions such as time, geography, product categories, and sales channels.

The source data resides in a transactional system with the following tables:

- Transactions (Transaction_ID, Date, Store_ID, Product_ID, Quantity, Unit_Price)
- Stores (Store_ID, Store_Name, Country, Region)
- Products (Product_ID, Product_Name, Category, Supplier_ID)
- Suppliers (Supplier_ID, Supplier_Name, Country)

You need to design a schema in the data warehouse that facilitates fast querying for aggregations and comparisons along the mentioned dimensions. Which of the following schemas would best serve this purpose?
A: A star schema with a central fact table linking to dimension tables for Time, Store, Product, and Supplier.
B: A snowflake schema where dimension tables for Store, Product, and Supplier are normalized.
C: A galaxy schema with separate fact tables for Transactions, Inventory, and Supplier Orders, linked to shared dimension tables.
D: A flat schema combining all source tables into a single wide table to avoid joins during querying.
E: An OLTP-like normalized schema to maintain data integrity and minimize redundancy.
F: A hybrid schema using a star schema for frequently queried dimensions and a snowflake schema for less queried, more detailed dimensions.

Medium

Transactions spanning multiple services
Solve
Which of the following are responsible for handling transactions spanning multiple services?
 image

Medium

Multithreading
Application Factory
Thread-Safety
Context Management
Solve
Examine the advanced Flask application setup below which uses an application factory pattern and is intended to handle multiple user requests simultaneously using threading. The developer has configured an endpoint to perform data processing based on user inputs and global settings. However, the application might exhibit unexpected behavior due to its handling of the Flask context and multithreading. Your task is to determine the output of this setup under concurrent requests.

The pseudo-code for the Flask application is as follows:
 image
In this code, the threads are launched almost simultaneously. Thread1 executes a POST request to /set_cache, and Thread2 executes a GET request to /get_data. What is the likely output of Thread2 when it runs concurrently with Thread1?
A: "Using Cache"
B: "Not Using Cache"
C: The output is non-deterministic, depending on the execution timing of Thread1 and Thread2.
D: A Flask RuntimeError due to the application context being improperly managed.
E: No response due to a deadlock in resource access between the threads.

Easy

Music app design
Solve
We have hired a designer to create the design for our new music app. Can you review the design and point out the core issue? We are yet to add images, so you can ignore that aspect.
 image

Medium

Mutable Sample
Structs
Variables and Mutability
Solve
What does the following Rust code print?
 image

Medium

Mutex Locks
Mutex
Goroutines
Concurrency
Solve
Consider the following Go program:
 image
What is the expected output of the final counter when the program is run?

Easy

MX Record, DMARC and Email Authentication
DNS
MX Records
DMARC
SPF
DKIM
Solve
You work as a network administrator for a company, "example.com", that recently started experiencing issues with email spoofing. To mitigate the problem, you decide to implement DMARC (Domain-based Message Authentication, Reporting & Conformance) in addition to existing SPF (Sender Policy Framework) and DKIM (DomainKeys Identified Mail) records.

Your current DNS records for example.com include the following:

- MX 10 mail.example.com (IP address 203.0.113.10)
- TXT "v=spf1 ip4:203.0.113.10 -all"
- TXT "v=DKIM1; k=rsa; p=public-key-here"

You add the following DMARC record:

- TXT "_dmarc.example.com" "v=DMARC1; p=quarantine; pct=100; rua=mailto:report@example.com"

After implementing the DMARC record, an external mail server sends an email to your domain. The email passes the SPF and DKIM checks but fails the DMARC check.

What will likely happen to the email?
A: The email will be accepted and delivered to the recipient's inbox.
B: The email will be rejected and returned to the sender as undeliverable.
C: The email might be delivered to the recipient's spam or junk folder.
D: The email will be accepted, but a report will be sent to the sender.
E: The email will be silently discarded, and the sender will not be notified.

Medium

My Module
Scope
Solve
What will the output of the following JavaScript code be?
 image
 image

Medium

Exists Where
Solve
Consider the following MySQL tables:
 image
What cids are returned by the following MySQL query for the above instance of the tables?
 image

Medium

Count, Distinct, SubQuery
Solve
Consider the following MySQL tables:
 image
What will be the output of the following MySQL query?
 image

Medium

Having, Group By
Solve
Consider the following MySQL table. 
 image
How many rows are returned for following MySQL query?
 image

Easy

Mystery function return value
Solve
What do you think mystery(15, 4) will return?
 image

Medium

Negative correlation
Solve
Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study?
A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level.

B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. 

C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. 

D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.

Medium

Nested Runspaces
Runspaces
Variable Scoping
Concurrency
Solve
You're optimizing a script for performance by leveraging runspaces to execute tasks concurrently. Each runspace is supposed to increment a shared counter object. Here's your setup:
 image
You expect the $global:counter to be 5 after all runspaces complete. However, it's not consistently reaching that value. What's the most probable reason for this behavior?
A: Runspaces can't access global variables.
B: The counter increment operation is not thread-safe, leading to race conditions.
C: The runspace pool size is limiting the number of concurrent operations.
D: The $global:counter initialization should be inside the script block.
E: The runspace pool's Close and Dispose methods are prematurely terminating the runspaces.

Medium

Net cash receipt on issued bonds
Solve
Gajni Inc. issued 2000 $100 9% bonds on May 1 (year 1). These bonds are issued at 103 plus accrued interest. The bonds are dated Jan 1 (year 1) and mature on Jan 1 (year 5). Interest needs to be paid twice a year (Jan 1 and July 1). The cost of issuing the bonds, $5000 was paid by Gajni Inc. to the investment bank. What would be the net cash receipt realized by Gajni Inc. from the issuance of these bonds?

Medium

Network Rules
Virtual Private Cloud
SSH
Solve
Depp works as Google Cloud Architect at Amber Inc. Deep created an instance with following firewall rules:
NAME: ssh-allow
NETWORK: testnet
DIRECTION: INGRESS
PRIORITY: 100
ALLOW: tcp:22

NAME: deny-everything
NETWORK: testnet
DIRECTION: INGRESS
PRIORITY: 400
DENY: tcp:0-65535,udp:0-6553
What would happen if Depp tries SSH to the instance now?

A: SSH would be denied as the deny rule overrides the allow
B: SSH would be allowed as the allow rule overrides the deny
C: SSH would be denied and would need instance reboot for the to allow rule to take effect
D: SSH would be denied and would need gcloud firewall refresh command for the allow rule to take effect

Medium

Network Traffic Anomaly
Network Traffic Analysis
Network Protocols
Solve
You are a cybersecurity engineer working on a network traffic analysis case. You have been given the following set of observations from network logs of the past 24 hours:

- Observation 1: 1,000,000 DNS requests were recorded, 50% more than the usual daily traffic.
- Observation 2: 85% of these DNS requests have the same subdomain but different domain names.
- Observation 3: For each of these DNS requests, an HTTP POST request follows immediately.
- Observation 4: No other significant anomalies were detected in the system logs.

Given these observations, what would you suspect is happening?
A: The network is experiencing a DNS amplification attack
B: There is a misconfiguration in the DNS settings
C: The system is the source of a SYN flood attack
D: A fast-flux DNS network is in operation
E: The system is infected with a DNS tunneling based malware

Easy

Res methods
Solve
If none of the methods (res.download, res.end, res.json, res.jsonp, res.redirect, res.render, res.send, res.sendFile, res.sendStatus) are called from a route handler to terminate request response cycle, what happens to the the client request?
A) Will be left hanging indefinitely

B) Will get an internal server error - 500 

C) Will get a service unavailable error - 503

D) Will be left hanging for a while and then request timeout error - 408

Medium

Normalization Process
Normalization
Database Design
Anomaly Elimination
Solve
Consider a healthcare database with a table named PatientRecords that stores patient visit information. The table has the following attributes:

- VisitID
- PatientID
- PatientName
- DoctorID
- DoctorName
- VisitDate
- Diagnosis
- Treatment
- TreatmentCost

In this table:

- Each VisitID uniquely identifies a patient's visit and is associated with one PatientID.
- PatientID is associated with exactly one PatientName.
- Each DoctorID is associated with a unique DoctorName.
- TreatmentCost is a fixed cost based on the Treatment.

Evaluating the PatientRecords table, which of the following statements most accurately describes its normalization state and the required actions for higher normalization?
A: The table is in 1NF. To achieve 2NF, remove partial dependencies by separating Patient information (PatientID, PatientName) and Doctor information (DoctorID, DoctorName) into different tables.
B: The table is in 2NF. To achieve 3NF, remove transitive dependencies by creating separate tables for Patients (PatientID, PatientName), Doctors (DoctorID, DoctorName), and Visits (VisitID, PatientID, DoctorID, VisitDate, Diagnosis, Treatment, TreatmentCost).
C: The table is in 3NF. To achieve BCNF, adjust for functional dependencies such as moving DoctorName to a separate Doctors table.
D: The table is in 1NF. To achieve 3NF, create separate tables for Patients, Doctors, and Visits, and remove TreatmentCost as it is a derived attribute.
E: The table is in 2NF. To achieve 4NF, address any multi-valued dependencies by separating Visit details and Treatment details.
F: The table is in 3NF. To achieve 4NF, remove multi-valued dependencies related to VisitID.

Medium

nth highest sales
Nested queries
User Defined Functions
Solve
Consider the following SQL table:
 image
Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?
 image

Medium

Null Dates in tJavaRow
Java Programming
Null Safety
Date Manipulation
Exception Handling
Solve
You're designing a Talend job to process e-commerce transactions. Each record has an "interactionType" field and a lastPurchase date field. For records with "SALE" as the interaction type, you want to calculate the number of days since the lastPurchase. However, the lastPurchase field can be null due to certain circumstances.

Here's the Java code within the tJavaRow component:
 image
Which of the following statements is TRUE regarding the code?
A: If the lastPurchase field is null, the code will throw a runtime exception.
B: The daysSinceLastPurchase field is set to -1 solely in case of a date parsing error.
C: All records with "SALE" as the interaction type will invariably have a non-negative daysSinceLastPurchase value.
D: The code inherently assumes that every transaction of type "SALE" contains a valid lastPurchase date.

Easy

Odd one out
Solve
From the shapes given below select the odd one out.
 image

Medium

Omni-Channel Harmony
Omni-Channel Marketing
Customer Lifetime Value (CLV)
Customer Segmentation
Solve
ShopElite Fashions has recently expanded its e-commerce platform, while still operating its flagship physical stores. The brand is eager to unify customer experiences across channels. Here are the current challenges and insights:

1. Channel Preferences: The brand's physical stores are popular for the older clientele due to tactile buying experiences and personal customer service. In contrast, younger customers lean heavily on e-commerce due to its convenience.
2. Purchase Behavior: The in-store shopping experience leads to infrequent, but high-ticket purchases. E-commerce witnesses frequent but lower-ticket transactions.
3. Feedback: Both segments feel the rewards and incentives are skewed towards the other group.
4. Communication Channels: Email campaigns have a high open rate among older clientele, whereas younger customers engage more with the brand on social media.
5. Cross-channel engagement: Only 10% of customers have shopped on both channels.

In light of the above, as ShopElite's CMO, which of the following would be MOST important part of a strategy to harmonize the omni-channel experience?
A: Introduce in-store tech experiences, such as augmented reality mirrors, targeting younger clientele to give them a taste of both online and offline world.
B: Diversify communication channels
C: Roll out a tiered loyalty program, where points can be accrued from both online and offline purchases, and benefits increase with cross-channel shopping behaviors, encouraging integration.
D: Launch a series of promotional campaigns, offering heavy discounts online to attract the older clientele and in-store events for the younger audience.
E: Rebalance the product offerings, focusing on exclusive online-only and in-store-only ranges to compel customers to engage with both channels.

Medium

onCompletion method call
Solve
Do you know when the onCompletion() method is called?
 image

Medium

Optimal Data Replication and Consistency in Distributed Systems
Data Consistency
Load Balancing
Fault Tolerance
Solve
Consider a distributed e-commerce platform designed to handle high traffic volumes and ensure data consistency across its services. The platform uses a distributed database that replicates data across multiple nodes to increase availability and performance. To balance the load, it employs a load balancer that distributes user requests evenly across these nodes. The system is designed to tolerate the failure of up to two nodes without affecting the platform's overall availability.

Given the critical requirement for strong consistency to prevent issues such as overselling of products, the system uses a consensus algorithm for replication. The database is configured with a replication factor of 5, meaning each piece of data is stored on 5 nodes. For read and write operations to be considered successful, they must be acknowledged by a majority of the nodes involved in the operation.

Assuming all nodes have equal hardware resources and network latency between nodes is negligible, which of the following configurations would best meet the platform's requirements for high availability, performance, and strong consistency?
A: Reads require acknowledgment from 2 nodes, and writes require acknowledgment from 4 nodes.
B: Reads and writes both require acknowledgment from 3 nodes.
C: Reads require acknowledgment from 3 nodes, and writes require acknowledgment from 2 nodes.
D: Reads and writes both require acknowledgment from 4 nodes.
E: Reads require acknowledgment from 1 node, and writes require acknowledgment from 5 nodes.
F: Reads and writes both require acknowledgment from 5 nodes.

Medium

Optimizing Personalization Strategy
Email Personalization
Segmentation
Subscriber Engagement
Solve
You're an email marketer for a large retail company. Your current email strategy involves sending the same weekly newsletters to all subscribers. Despite these newsletters being packed with quality content and attractive offers, the engagement rates have been underwhelming.

In response to this, you're considering adopting a personalization strategy. Which of the following options best reflects a robust personalization strategy that could improve engagement?
A: Sending birthday and holiday greetings to each subscriber.
B: Segmenting the subscribers based on their geographical location and sending location-specific offers.
C: Segregating subscribers based on their past purchases and sending product recommendations accordingly.
D: Allowing subscribers to choose the type of content they wish to receive.
E: Segmenting subscribers based on their engagement levels (open rates, click-through rates) and tailoring the content accordingly.
F: Sending personalized product recommendations based on the browsing behavior of each subscriber on your website.

Medium

Optimizing Query Performance
Indexing
Query Optimization
Solve
You are managing a DB2 database which includes a table named `ORDERS`. The `ORDERS` table has a large volume of data and contains the following columns: `OrderID`, `CustomerID`, `OrderDate`, `ProductID`, `Quantity`. 

One of the frequently executed queries on the `ORDERS` table is:
 image
You are asked to optimize this query without changing its structure or the table schema. Which of the following strategies would MOST likely improve the performance of this query?
A: Create a HASH index on `CustomerID` and `OrderDate`.
B: Create a CLUSTERED index on `CustomerID` and `OrderDate`.
C: Create a NONCLUSTERED index on `CustomerID` and `OrderDate`.
D: Create a CLUSTERED index on `OrderID`.
E: Create a NONCLUSTERED index on `OrderID`.

Medium

Optimizing Query Performance
Query Optimization
Indexing Strategies
Data Partitioning
Solve
As a senior data warehouse developer, you are tasked with optimizing query performance in a large-scale data warehouse that primarily stores transactional data for a global retail company. The data warehouse is facing significant performance issues, particularly with certain types of queries that are crucial for business operations. After analysis, you identify that the most problematic queries are those that involve filtering and aggregating transaction data based on time periods (e.g., monthly sales) and specific product categories.

The main transaction table (Transactions) in the data warehouse has the following structure and characteristics:

- Columns: Transaction_ID (bigint), Transaction_Date (date), Product_ID (int), Quantity (int), Price (decimal), Category_ID (int)
- Row count: Approximately 2 billion rows
- Most common query pattern: Aggregating Quantity and Price by Category_ID and Transaction_Date (e.g., total sales per category per month)
- Current indexing: Primary key index on Transaction_ID, no other indexes

Based on this information, which of the following approaches would most effectively optimize the query performance for the given use case?
A: Add a non-clustered index on Transaction_Date and Category_ID.
B: Normalize the Transactions table by splitting Transaction_Date and Category_ID into separate dimension tables.
C: Implement partitioning on the Transactions table by Transaction_Date, and add a bitmap index on Category_ID.
D: Convert the Transactions table to use a columnar storage format.
E: Create a materialized view that pre-aggregates data by Category_ID and Transaction_Date.
F: Increase the hardware capacity of the data warehouse server, focusing on CPU and memory upgrades.

Medium

Optimizing Query Performance
Indexing
Join Optimization
Execution Plans
Solve
You are managing a SQL Server database for a large e-commerce platform. The database contains the following tables:
 image
Users often run a query to retrieve all orders from a specific date along with customer details and a breakdown of each order. Lately, this query has been performing poorly, especially on days with a high volume of orders.

Given this schema, which of the following changes would MOST LIKELY enhance the performance of this query?
A: Create a non-clustered index on Orders(OrderDate, OrderID) and a clustered index on OrderDetails(OrderID).
B: Create a clustered index on Orders(CustomerID, OrderDate) and a non-clustered index on OrderDetails(ProductName).
C: Increase the size of the OrderDetails(ProductName) column and add more RAM to the SQL Server machine.
D: Create a clustered index on Orders(OrderDate) and a non-clustered index on OrderDetails(OrderID, Quantity).
E: Partition the Orders table on OrderDate and create a non-clustered index on OrderDetails(DetailID, Price).

Medium

Order keys and partition keys
Informatica BDM
Solve
You are the owner of a coffee and tea shop. You want to calculate the best-selling and second best-selling coffee and tea products.
The following table lists the products, the corresponding product categories, and the revenue from each product:
 image
In Informatica Windowing tab, you enter "Revenue (Descending)" as value for Order Keys and "Category" as value for Partition Keys. Which of the following represents the final result?
 image

Medium

Orderly Restoration of RDS with Transaction Logs
RDS
Transaction Logs
Point-in-time recovery
Solve
You work as a database manager for a fintech company that uses an AWS RDS PostgreSQL instance. The company abides by stringent data security standards, which require minimal data loss in the event of database failures or accidental data modifications.

Unexpectedly, an operation that updates a significant number of records in a crucial transaction table is mistakenly run. You discover that this operation occurred at 12:45 PM. Your RDS PostgreSQL instance is configured to perform automated backups every day at 1:00 AM, with transaction logs being backed up every 5 minutes. Furthermore, there is a manual DB snapshot taken at 11:00 AM on the same day. 

To restore the database with minimal data loss, considering the sequence and order of log application, which of the following steps should you execute?
A: Restore from the manual DB snapshot at 11:00 AM, then perform a point-in-time recovery to 12:45 PM.
B: Perform a point-in-time recovery to 12:45 PM.
C: Restore from the last automated backup at 1:00 AM, then apply all transaction logs until 12:45 PM.
D: Restore from the manual DB snapshot at 11:00 AM, then apply transaction logs from 11:00 AM to 12:45 PM.
E: Perform a point-in-time recovery to 11:00 AM, then apply transaction logs from 11:00 AM to 12:45 PM.

Medium

Organization data
Data transformation
Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:
 image
We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Medium

OSPF Inter-Area Route Filtering
OSPF Configuration
Route Summarization
Routing Control
Solve
In a large service provider network, five OSPF areas are configured: Area 0 (Backbone), Area 1, Area 2, Area 3, and Area 4. Area 1 is a normal area, Area 2 is configured as a stub area, Area 3 is a totally stubby area, and Area 4 is an NSSA (Not So Stubby Area). Each area has multiple routers and networks. Router X in Area 1 has an external route (E2) to the network 172.30.0.0/16 and is connected to Area 0. Router Y in Area 2 summarizes its internal routes to 192.168.0.0/18. Router Z in Area 3 has a default route to Area 0 and an external route to 10.20.0.0/16 redistributed as an N2 route in Area 4.

Given this configuration, which of the following statements is true when a packet is routed from a network in Area 4 to 172.30.0.0/16?
A: The packet will be dropped because NSSA does not allow external routes to be advertised into the area.
B: The packet will be routed to Router X via Area 1, as Area 4 allows the redistribution of external routes into the area as N2 LSAs.
C: The packet will traverse through Area 0 to reach Router X, which advertises the external route to 172.30.0.0/16.
D: The packet will take a default route from Area 3 to Area 0, as Area 3 is a totally stubby area and does not have specific route information for 172.30.0.0/16.
E: The packet will be routed directly to Router Y in Area 2 due to the summary route, which incorrectly captures the 172.30.0.0/16 network.
F: The packet will be routed to Router Z in Area 3, which has a specific external route to 172.30.0.0/16.

Medium

OSPF Network Analysis
OSPF Configuration
OSPF Troubleshooting
Routing Loops
Solve
As a senior network engineer, you are investigating an issue in an OSPF (Open Shortest Path First) network. The network consists of various routers configured in multiple areas, with Area 0 as the backbone. Recently, intermittent routing loops and instability have been reported. Upon reviewing the configurations and logs, you notice the following key points:

1. Area 0 is functioning normally with stable LSA (Link State Advertisement) exchanges.
2. A non-backbone area (Area 1) is showing frequent LSA refreshes and topology changes.
3. Routers in Area 1 have multiple OSPF neighbors, including an ABR (Area Border Router) connecting to Area 0.
4. The ‘show ip ospf database’ command reveals numerous LSA types 3 (Summary LSAs) and 5 (External LSAs) being frequently updated in Area 1.

Which of the following actions is most likely to resolve the routing instability and loops in Area 1?
A: Redistribute static routes into the OSPF process on the ABR, focusing on stabilizing Area 1.
B: Configure Area 1 as a stub area to reduce the number of Type 5 LSAs.
C: Implement route summarization on the ABR between Area 0 and Area 1.
D: Increase the SPF algorithm calculation timers to reduce LSA refresh frequency.
E: Convert Area 1 to a Totally Stubby Area to filter out Type 3 and Type 5 LSAs.
F: Adjust OSPF priorities on routers in Area 1 to elect a more stable DR (Designated Router).

Medium

Output rows
Solve
Musk joined as SAP HANA administrator at Grimes Inc. While working on HANA database, Musk noticed the following:
1: While joining the tables P and Q, Number of rows in the output is equal to row count P multiplied by row count in Q
2: Log area is filling continuously and causing database to hang
Which of the following statements are correct?

A: Musk is using Outer Join to join P and Q
B: Musk is using Self Join to join P and Q
C: Musk is using Cross Join to join P and Q
D: Musk can limit file size to fix the log area issue
E: Musk can use backint destination type to fix the log area issue
F: Musk can enable automatic log backup to fix the log area issue

Easy

Overlapping Location Blocks
Server Configuration
Request Handling
Solve
An Nginx server is configured with multiple `location` blocks that overlap in their path specifications, leading to potential ambiguity in request handling. Given the following configuration snippets, identify which `location` block will handle a request to the URL `/images/thumbnails/large/photo.jpg`:

1. `location = /images/thumbnails/large/photo.jpg { ... }`
2. `location ^~ /images/thumbnails/ { ... }`
3. `location ~* \.(jpg|png)$ { ... }`
4. `location /images/ { ... }`
A: Location block 1 will handle the request because it exactly matches the request URI.
B: Location block 2 will handle the request because it matches the prefix and disables regex checking.
C: Location block 3 will handle the request because it matches the case-insensitive regex for file extensions.
D: Location block 4 will handle the request because it has the longest matching prefix.
E: All of the above location blocks will handle the request in the order they are defined.

Medium

Overwhelmed users
Usability
Information Architecture
Solve
Liam, a UX designer, is working on an app that allows users to learn multiple languages. The app provides language lessons, quizzes, progress tracking, and a community forum. Feedback from users revealed:

1. Users find it difficult to navigate between different features of the app.
2. Users feel overwhelmed by the amount of content in each language module.
3. Users appreciate the comprehensive nature of the language lessons.

Considering this feedback, which design approach should Liam take to address these issues?
A: Adding more features to provide a more comprehensive learning experience.
B: Simplifying the language lessons to reduce content.
C: Implementing a more effective information architecture and reducing cognitive load.
D: Incorporating more visual elements like images and animations.
E: Providing an option for users to customize their learning modules.
F: Integrating a voice assistant to guide users through the app.
G: Reducing the number of languages offered to simplify the app.

Easy

P Q relations
Pig
Solve
Consider the following two relations, P and Q:
 image
What is the output of the following Pig command?

Q = GROUP P BY p2;
DUMP Q;
 image

Medium

Package: Destroy
OOPs
Solve
What does the following Perl code print?
 image

Medium

Package: Use Base
OOPs
Solve
What does the following Perl code print?
 image

Easy

Page layouts and Records
Profiles
Solve
Adaface uses Salesforce CRM for managing the sales process. The sales team is divided into Team A and Team B. Team A focuses on first two stages of the opportunity. Team B which has senior sales representatives focuses on last three stages of the opportunity. As a Salesforce admin at Adaface, you are tasked with the following requirement:
- Team A should only have access to first two stages on Opportunity records. Other stages must be hidden for Team A.
- Team B should have access to final three stages on Opportunity records.
How do you achieve this?
 image

Medium

Page Object Class
Solve
Our frontend developer for bananas.com created this HTML login form. Which function should they use to implement a method of a Page Object Class for the login form?
 image
 image

Hard

Palindrome Test cases
Strings
Solve
Go through the following faulty palindrome detection pseudocode and test cases. For which of the test cases would the code return true?
 image
Testcases
A: a
B: aba
C: aaa
D: aac

Medium

Parent extension
Solve
Consider the following X++ class:
 image
Which of the following statements are correct?
A: The static method goo() in the base class can be wrapped and extended by adding business logic to the extension class
B: The extension class can be instantiated by ParentMy_Extension extension = new ParentMy_Extension()

Easy