Infosys Certified Microsoft SSAS Developer
Practice with real exam-pattern questions for Infosys Certified Microsoft SSAS Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Microsoft SSAS Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Microsoft SSAS Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which data sources can tabular data connect to? (Choose all that apply)
- ✓ relational databases Correct
- B OData feeds
- C files
- D WS-Data web services
- Question 2
A scenario, in which the transactional record (Fact) would have come into the system but the corresponding Dimension/Contextual data is yet to come in, which could be due to various reasons like Improperly Designed Data Load Process, Failure in the ETL Process, and a Technical Glitch in the transactional system causing delay in pushing the Dimension Data.How is this situation handled by SSAS?
- ✓ By creating an Unknown Member. Correct
- B It generates an error during processing the dimension.
- C It generates an error while creating the dimension.
- D This should be taken care in during the ETL process and not while creating the cube.
- Question 3
In a cube the measure Sales Amount and a dimension Customer are linked using Primary Key column Customer Key. This relationship in the Dimension Usage tab is represented as…..................
- ✓
Fact
Correct - B
Many to One
- C
Referenced
- D
Regular
- ✓
- Question 4
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. You need to use an appropriate project type. Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)
- ✓ A tabular project that uses the DirectQuery query mode Correct
- B A tabular project that uses the In-Memory query mode
- C A multidimensional project that uses the ROLAP storage mode
- D A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
- E A multidimensional project that uses the MOLAP storage mode
- Question 5
Which one of the following will define the level of detail in the dimension hierarchy?
- ✓ Grain Correct
- B Dimension elements
- C Dimension attributes
- D Both Dimension elements and Dimension attributes.
- Question 6
Identify the schema where every dimension table is directly related to a fact table.
- ✓
Star
Correct - B
Snowflake
- C
Star constellation
- D
Relational
- ✓
- Question 7
Point out the correct statement
- ✓ The permissions of a role may allow members to access and administer the database Correct
- B Server roles, roles defined by administrators to control access to objects and data for non-administrator user
- C Database roles, roles defined by administrators to control access to objects and data for administrator user
- D None of the above mentioned
- Question 8
Which of the following attribute relationships are present in SSAS? Select TWO correct options.
- ✓
Rigid
Correct - B
Flexible
- C
Constant
- D
Variable
- ✓
- Question 9
A multidimensional cube stores the list of top 5 customer data with respect to sales data. To create this list which of the following expressions should be used?
- ✓
DMX Expressions
Correct - B
MDX Expressions
- C
DAX Expressions
- D
Both MDX and DAX
- ✓
- Question 10
If we have to query a tabular model which of the following queries can be used?
- ✓ DMX queries Correct
- B DAX queries
- C MDX queries
- D MDX and DMX queries
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.