SAC Certification

[malak_berri41]

Hello everyone, I’m currently preparing for the C_SAC_2501 exam, and I have some doubts about a few questions. Please, I would really appreciate your help to better understand the correct answer to each question.

How can you improve the performance of advanced data actions? Note:

There are 3 correct answers to this question.

Use fewer MEMBERSET statements
Use fewer aggregation dimension functions
Use fewer data functions
Use fewer FOREACH functions
Use fewer IF statements

-------------------------

What can you do with a multi action? 

Note: There are 2 correct answers to this question. 

• Run allocation processes 

• Approve data 

• Run allocation data actions 
• Import transaction data 

---------------------------------------

You are creating a data action to copy data from one year to the next. 

In the parameter for the source year, which default setting must you change? 

• Granularity 

• Level 

• Hierarchy 

• Cardinality 

------------------------------------

When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question. 

• Enable Keeping member names visible 

• Freeze Dimension Header Column 

• Enable Auto-Size and Page Table Vertically 

• Freeze Dimension Header Row 

-----------------------------------------------------

What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question. 

• Avoid tables with more than 500 rows and 60 columns 

• Load widgets in the background 

• Avoid prompts 

• Use responsive pages 

• Use conditional formatting 

---------------------------------------------------

What is the main benefit a business user can gain from using SAP Business Data Cloud:  

• Data Management 

• Data Analysis 

• Data Integration 

• Data Intelligence 

Thanks!!

[priscilla_barbosa82]

Hi!

A few answers that i think its correct...

Anwser
Use fewer data functions
Use fewer FOREACH functions
Use fewer IF statements
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/fa558b0ff273475c8f3cf...

answer
Run allocation data actions
Import transaction data

Anwser
Hierarchy
"For copy rules based on the date dimension, you can select one or more non-leaf members at the same hierarchy level as the source member (for example, Q1 to Q2, or 2018 to 2018 and 2019)."
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a27d8405ac9b4e7bb8e50...

Answer
Freeze Dimension Header Row

[femisasa]

Hello Malak,

I hope you’re doing well and your exam preparation is going smoothly.

I’ll also be taking the same exam soon and would appreciate your insight—could you share what study resources you’re using?

If it’s convenient, feel free to reach me at femisasa@gmail.com. I’d be happy to connect and exchange Knowledge!

Looking forward to your response.

Best regards,
Femi Sasa