Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Erwin Data Modeler Test

Topics Covered

  • Components
  •  Architecture
  • Conceptual Data Model
  • Dimensional Model
  •  Entities
  • Fact table
  •  Design

Useful for hiring

  • Erwin Data Modeler
  • Data Architect- Erwin
  • Data Modeler Engineer

Start hiring job-fit candidates using this assessment

GET A DEMO

"Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. Interview Mocha helped us to cut down on our candidate filtration time by 40%, making it our preferred assessment tool."

Pedro Furtado, Altran,
Capacity Manager
Question

While designing a data model for an insurance company , we came across the situation where we are making relationship between customer entity and dependent entity(the one who are dependent on customer) for which the company is providing insurance but the primary key of dependent entity is comprised or primary key of customer and a partial key ? why is there such situation in the data model?

Answer
    • Dependent entity is a strong entity , hence the behaviour.

    • Dependent entity is a weak entity , hence the behaviour.

    • Customer entity is a weak entity , hence the behaviour.

    • Our design approach is wrong.

Question

We are designing a datawarehouse for a pet supplier chain which sells products for dogs ,cats and rabbits ,which is the best way to avoid many to many in this scenario where are dealing with only three different types of pets.

Answer
    • Using Bridge table.

    • Adding multiple named attributes to the dimension table.

    • No need to avoid many to many in this scenario.

    • Adding a single concatenated text string with delimited attribute values to the dimension.

Question

We have been asked to design an audit dimension for a Sales fact , which are the key elements which we should include in our design?

Answer
    • Audit Dimension should include Data Quality indicators.

    • Audit Dimensions should only have environment variables.

    • Audit Dimension should include Data Quality indicators and environment variables.

    • Audit Dimension can be designed without using environment variables.

Test details:

Erwin data modeler screening test will evaluate candidate's practical knowledge and will identify whether the candidate is ready to be employed. Erwin data modeler test can be taken by candidates from anywhere in the comfort of their time zone.

Erwin data modeler screening test may contain MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, Whiteboard Questions, Audio / Video Questions, True or False.


Test Duration: 20 minutes

10 Application Questions

Test description:

Erwin is a leading tool that provides the database engineers to enter their entity-relationship (ER) diagrams in a graphical method and further helps to generate physical database strategies for common relational database management systems such as Microsoft SQL Server and Oracle.  It also supports a pattern of features of database strategy, that includes modeling of data, forward engineering, and reverse engineering for a wide-ranging variety of relational DBMS, including Oracle, Microsoft Access, Sybase, and DB2.
 
Erwin data modeler test helps technical recruiters and hiring managers to assess candidate’s ability to work on Erwin data modeler. Erwin data modeler competency test is created & validated by experienced industry experts to assess & hire Erwin data modeler as per the industry standards.
 
Competency test for Erwin data modeler helps to screen the candidates who possess traits as follows: 
 
1.  Excellent experience with handling all ER diagrams
2.  Capability to create/maintain conceptual, logical and physical data models
3.  Familiarity with analysis of content and quality of data model(s) and databases
4.  Knowledge of SQL database system (including entities, attributes and relationships)
5.  Ability to manage the complex data in the Erwin tool smoothly 

Interview Mocha’s comprehensive reporting will help you overview candidate’s performance in each section within a glance. Candidate feedback module will ensure candidates are having excellent experience with Interview Mocha.

Erwin data modeler competency test is designed with consideration of EEOC guidelines for candidate assessment. It will help recruiters to assess and hire diverse talent without any bias.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO