Free A00-262 - SAS Certified Data Quality Steward for SAS 9 Exam Questions and Answers

A data steward runs a data profile on the STATE field of a customer table and wants to see each distinct value together with the number of records in which it occurs. Which profile report should the steward open?

• AA. Basic Statistics
• BB. Pattern Frequency Distribution
• CC. Outliers
• DD. Frequency Distribution

A data steward has built a data job that standardizes a source file, and it must run as a nightly batch on the Data Management Server. In Data Management Studio, where should the steward import the job on the server?

• AA. Real-Time Data Services
• BB. Business Rules
• CC. Real-Time Process Services
• DD. Batch Jobs

While reviewing a locale in the Quality Knowledge Base, a steward needs the component that holds words along with the category each word belongs to, so that a parse definition can recognize tokens such as given names or street types. Which QKB component should the steward open?

• AA. Grammar
• BB. Chop table
• CC. Vocabulary
• DD. Phonetics library

A data steward needs a business rule that checks whether the average ORDER_AMOUNT across all rows of a table stays below a set limit, and the result must be one pass or fail for the entire table. Which rule type should the steward create?

• AA. Group rule
• BB. Field rule
• CC. Row rule
• DD. Set rule

A data job applies the Standardization node to the field PHONE using the Phone standardization definition, and the steward leaves the default output settings. Which result does the node produce?

• AA. A new output field named PHONE_Out holds the standardized value
• BB. A separate report lists the changes and PHONE is left unchanged
• CC. The original PHONE field is overwritten with the standardized value
• DD. A new output field named PHONE_Stnd holds the standardized value

A data steward saves a new data job in a Data Management Studio project folder. What file extension does the saved data job have? Include the leading period.

Type your answer, then reveal.

A process job contains three Data Job (reference) nodes named Extract_Orders, Clean_Orders and Load_Orders. Clean_Orders and Load_Orders are both linked directly from Extract_Orders. Load_Orders reads the file that Clean_Orders writes, and the job fails intermittently because Load_Orders sometimes finds that file incomplete. Which change corrects the design?

• AA. Add a Global Code node that sets a macro variable for the output file path
• BB. Replace Load_Orders with a Parallel Iterator node
• CC. Link Load_Orders from Clean_Orders instead of from Extract_Orders
• DD. Insert a Fork node between Extract_Orders and the two downstream nodes

In a Parsing node, the selected parse definition from the QKB splits a text string into its meaningful components, such as given name and family name. What term does the QKB use for each of these individual components?

Type your answer, then reveal.

A data steward is building a process job in DataFlux Data Management Studio. One step must run a data job that is already saved in the repository, so that later edits to the saved job are picked up without changing the process job. Which node should the steward add to the process flow?

• AA. Data Job (reference)
• BB. SQL Execute
• CC. Data Job
• DD. Process Job (reference)

A data steward created a task that contains one business rule. The rule checks the fields ORDER_AMT and ORDER_DATE. The task must be run against two tables: one with columns AMT and ODATE, and one with columns TOTAL and ORDERED_ON. Each table is read by its own data job that includes a Data Monitoring node. What should the steward do so that the same task can be used for both tables?

• AA. In each Data Monitoring node, select the task and map the rule fields to the table's columns
• BB. Combine the two tables with a Union node and run the task once against the result
• CC. Add a Field Layout node to each job and rename the columns to ORDER_AMT and ORDER_DATE
• DD. Create a copy of the rule for each table that uses that table's column names