Archives

Basic Office Skills

Welcome to the BPS Basic Office Skills exam.  The test consists of 20 multiple choice questions.  There is a 10 minute time limit.

What is the shortcut key to insert a page break in MS Word?

What is the keyboard shortcut for copying selected text in MS Word?

What is the shortcut key to undo the last action in MS Word?

How do you change the margins of a document in MS Word?

Which of these are placed at the end of a document?

Which of the following can you perform using the ruler (select all that apply)?

Which feature would you use to combine a list of names and addresses with a preformatted document or template?

How can you zoom in and out of a Word document (select all that apply)?

How do you edit the header in a Word document?

How do you insert a chart into Word?

What is the purpose of the IF function in Excel?

Which of the following is an absolute reference to cell A5?

What is a Relative Reference in Excel?

How can you reference data across worksheets in Excel?

How can you format a date in Excel (select all that apply)?

How can you hide columns or rows in Excel (select all that apply)?

How can you copy a worksheet in Excel (select all that apply)?

What is the purpose of filtering data in Excel?

What is the purpose of freezing columns or rows in Excel?

How can you create a comment in Excel?

Thank you.  Your submission has been received and will be reviewed shortly.

MS Excel Skills Exam

Welcome to your MS Excel Skills Exam


Goal: Using the name typed in cell A8, return the corresponding email address from the table in cell B9.

Instructions: Complete the formula below by typing the missing function that is used to return a value based on a matching value in a table.

= (A8,EmployeeTable,4,FALSE)


Goal: Using the name typed in cells A9 and B9 (first name, last name), return the corresponding email address from the table in cell C9.

Instructions: Complete the formula below by typing the missing function used in conjunction with MATCH in order to return the email address based on multiple criteria.

{= (EmployeeTable2[Email],MATCH(A9&B9,EmployeeTable2[First Name]&EmployeeTable2[Last Name]))}


Goal: Return a value of "Pass" in cell B3 if the score is 70 or above, or a value of "Fail" otherwise.

Instructions: Fill in the missing piece of the following IF formula in order to achieve this.

=IF( ,"Pass","Fail")


Goal: Create an absolute reference to cell A2 in cell C2.

Instructions: Complete the formula to achieve this.

=

What are the advantages of converting spreadsheet data into a table in MS Excel?  (Select all that apply):

Which of the following are pivot tables used for?  (Select all that apply):

Selenium Beginner

Welcome to your Selenium Beginner

A selenium tester wants to log information before, after and during an event is triggered. Which Selenium feature can be used to achieve this goal?  

A tester wants to store web elements of the Application Under Test (AUT) together with their locator values, in one or more centralized locations as opposed to hard coding them within the test scripts. Which of the following can be used to achieve this? 

Each web page in the application is required to have its own corresponding page class. The page class is thus responsible for finding the WebElements in that page and then perform operations on those WebElements. In Selenium, what is the name of this Design pattern?

How can you a take a screenshot using Selenium WebDriver?  

A web page throws a confirmation/alert pop-up box and to continue the automation process the program needs to reject/cancel the alert message and go to the next step in the test script.  How can this be done?  

In a testing operation, a tester wants to continue the execution even if there is a failure in the testing process so that other test cases can be verified and the operation is not stuck at a single point of failure. The tester finds that every time the test script faces an execution error the test script stops and does not go to the next testing stage.  The script uses Junit Assert class.  Which one of the following statements is true?  

Note: There can be multiple correct answers to this question.  

How do you attach a file from local storage to a webpage attachment content element?  

Implicit wait can be used to:  

  1. Wait for a page to load
  2. To look for a specific element on a page and timeout if the element does not load within the specified value
  3. To halt the execution until the time a particular execution condition is met  

Which of the following locator type is not available in Selenium? 

What is DOM? 

Your new question!

LoadRunner Skills Competition

Welcome to your LoadRunner Skills Competition

Customer says they need 95th percentile response time value for all transactions. Your scenario has 10 vusers which you know will generate at least 90 observations for each transaction. Your colleague says you must change your scenario to ensure 95th percentile can be calculated by LoadRunner. You decide to:

For LoadRunner Agent to be running in process mode on a Windows machine, what must be true?

You have 10 observations for response times (all in seconds) - 1,2,3,4,5,6,7,8,9,10. The correct values for average and 90th percentile are:

