ACDA Level 3
ACDA Level 3
ACDA Level 3
1645 POINTS
LEVEL 3 EXAM
MORE
INCORRECT
True or false? If data is not pre-sorted when you run the Gaps command, the results may be incorrect.
True
False
INCORRECT
You have previously defined a table layout for a fixed-width inventory file for January 2016.
You now want to use an inventory file for February 2016 in Analytics with the same file structure.
How would you create a table layout for the February data without using the Data Definition Wizard?
In the Navigator, copy the January2016 table. Rename the copied table
'February2016'. Link the new table to the February 2016 source file.
Re-use the import command after changing the name of the file you’re
importing, the name of the table you're importing to, and the FIL file
that will be created.
You are working with an insurance claim table that contains fields for claim_date and
claim_payment_date.
Which of the expressions below would find issues where the claim_payment_date took place before the
claim_date?
claim_date = claim_payment_date
INCORRECT
You relate AP_Transactions (primary) with Vendor_Master (secondary) using Vendor_No as the key
field.
Which of the following filters will identify if there were any transactions (AP_Transactions) made from
vendors that don't exist in the Vendor_Master table?
Vendor_No = Vendor_Master.Vendor_No
ISBLANK(Vendor_Master.Vendor_No)
ISBLANK(Vendor_No)
NOT ISBLANK(Vendor_Master.Vendor_No)
INCORRECT
Which file format is the most reliable and consistent method to import data from as recommended by
Analytics?
Report files
PDF files
Fixed-width files
Excel files
INCORRECT
You are trying to join two tables using character key fields. Your join isn't returning all of the expected
results and you suspect it it may be due to mixes of upper and lower case letters (eg. 'SMITH' vs.
'Smith'). Which of these expressions could you use to create a computed field in each table to "clean-up"
the key fields so that the join will work?
ALLTRIM(UPPER(CLEAN(UPPER(field_name), LENGTH(field_name)))
ALLTRIM(UPPER(key _field_name))
RJUSTIFY(UPPER(TRANSFORM(key _field_name))))
CORRECT
You need to find out if any employees received more than one cheque (with a different cheque number)
on the same pay date from a table with the following data:
Your result table should report issues with the same employee number and date, but different cheque
numbers.
Run the Duplicates command on EMP_NO and PAY_DATE then run the
Summarize command on all three fields.
Run the Summarize command on all three fields and filter using COUNT
> 1.
Run the Summarize command on all three fields then run the
Duplicates command on EMP_NO and PAY_DATE.
INCORRECT
A table contains a field named Region (Character) and another named Invoice_Amount (Numeric).
How would you create a new table that contains all of the transactions in Regions AOl and A02 where
the Invoice_Amount exceeds $5,000?
Run the Extract command with a command filter using the syntax
MATCH(Region "AOl" AND "A02") AND Invoice_Amount > 5000.
Create a View filter using the syntax (Region = "AOl" OR Region = "A02")
AND Invoice_Amount > 5000.Then Extract to a new table.
Run the Extract command with a command filter using the syntax
(Region = "AOl" OR Region = "A02") AND Invoice_Amount > 5000.
Run the Extract command with a command filter using the syntax
MATCH(Region, "AOl", "A02") AND Invoice_Amount > 5000.00.
INCORRECT
Fill in the blanks of this script so that the result is a unique listing of all customers (CustNr) and their
subtotals (Amount_LC), sorted in descending order on amount.
OPEN T_Input
[ OPEN ] T_Sum
CORRECT
You have received a file from a system that only provides two digits for the year. You have been advised
that a date field in this file contains dates before, on, and after January 1, 2016. How do you ensure that
the dates are properly interpreted in Analytics?
Manually input the format of the year as CYY where C is the Century and
is a 0 for the 20th century and a 1 for the 21st century.
INCORRECT
Assume that 37739 is the number of days that have elapsed since 01/01/1950. How do you convert a
serial date such as 37739 to a value that Analytics can process as a date?
Define the data as a date field and assign the format DDDDD.
Define the data as a numeric field, then create a computed field that
subtracts the date, 01/01/1950, from the numeric field.
Define the data as a numeric field, then create a computed field that
adds the date, 01/01/1950, to the numeric field.
INCORRECT
Which of the methods listed below can not be used to create scripts in Analytics?
INCORRECT
Which of the following strings below would this expression return? REGEXFIND(Last_Name,"^Goo?
n").
Gon
gon
Gones
gones
Goony
gooven
INCORRECT
INCORRECT
Which of the strings below from the Word_List field would be found, when you apply the expression
MATCH (Word_List, "ca")
Acra
Cab
Cat
Cabal
Cabalca
Acadaca
CORRECT
Which command below allows you to count the number of records, total the values , find the average,
and tag the the 5 highest and lowest values?
TOTAL
STATISTICS
VERIFY
SET
PROFILE
INCORRECT
Your objective is to calculate the number of hours between the two dates, to two decimal places.
For example, if the Approval_Date appears in Analytics as Oct 29/2013 09:47:44 and the Invoice_Date
appears as Oct 25/2013 11:17:44, you want the result to be 94.50.
(Approval_Date - Invoice_Date) * 24
ROUND(( Approval_Date - Invoice_Date) * 24)
INCORRECT
You have a table and the source data looks like this:
Given that:
How would you create one field comprised of the PO Box number and the vendor number? The created
field will contain 11 numbers. Select all that apply.
Without deleting either field, highlight the first 11 numbers in the table
layout.
Delete both fields because you cannot define data twice and then
highlight the first 11 numbers in the table layout.
CORRECT
An accounts receivable table contains four fields: customer number, transaction amount, invoice date and
transaction type. How should you create a new table containing the most recent transaction date for each
customer?
INCORRECT
You are scripting in Analytics and want to set the date to the format DD/MM/YY, how would you script
this?
SET DATE 0
SET DATE 1
SET DATE 2
INCORRECT
Which command determines if any sequential cheque numbers are missing from the series?
Verify command
Profile command
Evaluate command
Statistics command
CORRECT
You are running the Fuzzy Duplicates command on a field called Vendor_Address which is 30 bytes
long. The file contains 10,000 records. Leaving the Result Size % at its default setting of 10% produces a
result only if the number of:
INCORRECT
When you define date fields in Analytics, which of these are acceptable formats of source data?
YYYYDDD
YYDDD
DD MMM YYYY
INCORRECT
When running the Fuzzy Duplicates command, which of the settings below would include the values
"Polo" and "Posh"?
Difference Threshold of 2
INCORRECT
When you run the Verify command on a computed field, Analytics will:
Assume that the field is correct only if the data fields it is based on
have had Verify run on them.
Bypass the field, but Verifies the data fields it is based on even if they
haven't been selected.
INCORRECT
If there are 10 different regions, what is the most efficient way to create a separate aging report for each
region?
Apply a filter for all invoices in the first region and run the Age
command. Then repeat the steps for the remaining 9 regions.
Extract all the invoices in the first region using a command filter and
run the Age command on the result. Then repeat the steps for the
remaining 9 regions.
Sort or Index the file by Region_Code and run the Age command on the
sorted file with the Region_Code selected on the Break parameter.
Index the file by Region_Code and run the Age command on the indexed
file with the Region_Code selected on the Group parameter.
INCORRECT
INCORRECT
If you had a table containing the data below and you ran the Duplicates command firstly using the key
fields Vendor and Amount, then a second time on the resulting table using only the key field Vendor,
how many records would result?
3
4
INCORRECT
You cannot Join on numeric fields but you can select them in the
primary fields section.
You can Join on numeric fields but you must first harmonize the lengths
of the key fields.
You can Join on numeric fields only if they are computed fields.