CE EXAM QUESTIONS for reference.docx

**USER INPUTS** =============== 1. What is the purpose of api.inputBuilderFactory()? 2. When api.inputBuilderFactory() is executed alone what it returns? 3. What is the use of getInput() and how it works? 4. In what format the input is created in the server? 5. What are other the other met...

**USER INPUTS** =============== 1. What is the purpose of api.inputBuilderFactory()? 2. When api.inputBuilderFactory() is executed alone what it returns? 3. What is the use of getInput() and how it works? 4. In what format the input is created in the server? 5. What are other the other methods rather than getInput() and in what context it is been used? 6. What is the type of userentry()? 7. How api.isInputGenerationExecution() is utilized? 8. Does every entry will work as same as the intellij in the UI if it differs what are the types that differs and how? 9. Is there any other way to create inputs? If yes for what kind of types and how? 10. How inputs are generated in intellij? **API** ======= ### **api.isDebugMode()** 1. How it works? 2. Where it can be used? ### **api.isabortCalculation()** 1. What is the purpose of this? 2. Does it abort calculation once in the logic or once in the execution mode? 3. Once this api is used, does the element return any value? 4. Does, the remaining elements get executed or not? 5. How its character differs in execution mode and input generation mode? 6. What it returns? ### **api.find()** 1. How many parameters can be passed in api.find()?and what are they? 2. Can we use api.find() for retrieving company parameters table? If yes then what is the difference between api.lookuptablevalues() and api.find()? 3. What are the limitations of api.find()? 4. What is the difference between api.find and api.stream()? 5. Does the results directly stored in memory? 6. Will it work in input generation mode? 7. What is the limit of records that is returned by api.find()? 8. What if the data exceeds the limit? 9. What if we sort an numeric field using sort parameter in api.find()? 10. What api.getMaxFindResultsLimit() returns? 11. How can we get all the data if it is beyond the limit? 12. If we specify the list of fields while passing the parameter what will be the out type of individual fields? 13. Can aggregate functions can be used in api.find()? If yes how, if not why? ### **api.stream()** 1. What is the difference between api.stream() and api.find()? 2. api.stream() returns? 3. Do we manually need to store the result? 4. Is there any limitations on api.stream()? 5. How many parameters can be passed in api.stream()?and what are they? 6. What are the drawbacks of api.stream()? 7. Will it work in input generation mode? ### **api.product()** 1. What is the difference of retrieving products using api.find() and api.product()? 2. What api.product() returns in input generation mode? 3. How many parameters can be passed in api.product()? and what are they? 4. How it works? 5. What if the attribute is passed and what if not? Explain this scenario in both the modes? ### **api.customer()** 1. What is the difference of retrieving products using api.find() and api.customer()? 2. What api.customer() returns in input generation mode? 3. How many parameters can be passed in api.customer()?and what are they? 4. How it works? 5. Can the value of the Customer input parameter can be also inherited from the parent? 6. What if the attribute is passed and what if not? Explain this scenario in both the modes? ### **api.productextension()** 1. What is the difference of retrieving products using api.find() and api.productextension()? 2. What api.productextension() returns in input generation mode and what should be passed as a parameters? 3. How many parameters can be passed in api. productextension()?and what are they? 4. How it works? ### **api.customerextension()** 1. What is the difference of retrieving products using api.find() and api.customerextension()? 2. What api. customerextension() returns in input generation mode and what should be passed as a parameters? 3. How many parameters can be passed in api. customerextension()?and what are they? 4. How it works? ### **api.vLookup()** 1. What is the difference of retrieving products using api.find(),api.findlookuptablevalues() and api.vLookup()? 2. What api.vLookup() returns in input generation mode and what should be passed as a parameters? What happens if we pass keys? 3. How many parameters can be passed in api.vLookup()?and what are they? 4. What if any one of the key is not found in the company parameter table that we passed in vLookup()? 5. If there are two Company Parameter / Price Parameter tables with the same name (uniqueName) and status=\"ACTIVE", records will be fetched from which table? 6. What is the return type of api.vLookup()? ### **api.findLookupTable()** 1. What is the difference between api.findLookupTable() and api. findLookupTableValues()? 2. When it is executed in the logic what it returns? 3. How many parameters can be passed in api.findLookupTable()? and what are they? 4. Is there any other way to get company/price parameter table object rather than using api. findLookupTable()? 5. Will it work in input generation mode? ### **api.findLookupTableValues()** 1. How many parameters can be passed in api. findLookupTableValues()? and what are they? 2. What is the role of cache provider parameter and what is being cached in which format and what is the purpose of it? 3. Will it work in input generation mode? 4. When it is executed in the logic what it returns? 5. Is there any other way to get company/price parameter table values rather than using api. findLookupTableValues()? 6. How it works? ### **api.getDatamartContext()** 1. For what it is used? 2. What it returns? 3. How can we access the calendar using api.getDatamartContext()? ### **api.getDatamartContext().getDataMart()** 1. How many parameters should be passed? 2. What it returns? 3. For what the parameter use refresh data is used? ### **api.getDatamartContext().getDataSource()/getDataFeed()** 1. How many parameters should be passed? 2. What it returns? ### **api.getDatamartContext().newQuery** 1. What it does? 2. How many parameters should be passed? 3. What if we didn't set the rollup parameter? 4. What it returns? 5. What are the parameters should be passed? ### **api.getDatamartContext().executeQuery()** 1. What are the parameters should be passed? 2. What it does? 3. What is the structure of this result of both data and summary? 4. How can we get the data? 5. How can we get the summary? 6. Where will we use getDistinctvalues() and what is the parameter that should be passed and what will be the result? 7. What does the summary contain? **MASTER DATA** =============== 1. Master data is stored in which database and why? 2. Mention the number of attributes we can have for all the tables? 3. What are the various types of Company/Price parameter table? 4. What is user group edit in PX and CX table configuration? 5. What is Data Change Request? Explain its use cases. 6. What are the type codes for the master data tables? 7. How Product table and their extension tables are connected? 8. How customer table and their extension tables are connected? 9. Where can we see the detailed list of fields is available in Studio? 10. PBOME and PXREF is the type code of? 11. How many attributes are there in competition data table? Is it limited? 12. Can extension tables have more than a key? 13. In matrix type of look up table what is the maximum number of keys we can have? 14. Can we remove or add attribute columns? 15. In the customization of a particular attribute, RESTRICT VALUES plays what role? and how it can be utilized? 16. What are the several types of Product/Customer Extension tables? 17. There are two tables which share the same type code PX3, can we query it just using the type code? 18. While querying company parameter table using api.find() is it necessary to mention the id of the table? If yes then explain why, if not tell what it returns? 19. What are the various ways to initialize filters in code? 20. For the table with the type code of PX3, if we use PX as a type code and mention its table name while filtering does it return the correct table? 21. What is api.namedEntities()? How it is used and for what? What are the limitations of it? 22. Why tables are categorised into masters and extensions why can't we have all the data in a single table? **ANALYTICS** ============= 1. While querying the data can we use aggregate functions? if yes then how? 2. What is the difference between select and selectAll? is there any difference in execution time? 3. What is orderby? How it is used? What is syntax? 4. Can we groupby the data by more than a one parameter? How? 5. How the filters are incorporated in queries? 6. Where can we use having() while quering? 7. Is having() and where() methods are same? 8. What is selectDistinct() and selectCount()? What is the difference between them? Explain a scenario to define the both cases. 9. What does selectId() do?can we use it in a rollup query? 10. What is setOptions()?In what scenarios it can be used? 11. For a rollup datamart query is there any internal limit? If yes what will be the result if it is exceeded and what will be the limit?what can we do instead of this? 12. Can we able to set limit of roll up datamart query? How? 13. What is the default limit of execute query? 14. In what aspects toResultMatrix() is used and compare it with collect()?Explain the difference between them. 15. How many characters can contain the text type field in Data source or marts? 16. What is the type LOB? And what it is the maximum size of it? 17. What is the difference between DF, DM and DS? 18. How these tables are getting populated? ### **DATASOURCE** 1. What is the use of templates? 2. What are the functions of key, Alt-key and Level? 3. What does the data type UOM mean? 4. Why we have to configure the measures while adding quantity or money fields? 5. What are those measures and explain every one of them and their difference? 6. What is use of dimension and hidden checker box? 7. How the expression field can be utilized? 8. Can we change the definition of the data source by using the json structure? 9. Can we add multiple fields at a time? 10. Scenario: you added some fields and changed some of the fields characteristics and you didn't deploy. Does the changes will be made? 11. What are data entitlements? 12. What is the use of purge cache? 13. Can you upload data manually? 14. If you will the data will be incremented or completely replace the data already available? 15. Scenario: you applied some filters in the data and exported the data. The exported data will only contain the filtered data or the whole table? 16. What is status history? 17. In data source settings of a particular data source you can witness a logic field. What is the use of it? ### **DATAFEED** 1. What Is the difference between data feed and data source? 2. What is the use of field separator in data feed settings? 3. How can we push the data from feed to source? ### **DATAMART** 1. What are the various functions available in datamart? 2. What is use of Pricing date? if you made a field as pricing date what will be the result? would any fields get added? If yes what is the function of them? 3. What does the per unit basis and percent basis functions mean? 4. What is the use of expression fields here? Why some of them are not editable? 5. What is the use of base currency and base UOM in the datamart settings? 6. What is the use of field picker? 7. On what basis the fields in the data picker is generated? 8. Mass edit is used for? 9. How datamarts are populated? 10. How the data from source is transferred to mart? 11. Do the values in the data source and datamart will be same or will it change based on expressions and measures? If yes how it will be changed and what will be the difference? ### **DATALOAD** 1. For what internal copy data load is used for? 2. What are the different types of data load? And explain the use case of every one of them. 3. What is the difference between the - Internal Copy data load type used to populate products and product type data load? If we can load the products data with the help of internal copy data load then why there is a separate data load type for products? - Internal Copy data load type used to populate customer and customer type data load? If we can load the customers data with the help of internal copy data load then why there is a separate data load type for customers? 4. What are different types of calculation context? 5. For what calendar data type is used? 6. What is model calculation type? 7. What is publishing data type? 8. Simulation data type is used for? 9. What are the data loads that will be automatically created and when? 10. What are the various types of status and what each one of them means? 11. Can we able to modify the target in automatically generated data load? 12. When the source will be selected in the data load? 13. Do load date influence the updation of the data? 14. What is the use of target snapshot check box? 15. Allow batching is used for? 16. In what cases validation logic is used and what is the nature of that? 17. What will happen if you check the incremental check box? 18. You are loading the data for the very first time by checking the incremental check box. What will happen? Will it throw any exception? 19. How Can we schedule a dataload? 20. What is the nature of the logic used for calculation data load? 21. In Init context is there any field mapping required? 22. What is the difference between the init and row context? 23. How can you access the value in the current row in row context which will be later used for calculation? 24. What are the things that should be noted while returning init context calculation dataload? 25. What are the things that should be noted while returning row context calculation dataload? 26. The result field name and the element name which returning the result in row context is not same. What will happen? 27. Calculation context summary means? 28. What are the different types of mode in distributed dataload? ### **DASHBOARD** 1. Nature of the dashboard's logic? 2. Dashboards are configured in? 3. What does dynamic inputs mean? 4. What is the use of hide and category? 5. What is create action icon on dashboards page? 6. What are the various dashboards? **PRICELIST** ============= ### **PRICE SETTING** 1. What are two price setting types? 2. Contextual actions are used for? 3. Header logic is used for and what its nature? 4. What is the pricing logic and its nature? 5. How is matrix logic and matrix logic element connected? 6. Can we have two keys in pricelist? 7. Custom action logics is used for and its nature? ### **PRICELIST** 1. What is the use of dynamic UOM and Dynamic currency? 2. What will happen if you enabled the allow distribution calculation checkbox? 3. For getting the current line item which api has to be use? 4. if we didn't abort the input generation after getting the input, will the pricelist get generated? 5. Can we use api.currentitem() to access the line item? Explain. 6. Where the result element should be configured in the UI? 7. What is the difference between normal and matrix pricelist? 8. What is the nature of the logics used in matrix pricelist calculation? 9. How should we segregate the logics? 10. Can a pricelist with critical errors can be submitted? 11. What is the use of summary option in pricelist? 12. What is manual override? 13. What does the price change and price change pct column indicate? 14. If we didn't select the input that is being generated by the logic while configuring. Will the pricelist get's generated? 15. Can we create revisions for a pricelist? 16. When will the pricelist become superseded? 17. What are the various statuses of pricelist? explain. 18. Can we dynamically add products to pricelist? 19. Do we able to convert Pricelist to LPG? How? ### **WORKFLOW** 1. What is the nature and workflow type for pricelist? 2. If the name of the pricelist workflow is "geographicalpricelistworkflow" will it work? 3. When will be the workflow triggered? 4. Once the pricelist is approved what will happen? ### **LPG** 1. What is the difference between pricelist and live price grids? 2. Does the workflow here work's as same as the pricelist's workflow or not? 3. Workflow type for LPG? 4. What are mass actions in LPG? 5. Can we dynamically add products to LPG? 6. What is the use of dynamic item mode? 7. What is the use of Dynamic Item Filter? 8. Manual Price expiry and Auto-Approve is used for? 9. Increase and decrease threshold is used for? 10. While choosing output elements for what change trigger approval is used for? 11. Do we able to convert LPG to Pricelist? How? ### **PRICE SETTING SIMULATION** 1. Price setting simulation is used for? 2. Can we able to create pricelist simulation for a pricelist that is not already exists? 3. How it is being configured? 4. What are the important points to be noted before creating simulation? 5. Can price setting simulation also be generated for LPG? **QUOTES** ========== ### **QUOTES HEADER** 1. What is the nature of the logic of quote header? 2. What are phases in the quote header? 3. When will these phases will get executed? 4. What is the binding variable for quote? 5. How to test whether the quote is in prephase or postphase? 6. How can we able to add or update the inputs in the quote header? 7. By using getinput() method in input generation will the input gets generated in theheader? 8. What are the parameters should be passed for creating the input at the header level? 9. For accessing the output of the line item in the header item what can be used? 10. Is there any other way to access line item output rather than using "quoteProcessor.quoteView.lineitems.outputs"? if yes how? 11. How can we add or update the output in header level? 12. Do we able to hide system generated inputs at header level if not needed? How? 13. What is the difference between recalculate and recalculate changes? ### **QUOTES LINE ITEM** 1. How the input at the header level can be accessed in the line item level? 2. How the inputs at line item level can be generated? 3. For getting the current line item which api has to be use? 4. What is the nature of the logic? 5. Can we attach e signature in quotes while sending the email? 6. What is the maximum number of attachments than can be made? If we want to attach more what can we do? 7. What is dirty item run? ### **WORKFLOW** 1. What is the nature and workflow type for Quote? 2. If the name of the pricelist workflow is "geographicalQuoteworkflow" will it work? 3. When will be the workflow triggered? 4. Once the Quote is approved it is converted into? 5. If we have to convert the quote directly into deal once it is approved what should we have to do? 6. Once it is converted into deal what will happen? 7. How to get line & header items inputs and outputs in workflow? **ERROR HANDLING AND EXCEPTION** ================================ 1. For arithmetic operation how the null exceptions will be handled? 2. What is the difference between yellow alert, Red alert, critical alert, Warning and Exception? 3. Only when the exception should be thrown? **WORKFLOW** ============ 1. How the workflow is being configured? 2. What is the purpose of workflow? 3. What is the binding variable for workflow? 4. How to get binding variable in library functions? 5. How steps are configured in workflow creation? 6. How individual and group approvers are set? 7. How the reasons are passed? 8. How watcher's step is configured?