Your test scenario has 200 vusers. Beyond 50 vusers, you notice that response times stayed the same but Total transactions per second and Throughput (bytes) went down. You decide to:

Your script has a LoadRunner parameter called ticket_amount. In order to print its value for debugging purpose the right code is:

A character array called username can be declared in C as follows:

Run-time settings in the Controller allow you to select either thread or process mode for running your test. You prefer:



The following declaration in a vuser script:



Captionless Image



You can create blocks in run-logic:

Receive Request Timeout value should be:

Customer's website allows keyword search (e.g. "Orville Wright Airplane") of all patent documents dating back to the 1950s. You have parameterized the search terms. Due to large expected load the number of vusers required in the scenario is ~1000. The system is known to cache the search results. The preferred data selection should be set to:

Sequential data selection setting for a parameter should be used:

lr_param_sprintf can be used to create a new parameter from a string.

IP spoofing configuration on a Windows Load Generator:

To prevent making requests during replay to hosts in a web HTTP/HTTP script that are of no interest to you (say external sites outside of your organization), you can:

VTS can be used:



The picture below shows Analysis results for a web application. Average hits per second shown is the same as





Captionless Image

Your customer has strict Response Time SLAs. You ran a test but forgot to add SLAs in the scenario before running it. You can:

A test scenario has 50 vusers. Think time is set to vary randomly between 50% to 150% of the recorded value. Pacing is set to 10 seconds. The test script has 5 transactions. The 95% response time SLA is 5 seconds. The test results indicate the SLAs were met. Customer asks if the system can support 50 simultaneous users in production. You say:

The vuser_init and vuser_end actions:

A client site has a homepage with several images, CSS and JS resources needed to render the page and wants to evaluate the performance for first-time users. The Web/HTTP script, with default Run-Time Settings, has a web_custom_request step with mode=HTML.  Select the most efficient strategy to download all the resources in order to simulate a browser page load:

A system is known to have 100 concurrent users at peak load.  In a scenario designed to simulate this load you would need 100 Vusers.

Sr. Performance Test Engineer Screening Exam

Customer says they need 95th percentile response time value for all transactions. Your scenario has 10 virtual users which you know will generate at least 90 observations for each transaction. Your colleague says you must change your scenario to ensure 95th percentile can be calculated. You decide to:

Your test scenario has 200 vusers. Beyond 50 vusers, you notice that response times stayed the same but Total transactions per second and Throughput (bytes) went down. You decide to:


  1. Imagine a small store with a single clerk and an area for browsing products and no one leaves without buying something.  A customer enters the store, browses available products, selects one of them, pays for it at the counter and then exits the store.  Assume that this is a stable system (the arrival rate at which people enter the store is the same as their exit rate) and think time is defined as time spent by customers browsing the products before getting in line to pay for their selection.


If 30 customers were seen entering the store in a 60-minute interval and each customer spent 10 minutes in the store before leaving, what was the average number of customers in the store during this time? 

IP spoofing configuration

Select the statement that is false.

During a 10 minute interval, you observe a JEE application server processing requests at a rate of 40 per second.  You also know that a request requires 0.02 seconds to process.  The application server has 8 processors and 256 GB RAM.  What is the overall utilization of the system?

Given the following definitions for a storage system:
A:  Time taken to service an I/O request by a disk excluding wait time
B:  Total response time
C:  B - A

What is the relationship between HTTP, TCP and IP protocols?

Given the following definitions-

Think time: Time spent by users between successive requests to a system
Throughput: Rate of requests processed by a system in requests/second
Response time: Time elapsed from the moment users submit a request until they receive a response

Imagine a web application that has three completely independent subsystems.  You run a performance test, and find out that the failure rates of the three subsystems are as follows:
A - 2%
B - 3%
C - 4%

What can you say about the overall reliability of the system (assume that reliability refers to the system returning valid responses)

LoadRunner Skills Competition

Welcome to your LoadRunner Skills Competition

Customer says they need 95th percentile response time value for all transactions. Your scenario has 10 vusers which you know will generate at least 90 observations for each transaction. Your colleague says you must change your scenario to ensure 95th percentile can be calculated by LoadRunner. You decide to:

For LoadRunner Agent to be running in process mode on a Windows machine, what must be true?

You have 10 observations for response times (all in seconds) - 1,2,3,4,5,6,7,8,9,10. The correct values for average and 90th percentile are:

