MENU
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?
Suggested Answer: D
Get Premium PEGAPCRSA80V1_2019 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
CA
Casandra
10 months ago
Wait, are we sure about A? Sounds too simple.
LA
Lamonica
11 months ago
D seems unnecessary, just save after commit!
MO
Mozell
11 months ago
C sounds off, you don’t need to reload the file.
FR
Francine
11 months ago
I think B is misleading, changes don’t save automatically.
SH
Shalon
11 months ago
A is definitely the right choice!
NA
Narcisa
12 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.
JA
Jacob
12 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.
LO
Lore
12 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.
RY
Ryann
1 year ago
I think I remember that changes don't save automatically, so option B seems wrong.
DE
Dexter
1 year 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.
IO
Iola
1 year 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.
BE
Belen
1 year 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.
DE
Devorah
1 year 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.
MI
Mindy
1 year 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.
PE
Pedro
1 year 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.
CR
Cristy
1 year 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.
AN
Annamaria
1 year ago
Option D seems a bit odd. Why would I need to reset the state of the Excel file? That doesn't sound necessary.
LE
Leatha
1 year ago
Option D seems a bit odd. Why would I need to reset the state of the Excel file? That doesn't sound necessary.
VI
Vicky
1 year ago
C) Call the Commit method of the ExcelConnector and reload the Excel file.
TR
Truman
1 year ago
B) The changes save to the Excel file automatically.
JO
Joesph
1 year ago
A) Call the Commit method of ExcelRange component and then Save on the ExcelConnector.
RO
Ronald
1 year 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.
DO
Dorcas
1 year 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.
LE
Lea
1 year ago
Yes, I always follow that sequence when working with ExcelRange components. It helps to avoid any data loss.
LA
Lai
1 year ago
I think so too. It's important to ensure that the changes are properly committed before saving the Excel file.
MA
Maryanne
1 year ago
I agree, Option A seems like the correct choice. Committing the changes first and then saving the file makes sense.
GE
Georgene
1 year 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.
JU
Julie
1 year ago
User 3: Yeah, it would be more convenient if the changes save automatically.
HY
Hyun
1 year ago
User 2: I think you're right, we shouldn't have to manually call any methods.
GI
Gianna
1 year ago
User 1: Option B seems correct, the changes should save automatically.
RE
Renea
1 year ago
I'm not sure, but I think it might be C.
MA
Mable
2 years ago
I disagree, I believe the correct answer is D.
DO
Douglass
2 years ago
I think the answer is A.