Download NetSuite SuiteAnalytics Ultimate Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which operator should be used in a Saved Search criteria to ensure both conditions must be true? A) OR B) NOT C) AND D) XOR Answer: C Explanation: The AND operator requires that all conditions linked by it evaluate to true for a record to be returned. Question 2. In a Saved Search, how do you filter records that occurred within the last rolling 30 days? A) “Date is within last 30 days” B) “Date is on or after today-30” C) “Date is after today” D) “Date is between today and today+30” Answer: A Explanation: The “within last” relative date filter automatically calculates the rolling window based on the current date. Question 3. Which of the following is a limitation of a “single‑hop” join in Saved Searches? A) Cannot join more than two record types B) Cannot reference fields from a second‑level related record C) Cannot use summary criteria on joined fields D) Cannot export results to CSV Answer: B Explanation: Single‑hop joins only allow direct relationships; you cannot traverse two relationships (e.g., Transaction → Employee → Department) in one Saved Search. Question 4. When adding a Summary Type of “Group” to a column in a Saved Search, what effect does it have?
A) Calculates the total of numeric values B) Removes duplicate rows based on that column’s values C) Sorts the column alphabetically D) Highlights the highest value in the column Answer: B Explanation: Grouping aggregates rows that share the same value in the grouped column, effectively removing duplicates for reporting purposes. Question 5. Which Oracle SQL function would you use in a Saved Search formula to replace a null value with zero? A) TO_CHAR B) NVL C) NULLIF D) INSTR Answer: B Explanation: NVL(expression, replacement) returns the replacement when the expression is null, making it ideal for defaulting nulls to zero. Question 6. In a Saved Search formula (Text), which function extracts the first three characters of a field named {custbody_code}? A) SUBSTR({custbody_code},1,3) B) LEFT({custbody_code},3) C) MID({custbody_code},1,3) D) TRIM({custbody_code},3) Answer: A Explanation: SUBSTR(string, start_position, length) returns a substring; start_position is 1‑based in NetSuite formulas. Question 7. Which clause would you use in a CASE WHEN statement to assign “High” to records where {amount} > 10000? A) WHEN {amount} > 10000 THEN ‘High’
C) Filters D) Values Answer: B Explanation: Placing a time dimension in columns creates separate columns for each period, enabling side‑by‑side comparison. Question 11. Which chart type is most appropriate for showing revenue trends over the past 12 months? A) Stacked Bar B) Line C) Pie D) Scatter Answer: B Explanation: Line charts excel at visualizing continuous data trends over time. Question 12. In a Workbook Table View, how can you highlight rows where the “Quantity on Hand” is below the reorder point? A) Apply a Conditional Formatting rule on the column B) Sort the column descending C) Use a Summary Group on the column D) Set a KPI on the column Answer: A Explanation: Conditional formatting lets you set a rule (e.g., value < reorder point) that changes the row’s background or text color. Question 13. Which formula builder option lets you write a custom SQL expression that returns a numeric result? A) Formula (Text) B) Formula (Date) C) Formula (Numeric)
D) Formula (Currency) Answer: C Explanation: Formula (Numeric) is evaluated as a number and supports arithmetic and SQL functions returning numeric values. Question 14. In the Report Builder, what does the “Group with Previous” option do? A) Merges two adjacent groups into one line item B) Sorts groups alphabetically C) Adds a subtotal after each group D) Prevents grouping on the selected column Answer: A Explanation: “Group with Previous” forces the current row to be displayed under the same group header as the previous row, effectively merging them. Question 15. Which NetSuite role permission is required to edit a standard Income Statement report? A) Lists > Transactions B) Reports > Financial C) Setup > Customization D) Accounting > Manage Budgets Answer: B Explanation: The “Reports > Financial” permission grants access to view and customize financial reports, including the Income Statement. Question 16. When comparing current period performance to the prior year in a Financial Report, which feature should you enable? A) Alternate Date Range – Prior Year B) Multi‑Currency Conversion C) Drill‑Down to Transaction Detail Drill‑Down to Transaction Detail
Explanation: “Override” replaces the user’s layout entirely, while “Merge” adds new components but preserves existing customizations. Question 20. AI‑generated narratives in NetSuite primarily rely on which underlying technology? A) Rule‑Based Engine B) Large Language Model (LLM) C) Decision Tree D) Neural Network for Image Recognition Answer: B Explanation: NetSuite’s Narrative Insights use LLMs to interpret data and produce human‑readable summaries. Question 21. Which feature of NetSuite Analytics Warehouse (NSAW) makes it suitable for datasets larger than 5 million rows? A) In‑memory caching on the UI server B) Off‑loading queries to an Oracle Autonomous Data Warehouse C) Real‑time replication to a local Excel file D) Automatic summarization to CSV Answer: B Explanation: NSAW pushes heavy analytics workloads to a dedicated Oracle data warehouse, handling massive row counts efficiently. Question 22. In a multi‑subsidiary OneWorld environment, which permission must be granted to view consolidated financial data across subsidiaries? A) View Sub‑record B) Global Permissions – Consolidated Reporting C) Role > Subsidiary > Access All Subsidiaries D) Accounting > Intercompany Transactions Answer: C Explanation: “Access All Subsidiaries” enables a role to see data from every subsidiary, essential for consolidated reporting.
Question 23. Which Saved Search expression would correctly calculate the number of days between a transaction date and today? A) {today} - {trandate} B) TO_CHAR({trandate},‘J’) - TO_CHAR(SYSDATE,'J') C) DATEDIFF({trandate}, SYSDATE) D) {trandate} - SYSDATE Answer: B Explanation: Converting dates to Julian numbers with TO_CHAR(...,'J') allows subtraction to yield the day difference. Question 24. When creating a Workbook calculated field that needs to reference a column from a joined table, which syntax is required? A) [JoinedTable].[Field] B) {joinedtable.field} C) "JoinedTable"."Field" D) $joinedtable.field$ Answer: C Explanation: Workbook formulas use double‑quoted identifiers for table and field names when referencing joined tables. Question 25. Which KPI metric would be most appropriate to monitor inventory turnover? A) Gross Profit Margin B) Days Sales Outstanding C) Cost of Goods Sold ÷ Average Inventory D) Net Sales per Employee Answer: C Explanation: Inventory turnover is calculated as COGS divided by average inventory, reflecting how quickly inventory is sold.
A) Export the report to PDF B) Open the underlying transaction list for a summarized line C) Change the report’s date range on the fly D) Duplicate the report layout Answer: B Explanation: Drill‑Down lets users click a summary line to view the detailed transactions that make up that total. Question 30. Which role permission is required to edit a Dashboard that contains Analytics Portlets? A) Dashboards > Edit B) Reports > Customization C) Analytics > Portlet Management D) SuiteAnalytics > Workbook Answer: A Explanation: The “Dashboards > Edit” permission grants the ability to modify dashboard components, including portlets. Question 31. To display a custom narrative that summarizes month‑over‑month variance for sales, which NetSuite feature should you use? A) Saved Search with Formula (Text) B) AI‑Generated Narrative Portlet C) SuiteScript Suitelet D) Custom Record Type Answer: B Explanation: The AI‑Generated Narrative Portlet automatically creates natural‑language summaries of selected metrics, including variances. Question 32. Which Oracle function would you use to convert a numeric field to a string with a leading dollar sign in a Saved Search formula? A) TO_CHAR({amount}, ‘$999,999.00’)
B) CONCAT(‘$’, {amount}) C) FORMAT({amount}, ‘$’) D) NVL({amount}, ‘$0’) Answer: A Explanation: TO_CHAR with a format mask adds currency symbols and commas as needed. Question 33. In a Workbook, what does the “Cache Refresh” button do? A) Clears all workbook data and forces a full re‑query B) Saves the workbook to the file system C) Publishes the workbook to the dashboard D) Changes the workbook’s theme Answer: A Explanation: Cache Refresh discards cached query results, ensuring the latest data is retrieved from NetSuite. Question 34. Which KPI setting allows you to compare the current value against a target you define? A) Threshold B) Goal C) Benchmark D) Target Answer: D Explanation: The “Target” field lets you input a numeric goal; the KPI portlet then indicates performance relative to that target. Question 35. When configuring an AI Narrative for inventory, which data source must be selected? A) Saved Search on Item Record B) SuiteAnalytics Workbook chart C) Financial Report – Balance Sheet D) Custom Record – Inventory Summary
Explanation: Selecting only needed columns and filtering on indexed fields reduces processing time and improves performance. Question 39. In SuiteAnalytics Workbook, which visualization automatically stacks series to show part‑to‑whole relationships? A) Bar Chart B) Stacked Area Chart C) Line Chart D) Scatter Plot Answer: B Explanation: Stacked Area displays cumulative totals, making it easy to see each series’ contribution to the whole over time. Question 40. Which permission controls a user’s ability to view AI‑generated narrative portlets? A) Analytics > View Narrative B) Reports > Advanced C) SuiteAnalytics > Narrative Access D) Dashboards > View Answer: C Explanation: The “SuiteAnalytics > Narrative Access” permission specifically governs visibility of AI narrative content. Question 41. When building a multi‑level join in a Workbook, which join type is NOT available? A) Inner Join B) Left Outer Join C) Right Outer Join D) Full Outer Join Answer: D Explanation: SuiteAnalytics Workbook supports inner and left outer joins; full outer joins are not supported.
Question 42. Which field type must be included in a Saved Search to enable “Group with Previous” functionality in a report? A) Date B) Text C) Numeric D) Any field that is sorted in the report Answer: D Explanation: “Group with Previous” works on any sorted column; the field simply needs to be part of the report’s sort order. Question 43. What is the primary benefit of using the “Formula (Date)” type in a Saved Search? A) It allows comparison with system dates using date arithmetic. B) It returns a string that can be concatenated with other text. C) It automatically formats numbers as dates. D) It enables use of the NVL function. Answer: A Explanation: Formula (Date) returns a date value, permitting calculations like adding days or comparing to SYSDATE. Question 44. Which of the following best describes a “KPI Scorecard” on a NetSuite dashboard? A) A single number with a trend arrow B) A tabular list of all saved searches C) A collection of multiple KPIs displayed with targets and status indicators D) A chart that shows KPI performance over time Answer: C Explanation: The Scorecard aggregates several KPIs, each showing actual vs. target and a status color. Question 45. In NetSuite Analytics Warehouse, what is the purpose of a “Materialized View”? A) To store a static snapshot of a query for faster retrieval
D) Exporting data to a CSV file Answer: A Explanation: AI Narrative can analyze numeric data and produce a readable summary, such as highlighting top customers. Question 49. In a Workbook, what does the “Add Calculated Field” button allow you to do? A) Insert a new column that is the result of a custom formula B) Create a new Saved Search linked to the workbook C) Upload an external CSV file as a data source D) Convert the workbook into a dashboard Answer: A Explanation: Adding a calculated field defines a new column derived from existing data using a formula. Question 50. Which NetSuite feature allows a user to receive an email when a KPI exceeds a defined threshold? A) KPI Alert B) Workflow Action – Send Email C) Saved Search Alert D) Dashboard Notification Answer: A Explanation: KPI Alerts can be configured to trigger email notifications when the KPI value crosses a set limit. Question 51. Which Oracle SQL function can be used in a Saved Search formula to find the position of the substring “USD” in a text field? A) INSTR({field}, ‘USD’) B) POSITION({field}, ‘USD’) C) LOCATE({field}, ‘USD’) D) FIND({field}, ‘USD’) Answer: A
Explanation: INSTR returns the numeric position of a substring within a string. Question 52. When publishing a dashboard to multiple roles, which option ensures that each role sees the dashboard in their preferred language? A) Enable Internationalization – Yes B) Use Role‑Based Translation Files C) Set Dashboard Language to “User Preference” D) Dashboards are always displayed in the user’s language automatically Answer: D Explanation: NetSuite automatically renders dashboards using the user’s language setting; no extra option is required. Question 53. Which of the following is NOT a valid summary type in a Saved Search? A) Median B) Sum C) Count D) Minimum Answer: A Explanation: Median is not available as a built‑in summary type; only Sum, Count, Avg, Min, Max, and Group are supported. Question 54. In a Workbook, what does the “Drill‑Through” capability enable? A) Exporting the workbook to Excel B) Opening a related Saved Search when a user clicks a data point C) Changing the data source on the fly D) Adding a new calculated field without leaving the view Answer: B Explanation: Drill‑Through lets users click a chart or table element to view the underlying records via a Saved Search.
A) Rows B) Columns C) Filters D) Values Answer: C Explanation: The Filters area lets you apply slicers that limit the data displayed while keeping the structural layout intact. Question 59. Which of the following is a direct benefit of using NetSuite’s “Dataset Cache” for large workbooks? A) Eliminates the need for any saved searches B) Reduces the number of API calls to the backend database C) Allows real‑time editing of source records from the workbook D) Enables offline access to workbook data Answer: B Explanation: Caching stores query results, decreasing repeated calls to the database and improving response time. Question 60. In a KPI portlet, what does the “Trend” indicator display? A) The KPI’s value compared to the previous period B) A graphical sparkline of the KPI over time C) The KPI’s target value only D) The KPI’s calculation formula Answer: B Explanation: The Trend indicator shows a small line chart (sparkline) representing recent KPI performance. Question 61. Which of the following statements about “Group” summary type is true? A) It can be applied to numeric fields only. B) It creates a distinct row for each unique value of the grouped field.
C) It automatically calculates the average of the grouped field. D) It cannot be used together with “Count”. Answer: B Explanation: Grouping aggregates rows sharing the same field value, producing one row per unique value. Question 62. What is the primary purpose of the “Alternate Date Range” feature in the Financial Report Builder? A) To change the fiscal year of the report permanently B) To display comparative columns for different periods in the same report C) To filter out all transactions outside the selected range D) To apply a different currency conversion rate Answer: B Explanation: Alternate Date Ranges allow side‑by‑side comparison of current and prior periods within a single financial statement. Question 63. Which NetSuite role permission is needed to edit an AI Narrative that references a Saved Search? A) Lists > Search B) SuiteAnalytics > Narrative Edit C) Reports > Customization D) Setup > Manage AI Answer: B Explanation: “SuiteAnalytics > Narrative Edit” grants rights to modify AI Narrative configurations. Question 64. In a Saved Search, which function would you use to return the first non‑null value among two fields? A) COALESCE({field1}, {field2}) B) NVL({field1}, {field2}) C) IFNULL({field1}, {field2})
