Tutorials

SAS Admin Prep Guide

The SAS Certified Platform Administrator for SAS 9 credential is the ideal certification for those who have the skills and knowledge necessary for the administration of the platform for SAS Business Analytics. Successful candidates should be able to:

  • Secure the SAS configuration on each server machine
  • Check status and operate servers
  • Monitor server activity and administer logging
  • Establish formal, regularly scheduled backup processes
  • Add users and manage their access
  • Establish connectivity to data sources
  • Set up and secure metadata folder structures
  • Administer repositories and move metadata

To earn this credential, you must pass the SAS Certified Platform Administration for SAS 9 exam.

 

Required Exam

Candidates who earn this credential will have earned a passing score on the SAS Platform Administration for SAS 9 exam. This exam is administered by Prometric.

  • 65 multiple-choice questions (must achieve score of 69% correct to pass)
  • 2 hours to complete exam
  • Use exam ID A00-250; required when registering with Prometric.
Exam topics include:

Securing the SAS configuration

  • Secure a SAS platform configuration.

Checking the Status and Operation of SAS Servers

  • Manage metadata repositories.
  • Identify the properties and functionality of SAS servers.
  • Validate a SAS server.

Monitoring, Logging, and Troubleshooting SAS Servers

  • Monitor SAS servers.
  • Administer SAS server logging and modify logging configurations.
  • Troubleshoot basic SAS server issues.

Backing Up the SAS Environment

  • Back up the SAS environment.
  • Restore the SAS environment.

Administering Users

  • Manage connection profiles.
  • Manage roles.
  • Register users and groups in the metadata.
  • Give users access to processing servers and data servers.
  • Determine when to store passwords in the metadata.

Administering Data Access

  • Register libraries and tables in the metadata.
  • Update table metadata.
  • Pre-assign a library.
  • Troubleshoot data access problems.
  • Use the metadata LIBNAME engine.

Securing Metadata

  • Identify how the metadata authorization layer interacts with other security layers.
  • Identify where, how, and to whom metadata permissions are assigned.
  • Determine the outcome of metadata authorization decisions.
  • Use metadata permissions to secure metadata.
  • Create and use Access Control Templates.

Moving Metadata

  • Promote metadata and associated content.

 

Registration Options

OnlineVisit www.prometric.com/sas. Follow these easy steps once on the site:

    • Select the "Schedule a Test"
    • Select "Schedule an Appointment"
    • Choose your country and state/province if applicable
    • Insure that "SAS Institute" is selected as your client and program
    • Select your desired SAS certification exam
    • Review available testing sites and select "Schedule Appointment"

First-time registration with Prometric requires a 24-hour waiting period before the candidate can schedule an exam online. Candidates who are registering for an exam for the first time will receive an email confirmation from Prometric within 24 hours to begin the online scheduling process. Candidates who have previously tested with Prometric and have their Prometric ID or have previously registered online can schedule their exam online immediately.

Testing Locations

To find your nearest testing center, visit www.prometric.com/sas.

Information required upon registration

Please be prepared to provide the following information to Prometric when registering:
First and last name - Please provide your name as you would like it to appear on your certificate.
Prometric assigns a unique identification number to each candidate. Please use this ID number each time you schedule an exam with Prometric or SAS.
Mailing address - Please list the address to which all correspondence should be mailed.
Company name - If you have listed your business address, please include your company name to ensure appropriate routing.
E-mail address - For the latest program updates, email is the most efficient and effective means of contacting you.
Contact phone numbers
Exam number and title
Testing center preference - To find your nearest testing center, visit www.prometric.com/sas.
Method of payment (credit card (American Express, Mastercard, and Visa), vouchers) Payment options may vary by country.
If your address has changed since you last registered for an exam, please contact Prometric to update your demographic information.

Exam Pricing