Your test scenario has 200 vusers. Beyond 50 vusers, you notice that response times stayed the same but Total transactions per second and Throughput (bytes) went down. You decide to:

Your script has a LoadRunner parameter called ticket_amount. In order to print its value for debugging purpose the right code is:

A character array called username can be declared in C as follows:

Run-time settings in the Controller allow you to select either thread or process mode for running your test. You prefer:



The following declaration in a vuser script:



Captionless Image



You can create blocks in run-logic:

Receive Request Timeout value should be:

Customer's website allows keyword search (e.g. "Orville Wright Airplane") of all patent documents dating back to the 1950s. You have parameterized the search terms. Due to large expected load the number of vusers required in the scenario is ~1000. The system is known to cache the search results. The preferred data selection should be set to:

Sequential data selection setting for a parameter should be used:

lr_param_sprintf can be used to create a new parameter from a string.

IP spoofing configuration on a Windows Load Generator:

To prevent making requests during replay to hosts in a web HTTP/HTTP script that are of no interest to you (say external sites outside of your organization), you can:

VTS can be used:



The picture below shows Analysis results for a web application. Average hits per second shown is the same as





Captionless Image

Your customer has strict Response Time SLAs. You ran a test but forgot to add SLAs in the scenario before running it. You can:

A test scenario has 50 vusers. Think time is set to vary randomly between 50% to 150% of the recorded value. Pacing is set to 10 seconds. The test script has 5 transactions. The 95% response time SLA is 5 seconds. The test results indicate the SLAs were met. Customer asks if the system can support 50 simultaneous users in production. You say:

The vuser_init and vuser_end actions:

A client site has a homepage with several images, CSS and JS resources needed to render the page and wants to evaluate the performance for first-time users. The Web/HTTP script, with default Run-Time Settings, has a web_custom_request step with mode=HTML.  Select the most efficient strategy to download all the resources in order to simulate a browser page load:

A system is known to have 100 concurrent users at peak load.  In a scenario designed to simulate this load you would need 100 Vusers.

LoadRunner Applicant Screening Examination

Customer says they need 95th percentile response time value for all transactions. Your scenario has 10 virtual users which you know will generate at least 90 observations for each transaction. Your colleague says you must change your scenario to ensure 95th percentile can be calculated. You decide to:

Run-time settings in the Controller allow you to select either thread or process mode for running your test. You prefer:

Your test scenario has 200 vusers. Beyond 50 vusers, you notice that response times stayed the same but Total transactions per second and Throughput (bytes) went down. You decide to:

A character array called username can be declared in C as follows:



The following declaration in a vuser script:



Captionless Image



  1. Imagine a small store with a single clerk and an area for browsing products and no one leaves without buying something.  A customer enters the store, browses available products, selects one of them, pays for it at the counter and then exits the store.  Assume that this is a stable system (the arrival rate at which people enter the store is the same as their exit rate) and think time is defined as time spent by customers browsing the products before getting in line to pay for their selection.


If 30 customers were seen entering the store in a 60-minute interval and each customer spent 10 minutes in the store before leaving, what was the average number of customers in the store during this time? 

IP spoofing configuration



The picture below shows Analysis results for a web application. Average hits per second shown is the same as:





Captionless Image

A client site has a homepage with several images, CSS and JS resources needed to render the page and wants to evaluate the performance for first-time users. The Web/HTTP script, with default Run-Time Settings, has a web_custom_request step with mode=HTML.  Select the most efficient strategy to download all the resources in order to simulate a browser page load:

Select the statement that is false.

BPS Customer SS backup

Business Performance Systems strives to provide exceptional service to our customers, and we would like to offer you the opportunity to provide us with feedback regarding our staff and overall performance.  The following brief survey consists of 10 questions and should require no more than five minutes to complete.  Your time and comments are appreciated and valued, and we thank you in advance for your input.

Use the following guidelines for selecting the appropriate rating for each question:

Exceptional: Exceeds many contract requirments, and few minor problems.
Very Good: Exceeds some contract requirements, and some minor problems.
Satisfactory: Meets all contract requirements and some minor problems.
Marginal: Does not meet some contract requirments, and serious problems (recovery still possible).
Unsatisfactory: Does not meet many contract requirements, and serious problems (recovery not likely).

Please select the agency/contract you represent:

What is your role in this agency/contract? (optional)

