CORRECT TEXT - (Topic 2)
In this exercise, you will create a UiPath automation that performs the steps below.
To achieve this, you will use the REFrameWork as the starting template and follow the UiPath development best practices.
Here are the steps performed by the Robot:
* 1. Log in to https://www.acme-test.com.
* 2. On the landing page, Dashboard, click on the Work items menu item. Scrape the data in all the pages of the table, page by page, ensuring error handling and recovery.
* 3. For each page: - Filter the records where Status is 'Open';
- Filter the records where Type is 'WI1';
- Filter the records where WIID is greater than 200000;
- Append the resulting datatable into an Excel worksheet, you shouldn't worry about the headers and format of the output file.
Constraints to follow in the development, using the REFrameWork:
* 1. TransactionItem datatype should be a String. The process should recover and retry in case of errors in navigation between WorkItems page. One transaction is the action of scraping one web page.By navigating to the next page, the next transaction will execute. (Same as ACME Process 4 Dispatcher from the UiPath Academy).
* 2. Create a separate workflow file for the Login to ACME. File input arguments: URL ; Username ; Password .
* 3. Create a separate workflow file for closing ACME.
* 4. Add the ACME_URL and ACME_Credential to the Config file.
* 5. Populate InitAllApplications.xaml from the Framework folder with Invoking the Login to ACME and navigation to the Work Items.
* 6. Populate CloseAllApplications.xaml from the Framework folder with Invoking the Close ACME.
* 7. Populate KillAllProcesses.xaml from the Framework folder with killing the process used.
* 8. Populate the Process.xaml file with the following actions: Web scraping, Filtering and Appending to Excel.
Important Note: Don't use external file references outside of the project folder (including Orchestrator Assets). Place all the used files within the project folder, zip that folder and upload it to the UiPath Certification Platform.
Zip ALL the used workflow files AND the output Excel file. Then upload the .zip file to the UiPath Certification Platform.
Good luck!
ALL THE BEST!
Solution:
Send us your feedback on this.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 2)
A developer wants to use a Write Cell and Read Range activities to work with an Excel file. The Excel file is protected for any modifications by a password, so unauthorized users can only read data. What should be done in order to ensure that the robot is able to write and read data from this file?

1. A. Password to this file should be provided in the "Edit Password" property and "Password" property of the Excel Application Scope activit
2. B. Password should be provided in a String format.
3. C. Password to this file should be provided in the "Edit Password" property of the Excel Application Scope activit
4. D. Password should be provided in a String format.
5. E. Password to this file should be provided in the "Password" property of the Excel Application Scope activit
6. F. Password should be provided in a String format.
7. G. Password to this file should be provided in the "Edit Password" property of the Excel Application Scope activit
8. H. Password should be provided in a SecureString format.

Correct Answer: B

Edit password property stores the password required for editing password-protected Excel workbooks, if necessary. Only String variables and strings are supported.
While the Password property stores the password required for opening and reading password-protected Excel workbooks, if necessary. Only String variables and strings are supported.
In this case, the file is only password-protected for editing, so unauthorized users can read the file, but not write any data. That means that the password for opening and reading is not required, only for editing. For that reason, only the Edit Password property should be filled in.

- (Topic 2)
Which of the following SQL statements can be executed by using the activity called Execute Non Query?
Options are :

1. A. Insert
2. B. Update
3. C. Select
4. D. Delete

Correct Answer: ABD

- (Topic 2)
While automating an installation wizard, a pop-up window may or may not appear. What can you use to close the window without stopping the workflow?

1. A. Use a Click activity inside a Try Catch activity.
2. B. Use a Click activity with the ContinueOnError property set to True.
3. C. Use a Click activity and set its TimeoutMS property to 30.

Correct Answer: AB

- (Topic 1)
A developer is creating an automation project which processes personal information of employees.
To protect sensitive information that is logged during the execution of the automation at the Verbose level, how can the developer avoid logging variable and argument values in both Orchestrator and Studio?

1. A. Store all sensitive information in an Excel file that the process can access.
2. B. Check the Isolated property when invoking a workflow with sensitive information.
3. C. Ensure all personal information variables are of the SecureString variable type.
4. D. Check the Private property on the activities that contain sensitive information.

Correct Answer: D
Reference: https://forum.uipath.com/t/hiding-sensitive-data/191563