Download NetSuite Certified SuiteAnalytics User Practice Exam and more Exams Technology in PDF only on Docsity!
Practice Exam
Question 1. Which NetSuite component is primarily used to display real‑time KPI values on a user’s homepage? A) Saved Search B) KPI Portlet C) Report Builder D) Dashboard Chart Answer: B Explanation: The KPI Portlet shows key performance indicator values directly on the dashboard. Question 2. In a saved search, which summary type would you select to determine the total number of distinct customers in a result set? A) Sum B) Count C) Count Distinct D) Minimum Answer: C Explanation: “Count Distinct” tallies unique values, such as distinct customers. Question 3. Which role permission is required for a user to view a custom report but not edit it? A) Full Access to Reports B) View Reports Only C) Edit Reports D) Administrator Answer: B Explanation: “View Reports Only” allows viewing without editing capabilities.
Practice Exam
Question 4. When adding a child record field to a transaction saved search, which join type should you use? A) Primary B) Parent C) Sub‑record D) Child Answer: D Explanation: The “Child” join lets you pull fields from related child records. Question 5. Which dashboard portlet is best for displaying a list of overdue invoices? A) KPI Scorecard B) List Portlet C) Trend Graph D) Search Portlet Answer: B Explanation: The List Portlet can show a tabular view of records like overdue invoices. Question 6. In Report Builder, which option allows you to display zero values for accounts with no activity? A) Show Empty Rows B) Show Zeros C) Include Inactive D) Hide Nulls Answer: B
Practice Exam
Answer: B Explanation: “Average” computes the mean value across grouped records. Question 10. To share a report with a specific department without altering role permissions, you should: A) Publish the report to the department’s role B) Add the department to the report’s audience list C) Change the report’s access to Public D) Duplicate the report for each user Answer: B Explanation: Adding the department to the report’s audience list controls visibility without role changes. Question 11. Which formula function converts a date to the format ‘YYYY‑MM‑DD’? A) TO_CHAR(date, ‘YYYY‑MM‑DD’) B) DATE_FORMAT(date, ‘%Y-%m-%d’) C) FORMAT(date, ‘YYYYMMDD’) D) CAST(date AS VARCHAR) Answer: A Explanation: TO_CHAR with the pattern returns the desired string format. Question 12. In a KPI Scorecard, which component defines the target value for a metric? A) Current Value B) Trend Line C) Target Bar
Practice Exam
D) Goal Setting Answer: D Explanation: Goal Setting allows you to set a target against which KPI performance is measured. Question 13. Which search type is ideal for retrieving a list of customers who have not placed an order in the last 90 days? A) Transaction Search with Main Line unchecked B) Customer Search with “Last Order Date” criteria C) Saved Search on Sales Orders D) Custom Report with Date Filter Answer: B Explanation: Customer Search can directly filter on “Last Order Date” to find inactive customers. Question 14. What does the “Group with Previous” option do in Report Builder? A) Merges adjacent groups with identical values B) Sorts groups alphabetically C) Adds a subtotal for each group D) Highlights the previous group’s rows Answer: A Explanation: “Group with Previous” collapses consecutive rows that share the same group value. Question 15. Which NetSuite record type should you base a saved search on to list all purchase order line items? A) Purchase Order B) Transaction
Practice Exam
B) Quantity C) Rate D) Custom Formula Answer: D Explanation: “Formula (Numeric)” lets you write a calculation such as (Amount – Cost). Question 19. Which of the following is NOT a valid summary type in NetSuite saved searches? A) Sum B) Median C) Count Distinct D) Minimum Answer: B Explanation: “Median” is not offered as a built‑in summary type. Question 20. To restrict a saved search to users with the “Sales Rep” role only, you should: A) Set the search’s audience to “Sales Rep” role B) Add a filter for “Role = Sales Rep” C) Publish the search on the Sales dashboard D) Create a custom script to hide the search Answer: A Explanation: Assigning the search’s audience to a specific role limits visibility. Question 21. Which feature in Report Builder lets you display a column even when its value is zero?
Practice Exam
A) Show Empty Rows B) Show Zeros C) Include Blank Columns D) Display Nulls Answer: B Explanation: “Show Zeros” forces zero values to appear in the report output. Question 22. When would you use the “Alternate Date/Period Range” option in a financial report? A) To compare current month to prior month B) To show fiscal year totals only C) To display dates in a custom format D) To exclude future periods Answer: A Explanation: Alternate Date/Period Range enables side‑by‑side period comparisons. Question 23. Which NetSuite search function returns the first 5 characters of a text field? A) LEFT(text,5) B) SUBSTR(text,1,5) C) RIGHT(text,5) D) MID(text,5) Answer: B Explanation: SUBSTR with start position 1 and length 5 extracts the first five characters. Question 24. In a KPI Scorecard, what does the “Trend” indicator represent?
Practice Exam
Question 27. Which SQL function would you use in a formula to replace a null value with zero? A) NVL(field,0) B) COALESCE(field,0) C) ISNULL(field,0) D) ALL OF THE ABOVE Answer: D Explanation: All three functions serve the same purpose; NetSuite supports NVL and COALESCE. Question 28. When configuring a dashboard for a sales manager, which portlet combination provides the most actionable insight? A) KPI Scorecard + List of Opportunities B) Chart of Revenue + Saved Search Alerts C) Calendar + Document List D) Trend Graph + Custom Search Answer: A Explanation: KPI Scorecard gives targets while a List of Opportunities shows the pipeline. Question 29. Which report builder feature allows you to insert a custom calculation that is not based on a standard field? A) Formula Column B) Custom Summary C) Calculated Field D) Advanced Filter Answer: A Explanation: “Formula Column” lets you define arbitrary calculations in the report.
Practice Exam
Question 30. In a transaction search, why would you set “Main Line” to false? A) To include only header rows B) To retrieve line‑level details C) To filter out voided transactions D) To limit results to posted periods Answer: B Explanation: Unchecking “Main Line” returns each line item rather than just the header. Question 31. Which of the following best describes the difference between a saved search and a custom report? A) Saved searches cannot be exported; reports can. B) Reports support grouping and subtotals; saved searches do not. C) Saved searches are more flexible for ad‑hoc filters; reports are better for formal financial layouts. D) Reports run faster than saved searches. Answer: C Explanation: Saved searches excel at dynamic filtering, while reports provide structured financial formatting. Question 32. To display the number of open cases per support representative on a dashboard, you would use: A) KPI Portlet with a custom formula B) List Portlet based on a saved search C) Chart Portlet with a saved search D) Search Portlet with a case search
Practice Exam
D) Earliest Answer: A Explanation: “Minimum” returns the smallest (earliest) date value in each group. Question 36. In Report Builder, what does the “Show Empty Rows” option do? A) Displays rows with zero values B) Includes rows for accounts with no activity C) Hides rows that have null fields D) Removes blank lines from the output Answer: B Explanation: “Show Empty Rows” forces the report to list all accounts, even those without transactions. Question 37. Which user role permission is required to edit a dashboard layout? A) Customize Dashboard B) View Dashboard C) Manage Portlets D) Administrator Answer: A Explanation: “Customize Dashboard” grants rights to modify dashboard structure. Question 38. To calculate the profit margin percentage in a transaction saved search, which formula would you use? A) (Amount - Cost) / Amount * 100 B) (Cost - Amount) / Cost * 100
Practice Exam
C) Amount / Cost * 100 D) (Amount + Cost) / Amount * 100 Answer: A Explanation: Profit margin = (Revenue – Cost) ÷ Revenue × 100. Question 39. Which option allows a saved search to be embedded directly on a dashboard? A) Add to Dashboard → Search Portlet B) Export as PDF and upload C) Create a custom script D) Use Report Builder to generate a chart Answer: A Explanation: The Search Portlet lets you place a saved search result on a dashboard. Question 40. In a financial report, which feature lets you hide accounts that have a zero balance for the selected period? A) Hide Zero Rows B) Filter Zero Balances C) Exclude Empty Accounts D) Show Zeros unchecked Answer: A Explanation: “Hide Zero Rows” removes rows where the total is zero. Question 41. Which SQL expression would you use to replace a null value in a saved search formula with the string “N/A”? A) NVL(field, ‘N/A’)
Practice Exam
A) within last 30 days B) on or after today- 30 C) between today-30 and today D) greater than today- 30 Answer: C Explanation: “Between” with a dynamic date range captures the last 30 days. Question 45. Which Report Builder option allows you to add a custom header or footer to a financial report? A) Page Settings B) Layout Designer C) Header/Footer Editor D) Print Options Answer: C Explanation: The Header/Footer Editor lets you define custom text for report pages. Question 46. To obtain a list of all items that have never been sold, which search type and filter combination is most efficient? A) Item Search with “Quantity Sold = 0” B) Transaction Search with “Item = NULL” C) Saved Search on Sales Orders with “Item = NULL” D) Custom Report with “Sales = 0” Answer: A Explanation: Item Search directly supports a “Quantity Sold” filter.
Practice Exam
Question 47. Which of the following formulas will return the month name from a date field? A) TO_CHAR(date, ‘Month’) B) MONTHNAME(date) C) SUBSTR(date,5,3) D) DATE_PART(‘month’, date) Answer: A Explanation: TO_CHAR with the ‘Month’ format extracts the month name. Question 48. When you need to display both actual and budgeted amounts side‑by‑side in a financial report, which feature should you enable? A) Comparative Columns B) Budget vs. Actual Toggle C) Dual Axis D) Show Budget Column Answer: D Explanation: “Show Budget Column” adds the budget figures next to actuals. Question 49. Which portlet type can display a graphical representation of a KPI’s progress toward its goal? A) KPI Portlet B) Scorecard Portlet C) Chart Portlet D) List Portlet Answer: B Explanation: The Scorecard Portlet visualizes KPI progress with gauges or bars.
Practice Exam
Explanation: The “@ME” placeholder represents the current user in NetSuite searches. Question 53. Which Report Builder option controls whether zero‑balance accounts are displayed in the report output? A) Show Zeros B) Show Empty Rows C) Hide Zero Balances D) Include Inactive Accounts Answer: A Explanation: “Show Zeros” toggles visibility of zero‑balance rows. Question 54. In a KPI Scorecard, what does the “Color Coding” setting affect? A) Background color of the dashboard B) Font color of KPI values based on thresholds C) Border color of the portlet D) Chart line colors Answer: B Explanation: Color coding changes KPI value colors according to defined performance bands. Question 55. Which saved search type would you choose to generate a list of open purchase orders that exceed a specific dollar amount? A) Transaction Search with Type = Purchase Order and Status = Open B) Purchase Order Search with Amount > X C) Custom Report on Purchases D) Item Search with On Order > X
Practice Exam
Answer: A Explanation: Transaction Search lets you filter by type, status, and amount. Question 56. Which expression correctly uses the CASE statement to label customers as “High”, “Medium”, or “Low” based on credit limit? A) CASE WHEN {creditlimit} > 10000 THEN ‘High’ WHEN {creditlimit} > 5000 THEN ‘Medium’ ELSE ‘Low’ END B) IF({creditlimit}>10000,’High’,IF({creditlimit}>5000,’Medium’,’Low’)) C) DECODE({creditlimit},>10000,’High’,>5000,’Medium’,’Low’) D) SELECT {creditlimit} FROM CASE … Answer: A Explanation: CASE provides multiple conditional branches in a single formula. Question 57. To create a dashboard that shows the top 5 sales reps by revenue, which combination is required? A) Saved Search (Top 5) + List Portlet B) KPI Portlet with Ranking C) Chart Portlet with “Top N” filter D) Scorecard Portlet with custom metric Answer: A Explanation: A saved search limited to 5 records displayed via a List Portlet achieves this. Question 58. Which permission is needed for a user to create a new custom report in Report Builder? A) Manage Reports B) Create Reports
