New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Pegasystems PEGAPCRSA80V1_2019 Exam - Topic 18 Question 64 Discussion

Actual exam question for Pegasystems's PEGAPCRSA80V1_2019 exam
Question #: 64
Topic #: 18
[All PEGAPCRSA80V1_2019 Questions]

In an automation that contains an ExcelRange component, you make a change to the data within the range, and you want to save those changes to the Excel file on disk.

Which of the following statements is valid?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters
Casandra
3 months ago
Wait, are we sure about A? Sounds too simple.
upvoted 0 times
...
Lamonica
3 months ago
D seems unnecessary, just save after commit!
upvoted 0 times
...
Mozell
3 months ago
C sounds off, you don’t need to reload the file.
upvoted 0 times
...
Francine
4 months ago
I think B is misleading, changes don’t save automatically.
upvoted 0 times
...
Shalon
4 months ago
A is definitely the right choice!
upvoted 0 times
...
Narcisa
4 months ago
I think option D sounds right because it mentions saving and resetting, but I can't recall the exact steps we went over in class.
upvoted 0 times
...
Jacob
4 months ago
I want to say that calling the Commit method is important, but I'm confused about whether it's for the ExcelRange or the ExcelConnector.
upvoted 0 times
...
Lore
4 months ago
I feel like we practiced something similar, but I'm not sure if it's the Commit method or the Save method we need to use.
upvoted 0 times
...
Ryann
5 months ago
I think I remember that changes don't save automatically, so option B seems wrong.
upvoted 0 times
...
Dexter
5 months ago
I'm pretty confident that the answer is A. The question specifically states that you want to save the changes to the Excel file, so you'll need to call both the Commit and Save methods to make that happen.
upvoted 0 times
...
Iola
5 months ago
Option B seems like the easiest solution, but I'm not sure if that's actually how it works. I'll need to double-check the documentation to make sure I understand the proper way to save changes to the Excel file.
upvoted 0 times
...
Belen
5 months ago
Hmm, I'm a bit confused on this one. I'm not sure if the changes save automatically or if I need to do something specific. I'll have to think this through carefully.
upvoted 0 times
...
Devorah
5 months ago
I think the answer is A. You need to call the Commit method on the ExcelRange component to save the changes, and then call the Save method on the ExcelConnector to actually write the changes to the file.
upvoted 0 times
...
Mindy
5 months ago
Let me see... The Control Plan is definitely one thing, but what's the other deliverable? A Call List? A Chain-of-Command? I'm drawing a blank here. I'll have to make an educated guess on this one.
upvoted 0 times
...
Pedro
5 months ago
Hmm, this seems tricky. I'm not sure if the Affiliations and Relationships associated with the Contacts would also prevent the deletion, or if it's just the Closed/Won donations. I'll have to think this through carefully.
upvoted 0 times
...
Cristy
9 months ago
I'm going with Option B. Automatic saving? Sign me up! Although, I do wonder if the Excel file will just spontaneously combust after I make my changes. That would be an interesting test case.
upvoted 0 times
...
Annamaria
9 months ago
Option D seems a bit odd. Why would I need to reset the state of the Excel file? That doesn't sound necessary.
upvoted 0 times
Leatha
8 months ago
Option D seems a bit odd. Why would I need to reset the state of the Excel file? That doesn't sound necessary.
upvoted 0 times
...
Vicky
8 months ago
C) Call the Commit method of the ExcelConnector and reload the Excel file.
upvoted 0 times
...
Truman
8 months ago
B) The changes save to the Excel file automatically.
upvoted 0 times
...
Joesph
8 months ago
A) Call the Commit method of ExcelRange component and then Save on the ExcelConnector.
upvoted 0 times
...
...
Ronald
10 months ago
Hmm, Option C is interesting. Committing through the ExcelConnector and then reloading the file sounds like a good way to ensure the changes are properly saved.
upvoted 0 times
...
Dorcas
10 months ago
I think Option A is the way to go. Committing the changes to the ExcelRange and then saving the file feels like the right sequence of events.
upvoted 0 times
Lea
9 months ago
Yes, I always follow that sequence when working with ExcelRange components. It helps to avoid any data loss.
upvoted 0 times
...
Lai
9 months ago
I think so too. It's important to ensure that the changes are properly committed before saving the Excel file.
upvoted 0 times
...
Maryanne
9 months ago
I agree, Option A seems like the correct choice. Committing the changes first and then saving the file makes sense.
upvoted 0 times
...
...
Georgene
10 months ago
Option B seems correct, the changes should save automatically. I don't want to have to manually call any methods, that sounds like too much work.
upvoted 0 times
Julie
9 months ago
User 3: Yeah, it would be more convenient if the changes save automatically.
upvoted 0 times
...
Hyun
9 months ago
User 2: I think you're right, we shouldn't have to manually call any methods.
upvoted 0 times
...
Gianna
9 months ago
User 1: Option B seems correct, the changes should save automatically.
upvoted 0 times
...
...
Renea
10 months ago
I'm not sure, but I think it might be C.
upvoted 0 times
...
Mable
10 months ago
I disagree, I believe the correct answer is D.
upvoted 0 times
...
Douglass
11 months ago
I think the answer is A.
upvoted 0 times
...

Save Cancel