Final
Which of the following is NOT an advantage of an ERP system? A. Better access control B. Standardization of procedures and reports C. Improved monitoring capabilities D. Simplicity and reduced costs
D. Simplicity and reduced costs
Which tool is primarily used to reference a lookup table, in order to get values and place them in a main data table?
Find Replace
In the _________ method of tracking accounts receivable, customers pay according to the amount showing on their monthly statement and payments are applied against the total account balance a. balance forward b. open-invoice c. specific identification d. remittance advice
a. balance forward
Alteryx: Which of the following statements about tool containers are true? A tool container can be 1. disabled from the canvas 2. added without inserting the tool from the menu a. both 1 and 2 are true b. 1 but not 2 is true c. 2 but not 1 is true d. neither 1 nor 2 are true
a. both 1 and 2 are true
The DateTime tool is able to convert: a. both datetime to string and string to datetime b. string to datetime c. datetime to string d. numeric to datetime
a. both datetime to string and string to datetime
What does a Tableau union do? a. combines data from multiple tables by bringing in new rows or records that match the structure of the original data b. places two visualizations on a dashboard c. unions cannot be performed in Tableau, only Joins can be used d. Combines data from multiple tables by bringing in new columns or records that match the structure of the original data
a. combines data from multiple tables by bringing in new rows or records that match the structure of the original data
Alteryx: Longer statements that document a workflow are best put in a ________ while shorter comments are better in a(n)_________________ a. comment tool, annotation b. annotation, comment tool c. comment tool, API tool d. tool container, comment tool
a. comment tool, annotation
Which of the following areas of financial reporting is most suitable for applying data analytics techniques? a. evaluation of estimates and valuations b. variance reporting c. calculating the components of equity d. depreciation
a. evaluation of estimates and valuations
In the database design approach known as normalization, the first assumption made about data is a. everything is initially stored in one large table b. the data will not be maintained in 3NF tables c. there is no redundancy in the data d. the delete anomaly will not apply since all customer records will be maintained indefinitely
a. everything is initially stored in one large table
Which of the following is a support activity in the value chain? a. purchasing b. manufacturing c. post-sales service d. receiving materials
a. purchasing
What is the key difference between a data extract and live connection in Tableau? a. data extracts update automatically and live connections need to be refreshed b. they are not Tableau features c. they are the same d. Live connections update automatically and data extracts need to be refreshed
d. Live connections update automatically and data extracts need to be refreshed
In Tableau, which of the following best describes a story? a. an individual sheet in a story b. Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail c. a coherent sequence of visualizations d. where you determine which variables will go on what axis
c. a coherent sequence of visualizations
The SEC, PCAOB, and FASB are best described as external influences that directly affect an organization's a. hiring practices b. philosophy and operating style c. internal environment d. methods of assigning authority
c. internal environment
A data flow diagram a. is a graphical description of the relationship among the input, processing, and output in an information system b. is a graphical description of the flow of documents and information between departments or areas of responsibility c. is a graphical description of the source and destination of data that show show data flow within an organization d. is a graphical description of the sequence of logical operations that a computer performs as it executes a program
c. is a graphical description of the source and destination of data that show show data flow within an organization
Which of the following is NOT a characteristic that makes information useful? a. it is reliable b. it is timely c. it is inexpensive d. it is relevant
c. it is inexpensive
Which of the following is not one of the skillsets often associated with data analytics? a. mining and analyzing data b. creating data structures and models c. normalizing data structures d. acquiring and cleaning data
c. normalizing data structures
Which of the following is a primary activity in the value chain? a. purchasing b. accounting c. post-sales service d. human resource management
c. post-sales service
If a data analyst uses machine learning to create an estimation of which suppliers are likely to be late in providing goods for a manufacturing process, what type of analytic did the data analyst create? a. descriptive analytic b. diagnostic analytic c. predictive analytic d. prescriptive analytic
c. predictive analytic
Which is probably the MOST immediate and significant effect of database technology on accounting? a. elimination of traditional records such as journals and ledgers b. change in the nature of financial reporting c. quicker access to and greater use of accounting information in decision-making d. replacement of the double entry-system
c. quicker access to and greater use of accounting information in decision-making
The database requirement that foreign keys must be mull or have a value corresponding to the value of a primary key in another table is formally called the a. unique primary key rule b. foreign key rule c. referential integrity rule d. entity integrity rule
c. referential integrity rule
Alteryx: Which of the values are not included in a data steam's metadata in Designer? a. source b. size c. rename d. type
c. rename
According to the ERM model, _________ help to ensure the accuracy, completeness and reliability of internal and external company reports a. compliance objectives b. operations objectives c. reporting objectives d. strategic objectives
c. reporting objectives
Which input options are available for an Excel file? a. sort b. write a file c. select a sheet d. predict inputs
c. select a sheet
Which version of Tableau runs on the client's (not Tableau's) server? a. desktop b. public c. server d. online
c. server
Which statement below is true about the summarize tool? a. the "count" function can only be used with numeric data types b. only one summarize function can be applied to a field c. some summarize function depend on the data type d. the summarize tool is case insensitive
c. some summarize function depend on the data type
Which function category would contain the function "Null()"? a. math b. operators c. specialized d. test
c. specialized
Which of the following will present a sequence of visualizations? a. worksheet b. dashboard c. story d. map
c. story
Which of the following data types are acceptable for identifying matching values when using the Find Replace tool? a. all listed data types b. numeric c. string d. DateTime
c. string
What must you have to publish a workbook? a. The Tableau workbook is solely for presentation purposes and cannot be published publicly b. Ability to download your Tableau data to an excel file c. Tableau approval through Tableau online for data to be published anywhere d. Publishing access to either Tableau Server or Tableau Online
d. Publishing access to either Tableau Server or Tableau Online
Which of the following functions replace every occurrence of a target string or character a. Replace() b. FindString() c. ReplaceFirst() d. ReplaceChar()
d. ReplaceChar()
Tableau: What happens when you drag a dimension or measure from the data pane into view? a. a singularity is created b. Tableau creates a data duplication c. nothing d. Tableau creates a pill
d. Tableau creates a pill
T or F: The Browse tool displays the data from a connected tool?
True
Dynamic input tool (grey circle with rigged edges and white book)
Alteryx: Which Alteryx tool has the following configuration window?
a. five
Based on the Configuration below, how many rows will be output from the union tool? a. five b. three c. four d. zero
An AIS provides value by A) improving products or services through information that increases quality and reduces costs. B) providing timely and reliable information to decision makers. C) creating new products. D) both A and B
D) both A and B
Alteryx: What does the Dynamic input tool look like?
Dynamic input tool
Alteryx: T or F: The Filter tool does not support custom filters
FALSE
d. 3
Given the transpose tool's configuration window below, how many columns will appear in the output? a. 6 b. 4 c. 5 d. 3
Sequential
Name the color scheme used in the following visualization
Which tool is best for removing unwanted data and renaming fields?
Select tool
c. syntax error and data type
What about the configuration below is incorrect? a. syntax error b. nothing is wrong c. syntax error and data type d. data type
Append fields tool
Which Alteryx tool has the following Configuration window?
Data cleansing tool: Blue with the sparkles
Which Alteryx tool has the following Configuration window?
Select Records tool
Which Alteryx tool has the following Configuration window?
Text to Columns
Which Alteryx tool has the following Configuration window?
[Borough Code]=1 OR [Health]="Good"
Which expression was used in the Filter tool to create the True output below?
b. Round()
Which function would produce the results in the Result below? a. Floor() b. Round() c. Rand() d. Ceiling()
Using a file-oriented approach to data and information, data is maintained in a. many separate files b. a decentralized database c. a centralized database d. many interconnected filed
a. many separate files
Which function category would contain the function "addition"? a. operators b. conversion c. math d. test
a. operators
Tableau: Which Aggregate Function is used to calculate distinct count? a. COUNTD() b. COUNT() c. SUM () d. AVG ()
a. COUNTD()
All of the following are associated with asymmetric encryption EXCEPT a. speed b. public keys c. no need for key change d. private keys
a. speed
Which of the following is not an available option for combining data in the union tool? a. column name b. data type c. manual configuration d. column position
b. data type
Alteryx: Which of the following file types support reading in multiple sheets? a. .csv b. .xlsx c. all listed options d. .yxdb
b. .xlsx
Alteryx: To limit the number of input rows to 10 from a CSV file, where will you put the number 10 in the Configuration window? a. field length b. start data important on line c. record limit d. delimiters
c. record limit
________ is NOT a basic activity of the revenue cycle a. shipping b. billing c. receiving d. sales order entry
c. receiving
Tableau: Which of the following can you use to create a calculated field that return data independent of the data granularity in a view? a. a basic calculation b. an INCLUDE LOD calculation c. A FIXED LOD calculation d. a table calculation
c. A FIXED LOD calculation
Which of the following is NOT an important principle for data visualizations to be effective? a. emphasizing what is important b. choosing the right type of visualization c. using a data dashboard d. simplifying the presentation of data
c. using a data dashboard
Tableau: Which of the following is not an action to Dashboards? a. URL b. Filter c. Highlight d. Run
d. Run
The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the a. database management system b. data warehouse c. database administrator d. database system
d. database system
How does the chart of accounts list general ledger accounts? a. alphabetical order b. chronological order c. size order d. the order in which they appear on the financial statements
d. the order in which they appear on the financial statements
Comment tool (navy word bubble with a white rectangle word bubble inside with 3 navy dots inside)
Which alteryx tool has the following configuration window?
Sort (blue circle with 3 ascending dots in a line)
Which alteryx tool has the following configuration window?
d. space
Which character is not used to parse the data, as shown below? a. semi-colon b. hyphen c. comma d. space
a. DateTimeAdd([Start Date], -1, "years")
Which expression would output the value in the column [Output] in the table below? a. DateTimeAdd([Start Date], -1, "years") b. DateTimeYear([Start Date]) c. DateTimeDiff([Start Date],[Output],"years") d. DateTimeDay ([Start Date])
a. IIF([Animals]="Cats","Rule","Drool")
Which of the following expressions would not produce the values in the column [Status] in the table? a. IIF([Animals]="Cats","Rule","Drool") b. Switch([Animals],"NA","Cats","Rule","Dogs","Drool","Goats",Null(),"Ducks",Null()) c. IF[Animals]="Cats" THEN "Rule" ELSEIF [Animals] = "Dogs" THEN "Drool" ELSE Null() ENDIF d. Switch ([Animals], Null(), "Cats", "Rule", "Dogs", "Drool")
a. [New_Sales]+[Used_Sales]
The data set below includes data on new and used car sales. All data types are numeric. Which expression below would produce the values in the column, "total sales" a. [New_Sales]+[Used_Sales] b. Total(New_Sales + Old_Sales) c. Sum([New_Sales],[Used_Sales]) d. Total sales = New_sales + Used_sales
a. impossible to tell
An input dataset contains 54 records. With the given configuration window, how many records will be output? a. impossible to tell b. 36 c. 17 d. 0
c. split to rows
Based on the data before and after parsing, select the method in which the Text to Columns tool was used a. split to columns by comma b. none of these c. split to rows d. split to columns by hyphen
d. join by position
Based on the results below, which method was used to join the two tables? a. join by specific fields based on type b. join by specific fields based on type and height c. join by specific fields based on type, height and health d. join by position
d. 4
How many unique rows would be identified if the Unique tool was configured as below? a. 1 b. 3 c. 2 d. 4
a. "score" is sorted in ascending order and "use dictionary order" is unchecked
The data type of Score filed is String. Based on the result, which option in the Sort tool was used? a. "score" is sorted in ascending order and "use dictionary order" is unchecked b. "score" is sorted in descending order and "use dictionary order" is unchecked c. "score" is sorted in ascending order and "use dictionary order" is checked d. "score" is sorted in descending order and "use dictionary order" is checked
d. UpperCase()
Which Function was used to product the values in the column [Email]? a. CountWords() b. TitleCase() c. LowerCase() d. UpperCase()
The container tool
Which Alteryx tool has the following Configuration window?
Alteryx: Input tool (green background with white book)
Which Alteryx tool has the following configuration window?
Find replace tool (purple with white magnifying glass and white pencil)
Which Alteryx tool has the following configuration window?
Formula tool
Which Alteryx tool has the following configuration window?
Join tool (purple with 5 white dots connected to a middle white ring)
Which Alteryx tool has the following configuration window?
Sample tool: test tubes
Which Alteryx tool has the following configuration window?
Transpose (row to column)
Which Alteryx tool has the following configuration window?
How does a user publish a workbook from Tableau Desktop? a. From inside Tableau Desktop, go to "Server" and click "Publish Workbook..." b. From inside Tableau Prep, click "Output" c. From inside Tableau Desktop, go to "Data" and click "Publish" d. From inside Tableau Desktop, go to "File" and click "Publish to Tableau Online"
a. From inside Tableau Desktop, go to "Server" and click "Publish Workbook..."
Which expression would convert Null values in the column [status] to the value "not availabel"? a. IF IsNull([Status]) THEN "Not available" ELSE [Status] ENDIF b. IIF([Status]="Null","Not available",[Status]) c. IF Null() THEN "not available" ELSE [Status] ENDIF d. IF [Status] = "Null" THEN "Not available" ELSE [Status] ENDIF
a. IF IsNull([Status]) THEN "Not available" ELSE [Status] ENDIF
Why does Tableau aggregate measures? a. To summarize the data b. To display data at the lowest level of detail c. Because measures require less storage d. It requires a less powerful computer to process the measures
a. To summarize the data
Tableau: Which type of calculation could be used to distinguish data in a visualization that satisfies a certain criterion? a. a calculation using "If" and "Then" statements b. A distinguish statement calculation c. a calculation using a "Vlookup" statement d. a "sum" calculation
a. a calculation using "If" and "Then" statements
Tableau: Which type of calculation could be used to distinguish data in a visualization that satisfies a certain criterion? a. a calculation using "if" and "then" statements b. a distinguish statement calculation c. a calculation using a "Vlookup" statement d. a "sum" calculation
a. a calculation using "if" and "then" statements
Two documents usually accompany goods shipped to a customer. What are the two documents? a. a packing slip and a bill of lading b. an invoice and a sales order c. an invoice and a packing slip d. a bill of lading and an invoice
a. a packing slip and a bill of lading
In Tableau, which of the following best describes a story point? a. an individual sheet in a story b. a coherent sequence of visualizations c. Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail d. Where you determine which variables will go on what axis
a. an individual sheet in a story
Which is not a feature of the formula tool? a. import expressions b. save expressions c. a full list of available functions d. a list of columns in the data set
a. import expressions
___________ is the risk that exists before management takes any steps to mitigate it a. inherent risk b. residual risk c. risk appetite d. risk assessment
a. inherent risk
Alteryx: Cells that are left blank in the Text Input tool are assigned what value? a. null b. zero (0) c. empty d. n/a
a. null
Which function category would contain the function "addition"? a. operators b. math c. conversion d. test
a. operators
Tableau: How do you change a data field's properties to express "Profit" in terms of dollars? a. right-click on profit the click on default properties to select the desired currency in number format b. data field properties cannot be charged within Tableau c. recode the data to express the profit as dollars d. data field properties can only be edited when the data fields is in either rows or columns
a. right-click on profit the click on default properties to select the desired currency in number format
Alteryx: Which "Output tool" configuration option allows users to write out multiple files based on a field? a. take file/table name from field b. output selected from field c. create file/table name from field d. write file from field
a. take file/table name from field
Alteryx: Which of the following statements is false? a. the dynamic input tool is the only tool required to import multiple sheets at once b. the filter tool includes two output anchors c. the summarize tool can apply summary processes to spatial, string, and numeric datatypes d. data is only created or modified when a workflow with a configured output data tool is run
a. the dynamic input tool is the only tool required to import multiple sheets at once
In Tableau, which of the following best describes a workbook? a. the entire Tableau file containing your sheets and dashboards b. a canvas for displaying multiple sheets that allows the user to interact with the display c. a variable from the dataset that is often aggregated and is usually continuous data d. a single chart or map in Tableau
a. the entire Tableau file containing your sheets and dashboards
What is the primary objective of ensuring systems and information are available for use whenever needed? a. to minimize system downtime b. to maximize system processing speed c. to minimize system expense d. to maximize
a. to minimize system downtime
Tableau: How would you add a linear trend line to a scatter plot? a. In the toolbar, click on analysis then select linear trend line b. Click on analytics, then drag trend line onto linear c. Right click anywhere on the scatter plot and select linear trend line d. None of the above
b. Click on analytics, then drag trend line onto linear
A way to incorporate the advantages of Electronic Data Interchange with the Electronic Funds Transfer is: a. to use procurement cards b. Financial Electronic Data interchange c. e-commerce d. an electronic lockbox
b. Financial Electronic Data interchange
Which data structure does tableau prefer: a. Gantt charts b. Flat files c. Pivot tables d. photographs
b. Flat files
Which of the following is false considering mapping in Tableau? a. You can generate latitude and longitude if yo have place names in your data b. You cannot show streets and highways on your maps c. You can show streets and highways on your maps when zoomed in d. You can use latitude and longitude to generate place names on your map
b. You cannot show streets and highways on your maps
Which is a true statement regarding a document flowchart? a. a document flowchart is not normally used in evaluating internal control procedures b. a document flowchart is particularly useful in analyzing the adequacy of internal control procedures c. a document flowchart illustrates the sequence of logical operations performed by a computer d. a document flowchart is more useful than a data flow diagram
b. a document flowchart is particularly useful in analyzing the adequacy of internal control procedures
The document that shows the items stored in a file, including the order and length of the data fields and the type of data stored is called a. a physical layout b. a record layout c. a logical layout d. a data layout
b. a record layout
In Tableau, which of the following best describes a sheet? a. a canvas for displaying multiple sheets that allows the user to interact with the display b. a single chart or map in Tableau c. a variable from the dataset that is often aggregated and is usually continuous data d. the entire Tableau file containing your sheets and dashboards
b. a single chart or map in Tableau
In Tableau, which of the following best describes a measure? a. a canvas for displaying multiple sheets that allows the user to interact with the display b. a variable from the dataset that is often aggregated and is usually continuous data c. the entire Tableau file containing your sheets and dashboards d. a single chart or map in Tableau
b. a variable from the dataset that is often aggregated and is usually continuous data
Alteryx: How can data be added to a workflow with the Text Input tool? a. manually enter values in cells b. all listed ways c. copy and paste values form another source d. import data from a file or database
b. all listed ways
Verifying the identity of the person or device attempting to access the system is an example of a. identification b. authentication c. authorization d. threat monitoring
b. authentication
Alteryx: Which of the following options is not a data type recognized in designer? a. numeric b. auto c. DateTime d. string
b. auto
In Tableau, this statement, "SUM([Profit])/SUM([Sales])" is best described as a: a. classification b. calculation c. connection d. calculation
b. calculation
How is a data field hierarchy created? a. none is correct b. click on create hierarchy within a data field's menu c. assign the same alias to multiple data fields d. hierarchies are not a feature in Tableau
b. click on create hierarchy within a data field's menu
The Trust Services Framework reliability principle that states sensitive information be protected from unauthorized disclosure is known as: a. security b. confidentiality c. availability d. integrity
b. confidentiality
A DFD created at the highest-level or summary view is referred to as a a. overview diagram b. context diagram c. process diagram d. content diagram
b. context diagram
Duplicate checking of calculations is an example of a _______________ control, and procedures to resubmit rejected transactions are an example of a _____________ control a. corrective; detective b. detective; corrective c. preventive; corrective d. detective; preventive
b. detective; corrective
Nancy Kempf has been hired by Andersen Manufacturing as a staff account in the internal audit department. She has been asked to thoroughly document the existing accounting information system in preparation for making recommendations for improvements to internal controls. She decides to begin with a description of the information stored in paper records, their sources, and their destinations. The documentation tool that he should employ for this purpose is a a. data flow diagram b. document flowchart c. program flowchart d. system flowchart
b. document flowchart
Which is not a way to add a tool to Canvas in Alteryx Designer? a. right clicking on the Canvas and selecting the tool from the list of tool categories b. double clicking a tool in the tool palette c. drag a tool from the tool palette and drop it on the Canvas d. search for a tool and drag the tool from the Search results onto the Canvas
b. double clicking a tool in the tool palette
Which of the following is NOT a component of the COSO Enterprise Risk Management Integrate Framework (ERM)? a. monitoring b. ethical culture c. risk assessment d. control environment
b. ethical culture
Alteryx: All of the following sampling methods are available in the Sample tool except a. skip 1st N rows b. every row c. first N% rows d. 1 every N rows
b. every row
A system that creates logs of all network traffic was permitted to pass the firewall and then analyzes those logs for signs of attempted or successful intrusions is called a. log analysis b. intrusion detection systems c. continuous monitoring d. defense in depth
b. intrusion detection systems
Which of the following is NOT true about program flowcharts? a. program flowcharts increase computer programmer productivity b. program flowcharts are a high-level overview of all business processes c. program flowcharts document the processing logic of computer programs d. a program flowchart will exist for every computer process symbol on a system flowchart
b. program flowcharts are a high-level overview of all business processes
Alteryx: Which of the values are not included in a data stream's metadata in Designer? a. type b. rename c. size d. source
b. rename
From the options listed below, which is not a way that functions can be inserted into the Expression Editor? a. clicking on the function library icon to navigate and select a function b. right clicking in the expression editor and selecting a function c. choose from the "recent and saved expressions" d. typing the name of a function directly into the Expression Editor and select the function from the auto-completed options
b. right clicking in the expression editor and selecting a function
Because it is the most fungible of all assets, the management of cash has always been the most difficult of all control issues. The most important of cash controls is a. minimization of cash handling b. segregation of duties c. frequent reconciliation of records d. lockbox arrangements
b. segregation of duties
The steps that criminals take to trick an unsuspecting employee into granting them access is called a. research b. social engineering c. reconnaissance d. scanning and mapping the target
b. social engineering
Which of the following processes cannot be performed with a Select tool? a. change a date type b. sort the content in a filed c. remove columns d. save filed configuration
b. sort the content in a filed
What does Granularity mean in Tableau? a. the visualization's picture definition b. the extent to which the view is broken down. The less aggregated, the more granular c. the extent of the quality of the graph type d. The extent to which the view is broken down. The more aggregated, the more granular.
b. the extent to which the view is broken down. The less aggregated, the more granular
Which of the following statements is False? a. a column's datatype can change in the course of a workflow b. the functions Null() and IsNull() are found in the same category in the Function Library c. conditional statements can be used with any data type d. math functions can only be used on numeric data types
b. the functions Null() and IsNull() are found in the same category in the Function Library
In the time-based model of information security, P represents a. the time it takes to assess threats and select risk response b. the time it takes an attacker to break through the various controls that protect the organization's information assets c. the time it takes for the organization to detect that an attack is in progress d. the time it takes to respond to and stop the attack
b. the time it takes an attacker to break through the various controls that protect the organization's information assets
The primary purpose of the Foreign Corrupt Practices Act of 1977 was a. to require corporations to maintain a good system of internal control b. to prevent the bribery of foreign officials by American companies c. to require the reporting of any material fraud by a business d. all of these are required by the act
b. to prevent the bribery of foreign officials by American companies
The Sarbanes-Oxley Act requires independent auditors to a. prepare and understand all types of system documentation b. understand a client's system of internal controls c. create flowcharts to document business processes d. establish effective internal controls
b. understand a client's system of internal controls
A _________ can be used within a _______ or __________ a. story, dashboard, workbook b. worksheet, dashboard, story c. dashboard, worksheet, story d. story, dashboard, worksheet
b. worksheet, dashboard, story
You are assisting a manager from your company's headquarters in New York. The manager needs to interact online in real time with one of your company's affiliate overseas. The manager wants to make sure that her communications with overseas affiliate won't be intercepted. What should you suggest to the manager? a. a multifactor authentication network connection b. an asymmetric encryption system with digital signatures connection c. a virtual private network connection d. a private cloud network connection
c. a virtual private network connection
Alteryx: Which of the following function categories have Action properties? a. finance b. numeric c. all of the listed d. reporting
c. all of the listed
Tableau: What does "AGG" mean when included in a pill in Tableau? a. an aggressive iterative calculation error has occurred b. nothing, AGG only applies to Tableau prep c. an aggregate calculation has been included in this calculation instead of being separately calculated d. a possible negative data aggregation has occurred in this calculation's execution
c. an aggregate calculation has been included in this calculation instead of being separately calculated
Tableau: a field that shows average home values for the United States in 2016 is most likely: a. a geographical dimension b. a discrete date part dimension c. an aggregated measure d. a continuous date value dimension
c. an aggregated measure
Dashboards provide a view of the most important information needed to achieve one or more objectives. According to Stephen Few's definition of a dashboard, they should also (pick the single most important): a. contain complex diagnostics that the user can use to drill-down into other reports b. have as much information as possible on multiple pages c. be consolidated on a single computer screen so that they can be monitored at a glance d. be interactive and "clickable"
c. be consolidated on a single computer screen so that they can be monitored at a glance
In using best practices in Tableau, dimensions are mostly ________ while measures are mostly __________ a. numbers, alignments b. added, grouped c. categories, numbers d. discrete numbers, continuous numbers
c. categories, numbers
Tableau: How can you assign a geographic role to a data field in the data pane? a. program geographic roles by editing the data field b. geographic roles are not a function in Tableau c. click on the data type symbol of the data field and select the geographic role d. contact the united nations geographic database to assign geographic information to your data
c. click on the data type symbol of the data field and select the geographic role
Tableau: which part of the toolbar should be used to export an image of a dashboard? a. format b. analysis c. dashboard d. file
c. dashboard
Mara Kay is a system analyst for a national department store. She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions. What technique would Mara most likely use? a. data exploring b. customer resource management c. data mining d. customer auditing
c. data mining
When the HR manager wants to gather data about salary and start date by employees and by departments, the manager would use which language? a. data manipulation language b. data report language c. data query language d. data definition language
c. data query language
Which of the following is not an available option for combining data in the Union tool? a. column position b. column name c. data type d. manual configuration
c. data type
Regularly reviewing an accounts receivable aging report can help management do what? a. determine whether the firm's pricing policy is effective b. improve the speed with which customers make payments c. determine whether changes are needed in the firm's credit policies d. identify customers who have not purchased anything lately
c. determine whether changes are needed in the firm's credit policies
Alteryx: Which of the following are not present in the configuration options for all three file types-CSVs, Microsoft Excel Workbooks, and Alteryx Databases? a. record limit b. output file name as field c. first row contains data d. file format
c. first row contains data
Which of the following is NOT a threat to the revenue cycle shipping process? a. picking the wrong items b. inventory theft c. incomplete orders d. wrong shipping address
c. incomplete orders
Sequentially prenumbered forms are an example of a(n) a. data transmission control b. data entry control c. input control d. processing control
c. input control
Which of the following is NOT a principle related to information and communicating in the updated COSO Integrated Control framework? a. communicate relevant internal control matters to external parties b. obtain or generate relevant, high-quality information to support internal control c. surround internal control processes with information technology that enables discrepancies to be identified d. internally communicate the information necessary to support the other components of internal control
c. surround internal control processes with information technology that enables discrepancies to be identified
Nancy Kempf has been hired by Andersen Manufacturing as a staff accountant in the internal audit department. She has been asked to thoroughly document the existing accounting information system in preparation for making recommendations for improvements. She decides to begin by meeting with the information technology staff in order to develop an understanding of the overall operation of the AIS, including data entry, storage, and output. The documentation tool that he should employ for this purpose is a a. program flowchart b. document flowchart c. system flowchart d. data flow diagram
c. system flowchart
Alteryx: Which of the following statements is False? a. the filter tool includes two output anchors b. browse tool is needed to view the entire dataset in the results window c. the dataset that is connected to the "F" input of the Find Replace tool is the input in which data values are replaced or appended d. the input data tool can only connect to files
c. the dataset that is connected to the "F" input of the Find Replace tool is the input in which data values are replaced or appended
In Tableau, which of the following best describes a filter? a. text boxes that appear when hovering over a mark on a sheet to give more information b. where you determine which variables will go on what axis c. used to limit what data is displayed on the sheet d. controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail
c. used to limit what data is displayed on the sheet
Tableau: This type level of detail expression computes total sales for the region, regardless of what dimensions are shown in the view a. {ONLY [Region] : SUM([Sales])} b. {SUM({[Sales])} c. {FIXED [Region] : SUM([Sales])} d. {EXACT [Region] : SUM([Sales])}
c. {FIXED [Region] : SUM([Sales])}
The append fields tool: 1. is limited to generating no more than 16 appends per record 2. requires two input anchors Which of the above statements are true? a. 1 but not 2 is true b. neither 1 nor 2 are true c. both 1 and 2 are true d. 2 but not 1 is true
d. 2 but not 1 is true
Tableau: What is the difference between a Cross-Database Join and Blending? a. a cross-database join takes separate query results from each data source and aggregates them in the view. Blending integrates two data sources at the row level to create a single data source b. A cross-database join combines two data representations and a blend mixes all the data together while automatically cleaning it c. there is no difference between cross-database joins and blending d. A cross-database join integrates two data sources at the row level to create a single data source. Blending takes separate query results from each data source and aggregates them in the view
d. A cross-database join integrates two data sources at the row level to create a single data source. Blending takes separate query results from each data source and aggregates them in the view
In Tableau, which of the following best describes a tooltip? a. where you determine which variables will go on what axis b. used to limit what data is displayed on the sheet c. controls most of the visual elements in a sheet. Allows you to switch between different chart types, changes colors and sizes, add labels, and change the level of detail d. Text boxes that appear when hovering over a mark on a sheet to give more information
d. Text boxes that appear when hovering over a mark on a sheet to give more information
Alteryx: Which of the following statements about the unique tool is true? a. It's best practice to join the results from the U & D outputs b. The unique can change the case of the characters in a field c. You can select up to 10 columns in one Unique tool d. The Unique tool is case sensitive
d. The Unique tool is case sensitive
In Tableau, can you deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? a. Yes, but it requires a plug-in b. Just like the song, "It's impossible" c. Yes, with the use of Tableau Server d. Yes, with the use of a Web Page object
d. Yes, with the use of a Web Page object
In Tableau, which of the following best describes a dashboard? a. a variable from the dataset that is often aggregated and is usually continuous data b. a single chart or map in Tableau c. The entire Tableau file containing your sheets and dashboards d. a canvas for displaying multiple sheets that allows the user to interact with the display
d. a canvas for displaying multiple sheets that allows the user to interact with the display
What are parameters in Tableau? a. a function that allows the user to fix the granularity of data, preventing it from fully aggregating b. a function that only allows the user to replace numbers outside of a certain range with "null" c. parameters are not used in Tableau d. a variable whose value is controlled by the end user
d. a variable whose value is controlled by the end user
Upon acquiring a new computer operating system, management at Berryhill worried that computer virus might cripple the company's operation. Despite that concern, management did not think that the risk was high enough to justify the purchase of an anti-virus software. Berryhill chose to__________the risk of being crippled by computer virus a. reduce b. share c. avoid d. accept
d. accept
Alteryx: Which of the header values below would have characters converted to underscores when output by the Cross Tab tool? a. A1 b. All listed c. Ayx d. b&b
d. b&b
What color indicates a discrete (not continuous measure in Tableau? a. green b. orange c. red d. blue
d. blue
Which of the following is NOT threat to the revenue cycle sales order entry process? a. incomplete orders b. uncollectible accounts c. invalid orders d. cash flow problems
d. cash flow problems
Tableau: How would you add a linear trend line to a scatter plot? a. right click anywhere on the scatter plot and select linear trend line b. none of the above c. in the toolbar, click on analysis then select linear trend line d. click on analytics, then drag trend line onto linear
d. click on analytics, then drag trend line onto linear
What does the device designer feature in Tableau allow the user to do? a. device designer is only a Tableau Prep tool and is not useful for publishing b. Allows the user to design each graph individually outside of the dashboard c. allows the user to save the file to a separate device of the user's choosing d. creates a master dashboard and allows customization to determine what it would look like on a desktop, tablet, or phone
d. creates a master dashboard and allows customization to determine what it would look like on a desktop, tablet, or phone
Which of the following is NOT at true statement? a. documentation tools are used extensively in the systems development process b. data flow diagrams and flowcharts are the two most frequently used systems development documentation tools c. documentation tools save an organization both time and money d. data flow diagrams and flowcharts are difficult to prepare and revise using software packages
d. data flow diagrams and flowcharts are difficult to prepare and revise using software packages
Information encrypted with the creator's private key that is used to authenticate the sender is called a. public key b. digital certificate c. asymmetric encryption d. digital signature
d. digital signature
Which of the following is NOT one of the five principles of COBIT5? a. meeting stakeholder needs b. covering the enterprise end-to-end c. enabling a holistic approach d. improving organizational efficiency
d. improving organizational efficiency
Which of the following was NOT an important change introduced by the Sarbanes-Oxley Act of 2002? a. new roles for audit committees b. new rules for auditors and management c. new rules for internal control requirements d. new rules for information systems development
d. new rules for information systems development
A Business Process Diagram (BPD) provides the reader an easily understood________of what takes place in a business process a. narrative b. decision flow c. data flow d. pictorial view
d. pictorial view
The revenue cycle's primary objective is to a. lower expenses b. provide quality product in order to maximize market share c. maximize the company's profit d. provide the right product in the right place at the right time for the right price
d. provide the right product in the right place at the right time for the right price
Tableau: Some calculations are available without manual creation. These are called: a. instant viz calculations b. fast calculations c. easy access calculations d. quick table calculations
d. quick table calculations
Emma Kolb is a system analyst at a manufacturing company located in the Midwest. She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements. After noting that the same production files have been saved and stored independently on several databases, she recommends that they only be stored once. Implementation of her recommendation would benefit the company by contribution to a. increase data sharing b. data independence c. data integration d. reduce data redundancy
d. reduce data redundancy
The basic document created in the billing process is called a _________ a. packing list b. bill of lading c. sales order d. sales invoice
d. sales invoice
Which statement below concerning the database management system (DBMS) is false? a. the DBMS automatically maintains the data dictionary b. the DBMS uses special languages to perform specific functions c. users' requests for information are transmitted to the DBMS through application software d. the DBMS automatically creates application software for users, based on data dictionary parameters
d. the DBMS automatically creates application software for users, based on data dictionary parameters
Alteryx: Which of the following statements are true? a. the output data tool can only output one file at a time b. the output data tool can only write to files c. the output data tool includes an output anchor d. the output data tool's configuration options change based on the output file type
d. the output data tool's configuration options change based on the output file type
Which of the following statements about the Unique tool is True? a. it's best practice to join the results from the U & D outputs b. The unique can change the case of the characters in a field c. You can select up to 10 columns in one Unique tool d. the unique tool is case sensitive
d. the unique tool is case sensitive
In Tableau, which of the following best describes a marks card? a. where you determine which variables will go on what axis b. text boxes that appear when hovering over a mark on a sheet to give more information c. used to limit what data is displayed on the sheet d. used to create a sheet that controls most of the visual elements in a sheet. allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail
d. used to create a sheet that controls most of the visual elements in a sheet. allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail
In Tableau, which of the following best describes the rows and columns shelf? a. used to limit what data is displayed on the sheet b. used to create a sheet that controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail c. text boxes that appear when hovering over a mark on a sheet to give more information d. where you determine which variables will go on what axis
d. where you determine which variables will go on what axis
In a data flow diagram of the customer payment process, "Customer" will appear above or in A. A square. B. A circle. C. Two horizontal lines. D. None of the above
A. A square.
The largest differences between the COSO Integrated Control (IC) framework and the COSO Enterprise Risk Management (ERM) framework is A. IC is controls-based, while the ERM is risk-based. B. IC is risk-based, while ERM is controls-based. C. IC is required, while ERM is optional. D. IC is more applicable to international accounting standards, while ERM is more applicable to generally accepted accounting principles.
A. IC is controls-based, while the ERM is risk-based.
Graphical representations of information are often supplemented by A. Narrative descriptions B. Relevant e-mail communications. C. Logic charts. D. Oral descriptions from management.
A. Narrative descriptions
Data flow diagrams depict A. Processes, but not who is performing the processes. B. Processes, but not the data that flows between processes. C. Who is performing processes, but not how they perform the process. D. Who is performing processes, but not the data that flows between processes.
A. Processes, but not who is performing the processes.
An ERP system might facilitate the purchase of direct materials by all of the following except A. Selecting the best supplier by comparing bids. B. Preparing a purchase order when inventory falls to reorder point. C. Routing a purchase order to a purchasing agent for approval. D. Communicating a purchase order to a supplier.
A. Selecting the best supplier by comparing bids.
What corporate objective is based on a company's mission statement? A. Strategic objectives. B. Operations objectives. C. Compliance objectives. D. Reporting objectives.
A. Strategic objectives.
Flowchart symbols A. are divided into four categories. B. are unique to the organization creating the flowchart. C. are normally drawn using a flowcharting template. D. eliminate the need for narrative descriptions or explanations.
A. are divided into four categories
The ________ is a legal contract that defines responsibility for goods that are in transit. A. bill of lading B. packing slip C. back order D. picking list
A. bill of lading
The use of a data warehouse in strategic decision making is often referred to as A. business intelligence. B. managerial accounting. C. data analysis. D. analytical modeling.
A. business intelligence.
Separating the shipping and billing functions is designed to reduce the threat of A. failure to bill customers. B. billing customers for wrong quantities. C. billing customers before merchandise has been shipped. D. shipping the wrong merchandise.
A. failure to bill customers.
An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a A. foreign key. B. primary key. C. relational key D. linkage key.
A. foreign key.
If a firm does not use an ERP, the best way to mitigate the risk of the destruction of master data is to A. implement backup and disaster recovery procedures. B. use an ERP. C. proper segregation of duties. D. use multiple master data files.
A. implement backup and disaster recovery procedures.
A control procedure designed so that the employee that records cash received from customers does not also have access to the cash itself is an example of a(n) A. preventive control. B. detective control. C. corrective control. D. authorization control.
A. preventive control.
A monthly statement sent to customers serves a control purpose by A. providing an opportunity for customers to verify the balance owed and activity on the account. B. triggering the process to record a customer payment. C. summarizing invoices and amounts due for customers. D. reminding customers of the balance due and due date.
A. providing an opportunity for customers to verify the balance owed and activity on the account.
Upon acquiring a new computer operating system, management at Berryhill worried that computer virus might cripple the company's operation. Management decided to install anti-virus software and to build a firewall for its operating system. Berryhill chose to ________ the risk of being crippled by computer virus. A. reduce B. share C. avoid D. accept
A. reduce
Regularly reviewing an accounts receivable aging report can help management do what? A. spot firms who are falling behind in their payments B. identify customers who have not purchased anything lately C. improve the speed which customers make payments D. determine whether the firm's pricing policy is effective
A. spot firms who are falling behind in their payments
The purpose of the COSO ERM framework is A. to improve the organization's risk management process. B. to improve the organization's financial reporting process. C. to improve the organization's manufacturing process. D. to improve the organization's internal audit process.
A. to improve the organization's risk management process.
Data processing includes all of the following except A.verifying subsidiary ledger balances. B.changing customer addresses. C.removing inventory items no longer offered. D.adding the name of a new vendor.
A.verifying subsidiary ledger balances.
c. two (2)
Alteryx: Based on the table below, how many output files will be produced when the output data tool is configured as shown? (the field chosen is common name) a. three (3) b. five (5) c. two (2) d. one (1)
A BPD is a visual way of: A. Describing the systems program B .Describing the activities in a process C. Describing the internal controls of a process D. Describing the documents in a process
B .Describing the activities in a process
Which of the following COSO objectives involves parties external to the organization? A. Strategic objectives. B. Compliance objectives. C. Operation objectives. D. Reporting objectives.
B. Compliance objectives.
All of the following are benefits of the database approach except A. Data integration and sharing. B. Decentralized management of data. C. Minimal data redundancy. D. Cross-functional analysis and reporting.
B. Decentralized management of data.
A DFD is a representation of which of the following? A. Relationship among modules, data, and programs of an AIS B. Flow of data in an organization C. Decision rules in a computer program D. Computer hardware configuration
B. Flow of data in an organization
Recording and processing information about a transaction at the time it occurs is referred to as which of the following? A. Batch processing B. Online, real-time processing C. Captured transaction processing D. Chart of accounts processing
B. Online, real-time processing
In a DFD, a "bubbles" is also known as a A. Data store. B. Transformation process. C. Data flow. D. Data destination.
B. Transformation process.
Which of the following is not a general threat to the revenue cycle? A. inaccurate master data B. loss of customers C. poor performance D. unauthorized disclosure of sensitive information
B. loss of customers
A company uses the method for tracking accounts receivable where customers pay according to individual sales invoices. This describes the ________ method. A. monthly statement B. open-invoice C. balance forward D. cycle billing
B. open-invoice
Databases were originally developed to address which problem? A. to replace the double entry-system B. to address the proliferation of master files C. to increase the speed that an organization could process transactions D. to decrease the costs associated with manual accounting systems
B. to address the proliferation of master files
COSO requires that any internal deficiencies identified through monitoring be reported to whom? A. The external auditor. B. The company's management. C. The board of directors. D. The audit committee.
C. The board of directors.
An ________ is an arrangement where a bank receives customer payments and transmits payment data to the organization. A. e-commerce B. electronic funds transfer (EFT) C. electronic lockbox D. electronic data interchange (EDI)
C. electronic lockbox
The physical view of a database system refers to A. how a user or programmer conceptually organizes and understands the data. B. how the DBMS accesses data for a certain application program. C. how and where the data are physically arranged and stored. D. how master files store data values used by more than one application program.
C. how and where the data are physically arranged and stored.
A low-level view of the database that describes how the data are actually stored and accessed is the A. conceptual-level schema. B. subschema. C. internal-level schema. D. external-level schema.
C. internal-level schema.
The packing slip A. lists the quantity, price, and description of each item included in the shipment. B. lists the price and description of each item included in the shipment. C. lists the quantity and description of each item included in the shipment. D. lists the quantity and price of each item included in the shipment.
C. lists the quantity and description of each item included in the shipmen
Which of the following statements is FALSE? A. A flowchart is an analytical technique used to describe some aspect of an information system in a clear, concise, and logical manner. B. Flowcharts use a standard set of symbols to describe pictorially the flow of documents and data through a system. C. Flowcharts are easy to prepare and revise when the designer utilizes a flowcharting software package. D. A system flowchart is a narrative representation to identify system weaknesses.
D. A system flowchart is a narrative representation to identify system weaknesses.
Which of the following statements is TRUE? A. An internal environment consists of an organizational structure. B. Control activities are a component of COSO ERM. C. The Sarbanes-Oxley Act requires all public companies to have an audit committee. D. All of the above are true.
D. All of the above are true.
Which of the following is not considered the Internal Environment in COSO-ERM? A. External influences. B. Management's risk appetite. C. Ethical Values. D. Compliance with the SEC.
D. Compliance with the SEC.
When the human resources manager wants to build a data dictionary, the manager would use which language? A. Data Manipulation Language B. Data Query Language C. Data Report Language D. Data Definition Language
D. Data Definition Language
The principle of obtaining or generating relevant, high-quality information to support internal control belongs to which of the COSO ERM component? A. Control environment. B. Risk assessment. C. Control activities. D. Information and communication.
D. Information and communication.
File-oriented approaches create problems for organizations because of A. Multiple transaction files. B. A lack of sophisticated file maintenance software. C. Multiple users. D. Multiple master files.
D. Multiple master files.
A clerk at a grocery store scanned the bar code for a low-cost bag of frozen chicken wings then gave his friend an expensive brand-name bag of frozen chicken wings. Which of the following controls would best prevent the clerk from getting away with doing this? A. Physical inventory count. B. Segregation of duties. C. Limited physical access to bar codes. D. Use of RFID tags.
D. Use of RFID tags.
What acts as an interface between the database and the various application programs? A. data warehouse B. database administrator C. database system D. database management system
D. database management system
The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called A .normalization. B. decentralization. C. geometric data modeling. D. semantic data modeling.
D. semantic data modeling.
Alteryx: Output data tool
Which alteryx tool has the following configuration window?
Which of the following commonly initiates the data input process? a. a business activity b. automatic batch processing c. an accounting department source document d. a trial balance query
a. a business activity
All of the following are disadvantages of an ERP system EXCEPT a. an ERP provides an integrated view of the organization's data b. ERP software and hardware can cost midsized companies between $10 million and $20 million dollars c. ERPs frequently cause organizations to change their business processes to standardized ones d. ERPs are relatively complex
a. an ERP provides an integrated view of the organization's data
The application of machines to automatically perform a task once performed by humans is called what? a. automation b. a bot c. descriptive analytic d. data visualization
a. automation
Which of the following is NOT a step in the data processing cycle? a. data collection b. data input c. data storage d. data processing
a. data collection
The process of translating complex data analyses into more easy-to-understand terms to enable better decision making is an example of what? a. data storytelling b. data visualization c. data ethicality d. data analytics
a. data storytelling
Which of the following best describes how external auditors' interactions with their clients is likely to change due to the use of data analytics in the audit process? a. external auditors will stay engaged with clients beyond the audit b. external auditors will spend less time on audits and will not need to spend time with clients outside the audit c. external auditors will spend more time on detailed audit tasks, resulting in longer audit engagements d. external auditors will only interact with their clients virtually
a. external auditors will stay engaged with clients beyond the audit
Which of the following is NOT usually a consideration when designing a coding system? a. government coding regulations b. standardization c. future expansion needs d. ease of reporting
a. government coding regulations
An analytic that answers the question "what might happen in the future?" is an example of which type of analytic? a. predictive analytic b. prescriptive analytic c. descriptive analytic d. diagnostic analytic
a. predictive analytic
Alteryx: What is not a way that a Browse tool can be added to the canvas? a. select a tool on the Canvas and hit Alt+Shift+B b. select a tool on the Canvas and hit Ctrl+Shift+B c. right click a tool on the Canvas and select "Add Browse After" d. drag a browse tool on the Canvas from the tool palette
a. select a tool on the Canvas and hit Alt+Shift+B
Pre-numbered shipping documents and pre-numbered invoices are examples of a. sequence codes b. block codes c. group codes d. mnemonic codes
a. sequence codes
For the following question, identify which SMART objective is most likely violated. An auditor asks a client "Will you please get me the relevant data for the past year?" a. specific b. measurable c. achievable d. relevant e. timely
a. specific
Data must be collected about three facets of each business activity. What are they? a. the business activity, the resources it affects, the people who participate b. the business activity, the transactions it creates, the impact on the financial statements c. the inputs, outputs and processes used d. who is involved, what was sold, how much was paid
a. the business activity, the resources it affects, the people who participate
At its core, data analytics fits into the information value chain in which of the following ways? a. the process of data analytics aims at transforming raw data into valuable information b. data analytics aims to make an organization's conversion process more efficient c. data analytics requires organizations to share synced data with upstream and downstream business partners d. the process of data analytics is geared toward providing additional insight into customer activities and preferences
a. the process of data analytics aims at transforming raw data into valuable information
Which of the following best describes what is meant by a breach of security? a. the unauthorized to or acquisition of data in an electronic format that contains personal information b. breaking into a locked room c. access of personal information on a corporate server d. an unencrypted data transmission
a. the unauthorized to or acquisition of data in an electronic format that contains personal information
Documents that are sent to customers or suppliers and then sent back to the company in the course of a business transaction are known as: a. turnaround documents b. source documents c. input documents d. transaction documents
a. turnaround documents
Source data automation refers to a. using devices to capture transaction data in machine-readable form at the time the transaction is initiated b. using the internet as the operating platform of an accounting information system c. using an accounting information system to electronically bill customers d. using an accounting information system to automate a previously manual transaction process
a. using devices to capture transaction data in machine-readable form at the time the transaction is initiated
Which statement below is TRUE with regards to an audit trail? a. an audit trail begins with the general journal b. an audit trail provides the means to check the accuracy and validity of ledger postings c. an audit trail is a summary of recorded transactions d. an audit trail is automatically created in every computer-based information system
b. an audit trail provides the means to check the accuracy and validity of ledger posting
Tasks that have which of the following attributes are the best candidates for automating EXCEPT a. repetitive b. creative c. rules-based d. time consuming
b. creative
Which transaction cycle includes interactions between an organization and its suppliers? a. revenue cycle b. expenditure cycle c. human resources/payroll cycles d. general ledger and reporting system
b. expenditure cycle
Data differ from information in which way? a. Data are facts about a sale b. information is data organized to provide meaning c. data are meaningful bits of information d. there is not difference
b. information is data organized to provide meaning
The use of data analytics will likely result in significant changes to clients' expectations of their auditors. Which of the following is most likely NOT one of those expected changes? a. more innovative thinking b. more time spent gathering and testing data c. deeper and broader insights d. faster and more efficient delivery of audit findings
b. more time spent gathering and testing data
The value chain concept is composed of the following two types of activities: a. primary and secondary b. primary and support c. support and value d. technology and support
b. primary and support
Common source documents for the revenue cycle include all of the following except a. sales order b. receiving report c. delivery ticket d. credit memo
b. receiving report
Which of the following statements is NOT correct? a. the audit trail is intended to verify the validity and accuracy of transaction recording b. the audit trail consists of records stored sequentially in an audit file c. the audit trail provides the means for locating and examining source documents d. the audit trail is created with document numbers and posting references
b. the audit trail consists of records stored sequentially in an audit file
As described in the text, which of the following best defines the term data analytics? a. the ability to analyze data and draw conclusions b. the science of examining raw data, removing excess noise, and organizing it in order to draw conclusions for decision making c. the process of creating meaningful visualizations from extremely large datasets d. the science of reducing extremely large datasets down to more manageable databases that can be processed using traditional tools
b. the science of examining raw data, removing excess noise, and organizing it in order to draw
Which of the following is a function of an AIS? a. reducing the need to identify a strategy and strategic position b. transforming data into useful information c. allocating organizational resources d. automating all decision making
b. transforming data into useful information
The Data Accountability and Trust Act of 2009 (DATA) required data owners to notify which of the following when a data breach has been discovered? a. The Federal Bureau of Investigation (FBI) b. The Securities and Exchange Commission (SEC) c. The Federal Trade Commission (FTC) d. The National Security Agency (NSA)
c. The Federal Trade Commission (FTC)
Pre-numbering of shipping documents helps to verify that a. documents have been used in order b. company policies were followed c. all transactions have been recorded d. source data automation was used to capture data
c. all transactions have been recorded
How does data analytics play a vital role in today's business world? a. by allowing data to be organized into predefined tables and fields b. by defining three main categories of classes that help organize a company's data structure models c. by examining data to generate models for predictions of patterns and trends d. by capturing the ever-increasing transaction activity of large companies
c. by examining data to generate models for predictions of patterns and trends
Which of the following best summarizes the two key limiting factors for business systems when dealing with big data? a. analytic skills and software tools b. database organization and transaction volume c. data storage capacity and processing power d. data availability and software tools
c. data storage capacity and processing power
If a question reflects the objectives of the organization or the situation under consideration, it fulfills which of the following objectives? a. timely b. achievable c. relevant d. measurable e. specific
c. relevant
In which cycle does a company ship goods to customers? a. production cycle b. financing cycle c. revenue cycle d. expenditure cycle
c. revenue cycle
Alteryx: Which of the following statements are true? a. the output data tool can only output one file at a time b. the output data tool includes an output anchor c. the output data tool's configuration options change based on the output file type d. the output data tool can only write to files
c. the output data tool's configuration options change based on the output file type
The four Vs are considered a defining feature of big data. Which of the following is the best definition of the term big data? a. volition, variety, veracity, & velocity b. variety, visibility, variety, & valuation c. volume, velocity, variety, & veracity d. volume, velocity, visibility, & veracity
c. volume, velocity, variety, & veracity
Implementation of an ERP system requires increased focus on all EXCEPT which of the following controls? a. segregation of duties between custody, authorization, and recording b. data entry controls on validity and accuracy c. controls over access to data d. appropriate disposal of hard copy reports
d. appropriate disposal of hard copy reports
Which of the following is a set of standards created by the AICPA for data files and fields in order to support external audits? a. extract, transform & load (ETL) b. online analytical processing (OLAP) c. audit control language (ACL) d. audit data standards (ADS)
d. audit data standards (ADS)
Product code WSH500D08 is an example of a. sequence codes b. block codes c. group codes d. mnemonic codes
d. mnemonic codes
The general ledger a. summarizes the information on the trial balance b. is posted in total to the general journal c. only includes balance sheet accounts d. summarizes the transactions in journals
d. summarizes the transactions in journals
