HOTSPOT (Drag and Drop is not supported)You have a Fabric workspace named Workspace1 and an Azure Data Lake Storage Gen2 account named storage1. Workspace1 contains a lakehouse named Lakehouse1.You need to create a shortcut to storage1 in Lakehouse1.Which protocol and endpoint should you specify? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: abfssAccess Azure storageOnce you have properly configured credentials to access your Azure storage container, you can interact with resources in the storage account using URIs. Databricks recommends using the abfss driver for greater security.spark.read.load("abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/<path-to-data>") dbutils.fs.ls("abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/<path-to-data>") CREATE TABLE <database-name>.<table-name>;COPY INTO <database-name>.<table-name>FROM 'abfss://container@storageAccount.dfs.core.windows.net/path/to/folder' FILEFORMAT = CSVCOPY_OPTIONS ('mergeSchema' = 'true');Box 2: dfsdfs is used for the endpoint:dbutils.fs.ls("abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/<path-to-data>")
https://docs.databricks.com/en/connect/storage/azure-storage.html
You have an Azure Repos Git repository named Repo1 and a Fabric-enabled Microsoft Power BI Premium capacity. The capacity contains two workspaces named Workspace1 and Workspace2. Git integration is enabled at the workspace level.You plan to use Microsoft Power BI Desktop and Workspace1 to make version-controlled changes to a semantic model stored in Repo1. The changes will be built and deployed to Workspace2 by using Azure Pipelines.You need to ensure that report and semantic model definitions are saved as individual text files in a folder hierarchy. The solution must minimize development and maintenance effort.In which file format should you save the changes?
Power BI Desktop projects (PREVIEW)Power BI Desktop introduces a new way to author, collaborate, and save your projects. You can now save your work as a Power BI Project (PBIP). As a project, report and semantic model item definitions are saved as individual plain text files in a simple, intuitive folder structure.
https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table that has one million Parquet files.You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained.What should you do?
Answer(s): D
VACUUMApplies to: check marked yes Databricks SQL check marked yes Databricks Runtime Remove unused files from a table directory.VACUUM removes all files from the table directory that are not managed by Delta, as well as data files that are no longer in the latest state of the transaction log for the table and are older than a retention threshold.Incorrect:Not B: What is Z order optimization?Z-ordering is a technique to colocate related information in the same set of files. This co-locality is automatically used by Delta Lake on Azure Databricks data-skipping algorithms. This behavior dramatically reduces the amount of data that Delta Lake on Azure Databricks needs to read.Not C: Delta Lake table optimization and V-OrderV-Order is a write time optimization to the parquet file format that enables lightning-fast reads under the Microsoft Fabric compute engines, such as Power BI, SQL, Spark, and others.Power BI and SQL engines make use of Microsoft Verti-Scan technology and V-Ordered parquet files to achieve in-memory like data access times. Spark and other non-Verti-Scan compute engines also benefit from the V-Ordered files with an average of 10% faster read times, with some scenarios up to 50%.V-Order works by applying special sorting, row group distribution, dictionary encoding and compression on parquet files, thus requiring less network, disk, and CPU resources in compute engines to read it, providing cost efficiency and performance. V-Order sorting has a 15% impact on average write times but provides up to 50% more compression.
https://docs.databricks.com/en/sql/language-manual/delta-vacuum.html https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order?
You have a Fabric tenant that contains a lakehouse named Lakehouse1.You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.What should you configure?
Default Power BI semantic models in Microsoft FabricSync the default Power BI semantic modelPreviously we auto added all tables and views in the Warehouse to the default Power BI semantic model. Based on feedback, we have modified the default behavior to not automatically add tables and views to the default Power BI semantic model. This change will ensure the background sync will not get triggered. This will also disable some actions like "New Measure", "Create Report", "Analyze in Excel".If you want to change this default behavior, you can:Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace. This will restart the background sync that will incur some consumption costs.2. Manually pick tables and views to be added to semantic model through Manage default Power BI semantic model in the ribbon or info bar.NOTE: Understand what's in the default Power BI semantic modelWhen you create a Warehouse or SQL analytics endpoint, a default Power BI semantic model is created. The default semantic model is represented with the (default) suffix.
https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models
You have a Fabric tenant that contains JSON files in OneLake. The files have one billion items. You plan to perform time series analysis of the items.You need to transform the data, visualize the data to find insights, perform anomaly detection, and share the insights with other business users. The solution must meet the following requirements:Use parallel processing. Minimize the duplication of data.Minimize how long it takes to load the data.What should you use to transform and visualize the data?
PySpark vs Pandas PerformancePyspark has been created to help us work with big data on distributed systems. On the other hand, the pandas module is used to manipulate and analyze datasets up to a few GigaBytes (Less than 10 GB to be specific).So, PySpark, when used with a distributed computing system, gives better performance than pandas. Pyspark also uses resilient distributed datasets (RDDs) to work parallel on the data. Hence, it performs better than pandas.NOTE: PySpark is a Python library that provides an interface for Apache Spark. Spark is an open-source framework for big data processing. Spark is built to process large amounts of data quickly by distributing computing tasks across a cluster of machines.PySpark allows us to use Apache Spark and its ecosystem of libraries, such as Spark SQL for working with structured data.We can also use Spark MLlib for machine learning and GraphX for graph processing using Pyspark in Python.PySpark supports many data sources, including Hadoop Distributed File System (HDFS), Apache Cassandra, and Amazon S3.Along with the data processing capabilities, we can also use pyspark with popular Python libraries such as NumPy and Pandas.
https://www.codeconquest.com/blog/pyspark-vs-pandas-performance-memory-consumption-and-use-cases
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2 and a user named User1.You need to ensure that User1 can perform the following tasks: Create a new domain.Create two subdomains named subdomain1 and subdomain2. Assign Workspace1 to subdomain1.Assign Workspace2 to subdomain2.The solution must follow the principle of least privilege. Which role should you assign to User1?
To achieve the tasks described, User1 needs permissions to manage domains and assign workspaces to subdomains. Here’s a breakdown of the required tasks and the permissions needed:Create a new domain:This requires the ability to manage domains, which is specifically granted by the domain admin role.Create two subdomains (subdomain1 and subdomain2):Subdomains fall under domain management, so the domain admin role is required.Assign workspaces (Workspace1 and Workspace2) to subdomains:Assigning workspaces to subdomains is also a domain management task, which the domain admin role permits.
HOTSPOT (Drag and Drop is not supported)You have a Fabric tenant that contains three users named User1, User2, and User3. The tenant contains a security group named Group1. User1 and User3 are members of Group1.The tenant contains the workspaces shown in the following table.The tenant contains the domains shown in the following table.User1 creates a new workspace named Workspace3. You assign Domain1 as the default domain of Group1.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
User2 is assigned the Contributor role for Workspace3 - NoUser2 is not a member of Group1, and Workspace3 is created by User1. Since Workspace3 is assigned to Domain1 (default domain of Group1), only members of Group1 will have permissions based on their role in the domain. User2 is not part of Group1, so they have no role in Workspace3.User3 is assigned the Viewer role for Workspace3 - NoUser3 is a member of Group1, and the default domain (Domain1) is assigned to Group1. However, there is no indication that User3 has been explicitly granted the Viewer role in Workspace3. If permissions were inherited, User3 would have the default role for Domain1, but the problem does not specify this explicitly, sowe assume no Viewer role is assigned.User3 is assigned the Contributor role for Workspace1 - NoWorkspace1 is explicitly assigned to User1 as the admin. There is no indication that User3 has any permissions for Workspace1. Being a member of Group1 does not grant automatic Contributor access to a workspace unless explicitly configured.
You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains customer data.You need to implement row-level security (RLS) for Table1. The solution must ensure that users can see only their respective data.Which two objects should you create? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): A,E
A database role is used to assign permissions to users or groups. In the context of RLS, you create roles that map to specific user groups or individuals, determining which rows they can access.A security policy is used to enforce row-level security. This is done by creating a filter predicate that limits the rows returned based on a condition, such as the user's identity or a specific column value.
Share your comments for Microsoft DP-600 exam with other users:
52 should be b&c. controller failure has nothing to do with this type of issue. degraded state tells us its a raid issue, and if the os is missing then the bootable device isnt found. the only other consideration could be data loss but thats somewhat broad whereas b&c show understanding of the specific issues the question is asking about.
great help!!!
very useful tools
looks a good platform to prepare az-104
want to pass the exam
good resource
question 11 : d
only the free dumps will be enough for pass, or have to purchase the premium one. please suggest.
good questions. thanks.
good for practice.
great case study
the questions in this exam dumps is valid. i passed my test last monday. i only whish they had their pricing in inr instead of usd. but it is still worth it.
q40 the answer is not d, why are you giving incorrect answers? snapshot consolidation is used to merge the snapshot delta disk files to the vm base disk
thanks, very relevant
wrong answer. it is true not false.
please i need the mo-100 questions
very good use full
very valid questions
will these question help me to clear pl-300 exam?
please provide me with these dumps questions. thanks
in the pdf downloaded is write google cloud database engineer i think that it isnt the correct exam
i think you have the answers wrong regarding question: "what are three core principles of web content accessibility guidelines (wcag)? answer: robust, operable, understandable
these questions are not valid , they dont come for the exam now
question looks valid
good for practice
need more q&a to go ahead
question 59 - a newly-created role is not assigned to any user, nor granted to any other role. answer is b https://docs.snowflake.com/en/user-guide/security-access-control-overview
just passed my exam today. i saw all of these questions in my text today. so i can confirm this is a valid dump.
needed dumps
very helpful
will post once the exam is finished
relevant questions
just clear exam on 10/06/2202 dumps is valid all questions are came same in dumps only 2 new questions total 46 questions 1 case study with 5 question no lab/simulation in my exam please check the answers best of luck
q.112 - correct answer is c - the event registry is a module that provides event definitions. answer a - not correct as it is the definition of event log