Examen
SSIS +SSRS+SSAS + TESTING EXAM QUESTIONS AND VERIFIED ANSWERS
- Cours
- Établissement
SSIS +SSRS+SSAS + TESTING EXAM QUESTIONS AND VERIFIED ANSWERS...
[Montrer plus]
Vendeur
S'abonner
luzlinkuz
Avis reçus
Aperçu du contenu
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?
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur luzlinkuz. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €12,66. Vous n'êtes lié à rien après votre achat.
Peut-on faire confiance à Stuvia ?
4.6 étoiles sur Google & Trustpilot (+1000 avis)
78252 résumés ont été vendus ces 30 derniers jours
Fondée en 2010, la référence pour acheter des résumés depuis déjà 14 ans