ACL_Quiz

What does the ASSIGN Command represent?

• It is used to create a variable

• It is used to group fields

• It is used to export results

• it is used to create a folder

Which Code can be used to find duplicates in a dataset?

• SUMMARIZE Command

• STRATIFY Command

• DUPLICATES Command

• CROSSTAB Command

Which command is correct??

• SUMMARIZE ON CompanyType CompanyCode SUBTOTAL Quantity Amount TO Transactions_Grouped PRESORT

• USE Transactions

  SUMMARIZE ON CompanyType CompanyCode SUBTOTAL Quantity Amount TO Transactions_Grouped PRESORT

• USE Transactions

  SUMMARIZE ON CompanyType, CompanyCode SUBTOTAL Quantity, Amount TO Transactions_Grouped PRESORT

Which of the following DAP Directlink tags filters SPRAS qual to 1?

• </w><f>SPRAS</f><o>0</o><l>1</l><h></h><w>

• <w><f>SPRAS</f><o>1</o><l>1</l><h></h></w>

• <w><f>SPRAS</f><o>0</o><l>1</l><h></h></w>

• <w><f>SPRAS</f><O>0</O><l>1</l><h></h></w>

Please choose the Direct Link filter tag operators that are correct (there are more than one answer) :

• <o>1</o> : equal to

• <o>6</o> : Not equal to

• <o>7</o> : Contains

• <o>2</o> : Between

• <o>6 </o> : Between

Which IMPORT Excel Command is correct?

• ASSIGN Target_Table = "Credit_Cards"

  ASSIGN ACL_Table = Target_Table + ".fil"

  IMPORT EXCEL TO %Target_Table "%ACL_Fil%" FROM "Transactions.xlsx" TABLE "Credit_Cards$" KEEPTITLE CHARMAX 200

• ASSIGN Target_Table = "Credit_Cards"

  ASSIGN ACL_Table = Target_Table + ".fil"

  IMPORT EXCEL TO %Target_Table% "%ACL_Fil% FROM "Transactions.xlsx" TABLE "Credit_Cards$" KEEPTITLE CHARMAX 200

• ASSIGN Target_Table = "Credit_Cards"

  ASSIGN ACL_Table = Target_Table + ".fil"

  IMPORT EXCEL TO %Target_Table% "%ACL_Fil%" FROM "Transactions.xlsx" TABLE "Credit_Cards$" KEEPTITLE CHARMAX 200

• ASSIGN Target_Table = "Credit_Cards"

  ASSIGN ACL_Table = Target_Table + .fil"

  IMPORT EXCEL TO "%Target_Table%" %ACL_Fil% FROM "Transactions.xlsx TABLE "Credit_Cards$" KEEPTITLE CHARMAX 200

Which Join command is correct?

• USE Customer_Master PRIMARY

  USE Customer_Sales SECONDARY

  JOIN PKEY Customer_Type Customer_Number FIELDS Customer_Address Customer_City Customer_Country SKEY Sales_Type Sales_CustomerNr WITH OrderDate ShippingDate ReceivedDate Quantity Amount PRIMARY TO Customer_Sales_1 PRESORT SECSORT OPEN

• USE Customer_Master PRIMARY

  USE Customer_Sales SECONDARY

  JOIN ON PKEY Customer_Type Customer_Number FIELDS Customer_Address Customer_City Customer_Country SKEY Sales_Type Sales_CustomerNr WITH OrderDate ShippingDate ReceivedDate Quantity Amount PRIMARY TO Customer_Sales_1 PRESORT SECSORT OPEN

• USE Customer_Sales SECONDARY

  JOIN PKEY Customer_Type Customer_Number FIELDS Customer_Address Customer_City Customer_Country SKEY Sales_Type Sales_CustomerNr WITH OrderDate ShippingDate ReceivedDate Quantity Amount PRIMARY TO Customer_Sales_1 PRESORT SECSORT OPEN

• USE Customer_Master PRIMARY

  USE Customer_Sales SECONDARY

  JOIN SKEY Customer_Type Customer_Number FIELDS Customer_Address Customer_City Customer_Country PKEY Sales_Type Sales_CustomerNr FIELDS OrderDate ShippingDate ReceivedDate Quantity Amount PRIMARY TO Customer_Sales_1 PRESORT SECSORT OPEN

What is the CROSSTAB Command?

• It is used to pivot a table

• It is used to duplicate a table

• It is used to stratify a table

• It is used to open a table

Which of the following is considered as best practice to script any Audit scenario?

• 1. Download Data
  2. Build Scenario
  3. Cleanse Data
  4. Join Tables
  5. Publish Result

• 1. Download Data
  2. Publish Result
  3. Cleanse Data
  4. Create Scenario
  5. Join Tables

• 1. Download Data
  2. Cleanse Data
  3. Join Tables
  4. Build Scenario
  5. Publish Result

• 1. Download Data
  2. Cleanse Data
  3. Build Scenario
  4. Join Tables
  5. Publish Result

Was this quiz stressful?

• Yes

• No

• Little bit