Within North America and India, the cost associated with an exam offered through Prometric is US $180. Certification exam prices are subject to change. In some countries, different pricing and additional taxes may apply. Please visit www.prometric.com/sas for exam pricing in your country. Faculty, staff, and full-time students of degree-granting institutions are eligible for a discount on SAS Certification exams. Candidates in the United States and Canada receive a 50% discount. International candidates should contact your local office for discount information.
Sample Questions:
1. Which SAS-recommended default account is used to impersonate clients already authenticated on the metadata server and prevent having user accounts on multiple back-end servers?
A. sastrustB. sassrvC. saswbadmD. sasadm
Answer: A
2. In SAS Management Console, which components are required for promotion and replication?
A. SAS Replication Server, SAS Administration Server and SAS Workspace Server B. Foundation Repository, Custom Repository and Project RepositoryC. SAS Workspace Server, SAS Stored Process Server and SAS/CONNECT ServerD. SAS Administration Server, SAS Source Server and SAS Target Server
Answer: D
3. A connection is made to the SAS Metadata Server. The following SAS program is submitted:
libname mymeta meta ? repname = 'Foundation' metaout = XXXXXXXX;data mymeta.class;set sashelp.class;stop;run;
4. What is the value of the METAOUT = option that specifies to write only the metadata tothe SAS Metadata Server?
A. metaservB. dataC. metaD. metadata
Answer: C
5. Which SAS Management Console definitions are required on the source and target servers for replication and promotion?
A. Source: SAS Metadata Server, SAS Workspace Server,Target: SAS Metadata Server, SAS\CONNECT Server, IOM SpawnerB. Source: SAS Metadata Server, SAS\CONNECT ServerTarget: SAS Metadata Server, SAS Workspace Server, IOM SpawnerC. Source: SAS Metadata Server, SAS Workspace Server, IOM SpawnerTarget: SAS Metadata Server, SAS\CONNECT ServerD. Source: SAS Metadata Server, SAS\CONNECT Server, IOM SpawnerTarget: SAS Metadata Server, SAS Workspace Server
Answer: C
6. In SAS ETL Studio, what is stored as a metadata identity?
A. a user or a group of users of the metadata environmentB. a list of the warehouse server names and port numbersC. the libraries containing the data in the warehouseD. the location of the SAS Metadata Server
Answer: A
7. In SAS ETL Studio, which action generates and stores code to a file, which allows thejob to be included in a job flow in SAS Management Console?
A. Register to MetadataB. Publish to Deployment DirectoryC. Export Job to FileD. Deploy for Scheduling
Answer: D
7. Which connection type is used in SAS Management Console to support a load-balancedStored Process or Workspace Server?
A. MP CONNECTB. Multi-threadC. COM/DCOMD. MultiBridge
Answer: D
8. In the SAS Intelligence Platform, where is descriptive information about data librariesstored?
A. on the SAS Workspace ServerB. on the SAS Information ServerC. on the SAS Foundation ServerD. on the SAS Metadata Server
Answer: D
9. In SAS Management Console, what is enabled by the Schedule Manager?
I.ability to start and halt the execution of the scheduled flowII.ability to create job flows, which contain one or more jobs for schedulingIII.ability to create dependencies for jobs in the flow, which can be based on time, otherjobs, or filesIV.ability to schedule a flow to run, based on specified conditions; such as run once, runmanually, or run whenever a dependency is met
A. II and III onlyB. II, III and IVC. I, II and IIID. I and III only
Answer: B
10. In the SAS Management Console Metadata Manager plug-in, which repository action erases the selected repository, the repository contents, and all metadata that defines the repository?
A. RemoveB. DeleteC. DestroyD. Purge
Answer: B
11. Which object(s) is/are evaluated by the SAS Management Console Metadata Authorization Facility when making an authorization decision for an object in a project repository?I.Default ACTII.Access Control EntryIII.Permission ConditionsIV.Security Rule Schema
A. I onlyB. IV onlyC. I, II, III and IVD. I, II and III only
Answer: A
12. Which repository tree can be defined in SAS Management Console?
A. A Project Repository depends on two Custom Repositories, which depend on theFoundation Repository.B. Two Project Repositories depend on a Custom Repository, which depends on theFoundation Repository.C. A Custom Repository depends on two Project Repositories, which depend on theFoundation Repository.D. Two Custom Repositories depend on a Project Repository, which depends on theFoundation Repository.
Answer: B
13. In addition to ReadMetadata and WriteMetadata, which metadata layer access control permission(s) is/are enforced by the SAS Metadata Server?
A. DeleteMetadata, CheckinMetadata, CheckoutMetadataB. CheckinMetadata and CheckoutMetadata onlyC. DeleteMetadata onlyD. CheckinMetadata only
Answer: D
14. What information does the SAS Metadata Repository contain?
I.user IDs, passwords, server definitionsII.physical structure and format of the dataIII.business metadata in non-technical termsIV.business rules for the extract, transformation and load process
A. II, III and IV onlyB. III and IV onlyC. I and II onlyD. I, II, III and IV
Answer: D
15. The location of the repository manager physical files can be found in:

  1. SAS Management Console.
  2. the metadata server's omaconfig.xml file.
  3. the foundation repository.
  4. the metadata server's sasv9.cfg file.


