Exam (elaborations)
SSIS +SSRS+SSAS + TESTING EXAM QUESTIONS AND VERIFIED ANSWERS
- Course
- Institution
SSIS +SSRS+SSAS + TESTING EXAM QUESTIONS AND VERIFIED ANSWERS...
[Show more]
Content preview
SSIS +SSRS+SSAS + TESTING EXAM QUESTIONSAND VERIFIED ANSWERS
The developer creates an SSIS package to load data from a comma-delimited
file. The developer notices that by default all of the columns are treated as string
data type with a length of 50 characters. Which of the following methods will
estimate the appropriate data type for each column?
A. Data Profiling task
B. Data Conversion transformation
C. Derived Column transformation
D. Show Advanced Editor
E. Click the Suggest Types button on the Advanced tab of the Flat File
Connection Manager form
Which of the following are valid reasons for installing an SSISDB Catalog?
A. To replicate packages to another instance
B. To create multiple levels of securable for accessing SSIS packages
C. To provide a document repository for storing Microsoft Word descriptions of
the packages
D. To quality control check data flow tasks
E. To provide detailed logging for unit testing
A developer must create an SSIS package that pulls data from a database table
and a flat file. It must then put all of the rows from the database table and all of
the rows from the flat file into another database table. Which of the following
transformations will achieve this goal?
A. Union All transformation
B. Merge Join Transformation
C. Derived Column transformation
D. A SQL join in the data source
E. Conditional Split transformation
The developer creates an SSIS package that includes the tasks in the image
below. Based on this, which of the following statements are correct if the SQL 1
task fails for a divide by zero error?
A. SQL 4 Completion task executes.
, B. None of the tasks execute.
C. SQL 2 task executes.
D. The SSIS package quits because of an unhandled exception.
E. SQL 3 task executes.
The property AttributeHierarchyEnabled = False indicates that an attribute
cannot be used in which of the following SSAS hierarchies? A. A balanced
hierarchy □B. A ragged hierarchy C. A user-defined hierarchy D. A natural
hierarchy E. An unbalanced hierarchy
A developer creates an SSIS package and adds a variable called Mylnt of the
type Int32 at the Package level scope. The developer then uses that variable in a
Script task, adding the variable to the ReadWriteVariable3 list. The developer
tries the code below (C# and VB.NET versions included) and receives the error
below. Which of the following correctly describe causes and solutions of this
error? C#: int myVariable = (int)Dts.Variables["User::myint"].Value; VB.NET:
Dim myVariable A3 Integer = CType(Dts.Variables("User::myint").Value,
Integer)
Error: The element cannot be found in a collection. This error happens when
you try to retrieve an element from a collection on a container during execution
of the package and the element is not there.
A. The Mylnt variable needs to be added to the ReadOnlyVariables list.
B. The user does not have permission to use variables.
C. The string User: :myint should be User: :MyInt. D. The string User: :myint
should be System: :myint. E. The variable Mylnt is in the wrong scope.
Which of the following will be used in SSRS to conditionally send a report on a
regular basis to a dynamic list of users who do not always have access to the
company's file system?
A. SQL with a File Share subscription
B. Both Data Driven and Standard subscriptions
C. Both Email and File Share delivery extensions
D. An Email delivery extension with a Data Driven subscription
E. SQL with an Email delivery extension
A reporting application requires common queries that may be used within
multiple reports within the application. Which of the following methods will
provide an easily maintainable solution to achieve this in SSRS?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78252 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now