XMAS ANALYT 2501

41. What type of predictive scenario can write back to a planning model?. Regression. Value driver tree. Classification. Time series forecast.

42. How can you improve the performance of advanced data actions? (3 correct answers). Use fewer MEMBERSET statements. Use fewer FOREACH functions. Use fewer IF statements. Use fewer data functions. Use fewer aggregation dimension functions.

43. Where can you change a data lock status? (2 correct answers). Data action. Value lock management. Multi action. Calendar task.

44. You are entering values for several expense accounts in a data table. Which data entry mode must you use to process the data with a delay defined in System Administration?. Fluid. Single. Mass.

45. You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers. Which dimension setting controls how much is distributed to each operating cost center?. Reference. Driver. Distribute. Redistribute.

46. What can you do with a multi action? (2 correct answers). Run allocation data actions. Import transaction data. Approve data. Run allocation processes.

47. You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. How can you do this?. Use two properties. Disable allocations. Use two hierarchies. Disable distribution.

48. You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?. Unbooked. Append. Signflip. Aggregate To.

49. 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?. Level. Hierarchy. Cardinality. Granularity.

50. You are creating a script for an advanced data action. Which character designates a virtual variable member?. %. /. *. #.

51. Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, and Customer Name. You want to aggregate measures for these columns as a single column. What can you do?. Create a group that includes the dimensions. Create a level-based hierarchy in the dataset. Create a parent-child hierarchy in the dataset. Convert the embedded dataset to a model.

52. What are the available connection types in SAP Analytics Cloud? (2 correct answers). Live. On-premise. Cloud. Import.

53. What can you use to organize dimensions into logical categories in a live model?. Parent-child hierarchy. Value driver tree. Groups. Level-based hierarchy.

54. What source system can you connect to with a live connection?. SAP Business ByDesign Analytics. SAP Datasphere. SAP SuccessFactors. SAP ERP Central Component.

55. You are using a live connection for a model. Where can you define data security?. Data access control. SAP Analytics Cloud model. SAP Analytics Cloud role. Source system.

56. You are using a live connection for a model. Where is the data stored?. Embedded dataset. SAP Analytics Cloud model. Source system. Public dataset.

57. You need to delete characters from a column in a dataset. What can you use? (2 correct answers). Calculation editor. Transform bar. Formula bar. Custom expression editor.

58. You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure. How can you ensure that it is treated as a calendar year?. Includes the Year measure in a level-based time hierarchy in the dataset. Add the month as a suffix to the Year measure. Change the Year measure to a dimension in the dataset. Insert a character into the Year measure using the transform bar.

59. What must you use to transform data in a dataset using if/then/else logic?. Custom expression editor. Calculations editor. Formula bar. Transform bar.

60. You have a story based on an import model. The transaction data in the model´s data source changes. How can you update the data in the model? Note there are 2 corrects answers to this question. Refresh the story. Allow model import. Refresh the import job. Schedule the import.