Answer: = "B"
16. Every SAS platform implementation includes:

  1. a foundation repository and a repository manager.
  2. a foundation repository and a custom repository.
  3. a custom repository and a repository manager.
  4. multiple project repositories.


Answer: = "A"
17. Which procedure allows a platform administrator to update table metadata?

  1. METAUPDATE_RULE
  2. METASELECT
  3. METATABLE
  4. METALIB

Answer: = "D"
18. Which statement regarding pre-assigned libraries is true?

  1. Pre-assigned libraries reduce the initialization time for a workspace server.
  2. Pre-assigned libraries always connect to an RDBMS at server initialization.
  3. Pre-assigned libraries always connect to a base SAS library at server initialization.
  4. Pre-assigned libraries do not have to be identical across all SAS client applications.


Answer: = "C"
19. A platform administrator needs to retrieve from the metadata a complete LIBNAME statement including the user ID and password. To complete this task, the platform administrator must be connected to SAS Management Console with what type of user access in the metadata?

  1. Access to the credentials associated with libraries created with the METALIB procedure.
  2. Access to credentials established by the LIBNAME engine.
  3. Access to credentials associated with users in the outbound login.
  4. Access to credentials for the authentication domain associated with the database server.


Answer: = "D"
20. By default, which groups have WriteMetadata on the Foundation repository?

  1. PUBLIC
  2. SASUSERS
  3. ADMINISTRATORS ONLY
  4. SAS SYSTEM SERVICES ONLY


Answer: = "B"

21. Given the following authorization settings for Library Sales2:


Library Sales2's parent folder has an explicit grant of RM for Mary.
Library Sales2 has an explicit denial of RM for PUBLIC.
Which statement is true?

  1. Mary can see Library Sales2.
  2. Mary can see data flagged as PUBLIC in Library Sales2.
  3. Mary cannot see Library Sales2.
  4. Mary can see Library Sales2, but not any data flagged as PUBLIC.


Answer: = "C"
22. Which statement is FALSE regarding the WriteMemberMetadata (WMM) permission?

  1. By default, it mirrors the WriteMetadata permission.
  2. It only applies to folders.
  3. If WriteMetadata is granted, then you should not deny WMM.
  4. WMM is inherited from one folder to another folder.


Answer: = "D"
23. Content has been exported from a SAS 9.1.3 environment into a SAS 9.2 development environment. After the export, the platform administrator attempts to promote an object from the SAS 9.2 development environment into a production environment. What will be the result of this promotion attempt?

  1. The promotion will not be allowed because objects from SAS 9.1.3 cannot be promoted to SAS 9.2.
  2. The promotion will not be allowed because objects in a development environment cannot be promoted to a production environment.
  3. The promotion will be allowed assuming the object type is allowed for promotion.
  4. The promotion will not be allowed because objects exported from a previous environment cannot be promoted.

Answer: = "C"
24. Upon initial install, all of the capabilities in the 'Web Report Studio: Report Creation' role are also included in which role?

  1. Web Report Studio: Report Viewing
  2. Web Report Studio: Advanced
  3. Web Report Studio: Content Management
  4. Web Report Studio: Administration

Answer: = "B"
25. Which statement is true regarding connection profiles used with the SAS platform applications?

  1. Each SAS platform application must have its own connection profile.
  2. Connection profiles are stored on the server machine.
  3. Connection profiles are stored on the machine where the SAS application is installed.
  4. All SAS platform applications share one connection profile.

Answer: = "C"
Miscellaneous Questions:

  1. Which type of repository exists in every environment?

Foundation

  1. If a repository mode is online and the metadata server access state is offline, can an unrestricted user access and modify metadata in the repository?

No. no one can read/write/access metadata if the metadata server is offline, regardless of repository mode

  1. What is the difference between unregistering a repository and deleting a repository?

Unregistering a repository removes metadata about repository but deleting a repository both removes metadata about repository and deletes physical files (not folder)

  1. What are two differences between a project repository and a custom repository?

Project repository: has an owner, can only be accessed via DIS
Custom repository: has no owner, can be accessed in all applications

  1. Which types of servers are instantiated by the object spawner and have sessions that get reused by different users?

Stored process server and pooled workspace server.

  1. What are two differences between a workspace server and a pooled workspace server?

Pooled ws runs under shared credentials and can only be used by some applications to query relational maps. WS runs under user's credentials and can be used by all applications to do many things (access data, analyze data, etc).

  1. What is the difference between the SASApp Workspace Server and the SASMeta Workspace Server?

The SASApp ws is for general use by end users while the SASMeta ws is for admins only (secured in metadata) and has XCMD allowed by default.

  1. Where is the initial directory for navigating the SAS session on a stored process or workspace server defined?

In SMC, Server Manager plug in, physical server properties, options, advanced options, file navigation ? SAS User root

  1. How should the SAS configuration directory be secured?

Directoyr should be owned by SAS Installer, process owners for SAS servers will need read/write access, backup account will need some read/write access, and a few admins need os access

  1. Which file does the object spawner read to know how to connect to the metadata server?

metadataConfig.xml

  1. What is the purpose of a batch server?

Provides command line for scheduler to invoke SAS or Java to run job

  1. Where do the logging settings for a server get defined?

Logconfig.xml file, location specified in LOGCONFIGLOC= option in sasv9.cfg file for server. Settings from logger tab in SMC dynamically affect logging settings as well

  1. How do you troubleshoot a server that won't start up?

Check the services, logs, command line launch.

  1. What are the two ways to set up an unrestricted user?

Make a metadata identity a member of the Metadata Server: Unrestricted role or add the user's fully qualified user ID with preceding asterisk in adminUsers.txt and restart metadata server.

  1. Which logins does a user have access to in the metadata?

User can access logins stored on their own metadata identity and on groups that they are directly or indirectly members of.

  1. When can you use a SAS internal account?

Internal accounts are used to authenticate to the metadata server only.

  1. Who is in PUBLIC but not in SASUSERS?

PUBLIC includes all users who can authenticate to the metadata server and SASUSERS includes the subset of PUBLIC that has their own metadata identity. So any users who can authenticate to the metadata server but do not have a metadata identity are in PUBLIC but not SASUSERS.

  1. When can you use Integrated Windows Authentication?

You can use IWA from a SAS app running on a Windows desktop to a SAS server running on a Windows machine in the same or trusted Windows domain.

  1. All SAS servers are set up to accept Integrated Windows Authentication by default. Where in an individual desktop application do you tell the application to connect to the metadata server using IWA?

In the connection profile.

  1. When do you need to store a password in the metadata?

When you need to access an external database and for seamless access to a standard workspace server (not set up to use SAS Token Authentication).
Good answer: for internal accounts

  1. What types of servers can use SAS Token Authentication?

OLAP, Table, stp, pooled ws use it automatically and can set up standard ws to use token auth as well.

  1. When do libraries get assigned?

Either as needed (when the user first accesses a table) or as the server starts up (pre-assigned)

  1. Can you register the same library more than once in the metadata?

Yes but not in the same folder or assigned to the same application server.

  1. Can you register the same table more than once in the metadata?

Yes but not in the same folder.

  1. Which tables do you need to register in the metadata?

Most likely, not all tables in your enterprise need to be registered in the metadata. Only those tables (not local to the user's machine) that users will need to access from SAS applications .

  1. Which applications have connection profiles stored on the end users' machines?

Desktop Java (SMC, DIS, OCS, IMS) and Windows applications (EG, AMO) but not Web applications.

  1. What state does the metadata server need to be in in order to backup the metadata using the Backup Wizard?

The metadata server must be online when you run OMABAKUP (which is what the Backup Wizard uses). OMABAKUP will connect to the metadata server, pause the server, backup, resume the server.

  1. You run your metadata backup as Ahmed. What access does Ahmed need in the metadata? What access does Ahmed need on the operating system?

Ahmed needs to be a member of the Metadata Server: Operations role (in order to pause and resume metadata server). Also needs metadata access to repositories that will be backed up (RM). Ahmed needs read access to folders that hold files/metadata to be backed up and read/write access to location where backup is stored.

  1. What happens if you run OMABAKUP on a SAS session with the –noxcmd option?

OMABAKUP uses X commands (xcopy) to copy files on operating system (not metadata, that uses PROC COPY). So copying of certain files will fail.

  1. What account does the object spawner use to connect to the metadata server and where is that information stored?

SAS Trusted User which in class is sastrust@saspw and connection information is stored in metadataConfig.xml in object spawner folder (ex C:\SAS\Config\Lev1\ObjectSpawner)

  1. How do you enable workspace server logging?

Use the logconfig.trace.xml file or make similar modifications to logconfig.xml file for workspace server.
Reference:
http://support.sas.com/certify/creds/pa.html#t1