Please share my individual feedback with the BPS project team.

Quality of our deliverables and services

Professionalism and capabilities of our staff

Ability to manage the schedule and keep the project on track

Responsiveness to issues, requested actions, etc.

Our price compared to other companies for similar services

Overall value of, and satisfaction with, our services

What did our team do particularly well?

Please suggest any opportunities for improvement for our team.

Which individuals performed exceptionally well?

Which individuals do you feel could benefit from improvement?

Thank you for filling out this survey.  Press 'Submit' when complete.

BPS Customer Satisfaction Survey

Business Performance Systems strives to provide exceptional service to our customers, and we would like to offer you the opportunity to provide us with feedback regarding our staff and overall performance.  The following brief survey consists of 10 questions and should require no more than five minutes to complete.  Your input is completely anonymous and will only be used to improve our performance.  Your time and comments are appreciated and valued, and we thank you in advance for your input.

Use the following guidelines for selecting the appropriate rating for each question:

Exceptional: Exceeds many contract requirments, and few minor problems.
Very Good: Exceeds some contract requirements, and some minor problems.
Satisfactory: Meets all contract requirements and some minor problems.
Marginal: Does not meet some contract requirments, and serious problems (recovery still possible).
Unsatisfactory: Does not meet many contract requirements, and serious problems (recovery not likely).
No Opinion: Not applicable or prefer not to answer.

Please select the agency/contract you represent:

What is your role in this agency/contract? (optional)

Please share my individual feedback with the BPS project team.

Quality of our deliverables and services

Professionalism and capabilities of our staff

Ability to manage the schedule and keep the project on track

Responsiveness to issues, requested actions, etc.

Our price compared to other companies for similar services

Overall value of, and satisfaction with, our services

What did our team do particularly well?

Please suggest any opportunities for improvement for our team.

Which individuals performed exceptionally well?

Which individuals do you feel could benefit from improvement?

Please provide any additional comments below.  If you would like us to contact you about your feedback, or have any additional questions, please provide your name and contact information.

Thank you for filling out this survey.  Press 'Submit' when complete.

LoadRunner Applicant Screening Examination

Customer says they need 95th percentile response time value for all transactions. Your scenario has 10 virtual users which you know will generate at least 90 observations for each transaction. Your colleague says you must change your scenario to ensure 95th percentile can be calculated. You decide to:

For LoadRunner Agent to be running in process mode on a Windows machine, what must be true?

You have 10 observations for response times (all in seconds) - 1,2,3,4,5,6,7,8,9,10. The correct values for average and 90th percentile are:

Your test scenario has 200 vusers. Beyond 50 vusers, you notice that response times stayed the same but Total transactions per second and Throughput (bytes) went down. You decide to:

Your script has a LoadRunner parameter called ticket_amount. In order to print its value for debugging purpose the right code is:

A character array called username can be declared in C as follows:

Run-time settings in the Controller allow you to select either thread or process mode for running your test. You prefer:



The following declaration in a vuser script:



Captionless Image



You can create blocks in run-logic:

Receive Request Timeout value should be:


  1. Imagine a small store with a single clerk and an area for browsing products and no one leaves without buying something.  A customer enters the store, browses available products, selects one of them, pays for it at the counter and then exits the store.  Assume that this is a stable system (the arrival rate at which people enter the store is the same as their exit rate) and think time is defined as time spent by customers browsing the products before getting in line to pay for their selection.


If 30 customers were seen entering the store in a 60-minute interval and each customer spent 10 minutes in the store before leaving, what was the average number of customers in the store during this time? 

Sequential data selection setting for a parameter should be used:

lr_param_sprintf can be used to create a new parameter from a string.

IP spoofing configuration

To prevent making requests during replay to hosts in a web HTTP/HTTP script that are of no interest to you (say external sites outside of your organization), you can:

VTS can be used:



The picture below shows Analysis results for a web application. Average hits per second shown is the same as:





Captionless Image

Your customer has strict Response Time SLAs. You ran a test but forgot to add SLAs in the scenario before running it. You can:

A test scenario has 50 vusers. Think time is set to vary randomly between 50% to 150% of the recorded value. Pacing is set to 10 seconds. The test script has 5 transactions. The 95% response time SLA is 5 seconds. The test results indicate the SLAs were met. Customer asks if the system can support 50 simultaneous users in production. You say:

The vuser_init and vuser_end actions: