This page is a one-stop solution for any information you may require for SAS Certified BI Content Developer for SAS 9 (A00-270) Certification exam. The SAS A00-270 Exam Summary, Syllabus Topics and Sample Questions provide the base for the actual SAS Certified BI Content Developer exam preparation, we have designed these resources to help you get ready to take your dream exam.
The SAS Certified BI Content Developer for SAS 9 credential is globally recognized for validating SAS BI Content Developer knowledge. With the SAS Certified BI Content Developer Certification credential, you stand out in a crowd and prove that you have the SAS BI Content Developer knowledge to make a difference within your organization. The SAS Certified BI Content Developer for SAS 9 Certification (A00-270) exam will test the candidate's knowledge on following areas.
SAS A00-270 Exam Summary:
| Exam Name | SAS Certified BI Content Developer for SAS 9 |
| Exam Code | A00-270 |
| Exam Duration | 120 minutes |
| Exam Questions | 60-65 multiple-choice and short-answer questions |
| Passing Score | 70% |
| Negative Marking | No (There will not be any penalty for wrong answer) |
| Exam Price | $180 (USD) |
| Training | Creating Business Intelligence for Your Organization: Fast Track |
| Exam Registration | Pearson VUE |
| Sample Questions | SAS BI Content Developer Certification Sample Question |
| Practice Exam | SAS BI Content Developer Certification Practice Exam |
SAS A00-270 Exam Topics:
| Objective | Details |
|---|---|
Information Consumer Reporting Applications |
|
| Use the SAS Add-In for Microsoft Office. |
- Open and navigate a data source in MS Excel. - Identify the different types of data sources that can be used with the SAS Add-In for Microsoft Office. - Use the Quick Stats task to calculate basic statistics for a SAS data source. - Use the Automatic Chart task to create charts and explore a SAS data source. - View and interact with SAS results. |
| Use SAS Web Report Studio. |
- Open existing reports, view reports, navigate reports. - Build, customize, save and share reports. - Create a new report using one of these methods: Edit mode, Report Wizard, a report template, open a source directly; open a stored process directly. |
| Use SAS Information Delivery Portal. |
- View SAS BI Dashboards, SAS reports, and SAS stored processes, SAS publication channels, SAS packages using the SAS Information Delivery Portal. - Create a new page and be able to share a page on the SAS Information Delivery Portal. |
Data Management |
|
| Modify an existing SAS Information Map. | - Given a scenario where an information map is not providing necessary statistical information, modify data items to provide users with the desired data. |
| Create a New SAS BI Dashboard Indicator. | - Explain the relationship between indicators and their associated indicator data components. |
| Create data sources for reporting and analysis. |
- Build a SAS Enterprise Guide project to read and combine data sources to create a new table. - Identify the different types of data sources that can be used with SAS Web Report Studio. - Use SAS OLAP Cube Studio to build an OLAP cube. - Identify the required metadata permissions to view data. |
| Interpret permissions and file structures defined in metadata by the platform administrator. |
- Explain the differences between metadata users, groups and roles. - Identify which SAS applications support metadata roles. - Explain the structure and use of the SAS Folders tree. - Define the purpose and types of connection profiles. - Determine metadata permission settings based upon the type of function to be accomplished. |
| Describe the metadata created and used by the SAS Platform. |
- Define the purpose of a connection profile. - Identify SAS Management Console interface components. - Define default requirements for distributing reports using SAS Web Report Studio - Explain the process of registering a library, including SAS and DBMS libraries. - Describe how to prepare images for use in SAS Web Report Studio. |
| Create information map data sources. |
- List valid data sources. - List the requirements for data sources that can be used to create an information map. |
Creating Information Maps |
|
| Utilize different data sources. |
- Identify the steps required for creating an information map using SAS Information Map Studio. - Given a particular scenario, determine the type of query language required to retrieve the data values from each type of data source. - Detail the types of joins that are available when an information map contains more than one relational table. - Explain how to automatically create relationships between a newly added data source and any existing data sources. - Explain how to replace unresolved resources such as servers, libraries, tables and cubes if a resource becomes unresolved or if you want to change resources. |
| Use filters and the prompting framework to dynamically subset data. |
- Define the types of filters that are available for subsetting data in an information map. - List the different methods for creating a new filter in SAS Information Map Studio. - Describe the ways that data items can be used in a filter. - List the possible filter conditions. - Given a particular scenario, determine the different filter values that could be used. - Describe the options that might be available when you create a filter. - List the steps to create a filters including a simple filter, a compound filter, and an identity-driven filter - Describe the functionality provided by the filter combination section of the New Filter window. |
| Create prefilters to subset the information map data. |
- Define and state the purpose of prefilters. - Describe the two types of prefilters. - Determine required steps to create a general prefilter. - Determine required steps to create an authorization-based prefilter - Given a scenario where users should see only sale totals for their country, identify the type of filter to create. |
Building a SAS BI Dashboard Application |
|
| Build SAS BI Dashboard Components. |
- Explain the process for designing dashboard components. - Identify the steps required to build a dashboard. - Describe the four data sources you can use when you define indicator data. - When creating indicator data, use the Data Mapping tab to associate properties with data columns in the data source. - Use an information map as a data source for an indicator object. - Use an SQL query as the data source for an indicator data object. - List the different components that are used to create dashboards. - List the steps required to create an indicator. - Explain the purpose of the indicator configuration icons. - Describe how indicator display types aggregate data. - Determine what you must define when you create and indicator. - Set dashboard properties. |
| Build advanced SAS BI Dashboard Components. |
- Define and create ranges. - Identify the indicator types that support ranges. - Add interactive features to dashboards such as adding interactions between indicators and linking indicators to other content. - Describe the categories of indicator properties. - Enable the zoom feature for an indicator or static content. |
Building Stored Processes |
|
| Create a stored process from a SAS Enterprise Guide Project. |
- Explain the steps to create a stored process. - Identify the types of stored process metadata. - List the types of servers that a stored process can run on. - Explain the differences between creating a stored process from a single task versus all the tasks in a SAS Enterprise Guide project. - Describe the extra step required to create a stored process from more than one of the tasks, but not from all of the tasks in a SAS Enterprise Guide project. - Use the metadata LIBNAME engine to reference data library metadata definitions. - When using the Create New Stored Process wizard, determine the code that you want the wizard to include in the stored process. |
| Create a stored process from a SAS Program. |
- Identify the stored process code elements. - Define the Create New Stored Process Wizard steps when you create a stored process from SAS code in SAS Enterprise Guide. - Create a stored process from existing SAS code in SAS Enterprise Guide. - List the applications that can be used to register stored process metadata. - Create a stored process that writes directly to the _WEBOUT fileref. - Explain how prompt values are resolved in the SAS code. |
| Add prompts to a stored process. |
- In a SAS Enterprise Guide project, create prompts that are used when creating a SAS Stored Process. - Identify the types of stored process prompts. - Explain how to populate prompt values. - Establish dependencies between prompts. - Define the requirements for establishing prompt dependencies. |
| Create a stored process to provide a dynamic data source. |
- Identify the requirements for a stored process providing a dynamic data source to an information map including the execution server, permissions, and the result capabilities. - Create an information map using dynamic data source created by a stored process. |
| Define the macro variables generated for each prompt type. |
- Describe how stored processes pass user values to the stored process code. - Identify the macro variables that are created for different prompt types. - Define and process a stored process parameter that can accept multiple values. |
| Create shared prompts. |
- Identify the three types of prompt groups. - List the steps to create a shared prompt. - Define the attributes that can be customized when you use a shared prompt. - Describe the process to unshare a shared prompt. |
Utilizing Multidimensional (OLAP) Data Sources |
|
| Apply Online Analytical Processing concepts. | - Define OLAP terminology including cube, dimension, level, and hierarchy. |
| Build an OLAP cube with SAS OLAP Cube Studio. |
- Use the Cube Designer Wizard to build a cube to perform such tasks as
- Modify existing OLAP code to perform actions such as adding a calculated measure, updating the cube and coalescing cube aggregations. |
| Build an information map from a SAS OLAP Cube. |
- Describe the factors you should take into consideration when you build information maps with an OLAP data source. - Explain what the MDX language is and when to use it. - Create an information map that is based on an OLAP cube. |
The SAS has created this credential to assess the knowledge and understanding of a candidate in the area as above via the certification exam. The SAS BI Content Developer (A00-270) Certification exam contains a high value in the market being the brand value of the SAS attached with it. It is highly recommended to a candidate to do a thorough study and also get a hand full of the practice to clear SAS Certified BI Content Developer for SAS 9 exam without any hiccups.